Try out Falcon tablespaces
First, I’d like to thank everyone who’s downloading and testing the latest MySQL 6.0 Alpha release that contains our new Falcon transaction storage engine. For those of you who haven’t yet, let me point out something you may have missed (heck, maybe those of you who’ve already downloaded 6.0 have missed it too…) - the latest release contains the first cut of Falcon tablespaces. We get requests all the time that storage engines support the concept of tablespaces, and with Falcon, you’ve got them now. You can create user-defined tablespaces via DDL, assign your tables/indexes to whichever tablespaces you want via CREATE TABLE, and move objects to different tablespaces with simple ALTER TABLE commands.
I’ve written a quick primer on Falcon tablespaces that will help get you started, so check that out and then download 6.0 and give ‘em a try.