As far my knowledge goes there is only 1 tablespace available atm. If you create new datafiles they will get appended to the one and only tablespace.
IF there would be more than one tablespace you would need to specify one as default. You should also be able to "ALTER" a table to another tablespace. Regards, Christian -----Ursprungliche Nachricht----- Von: Rick Flower [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Marz 2002 19:17 An: MySQL Mailing List Cc: Heikki Tuuri Betreff: AW: InnoDB frightens me... Christian Rabe writes: >Are there plans on creating more than on tablesspace plus making them >selectable ? >So that I can tell the DB: >- in which datafiles to store the tablespace X >- in which tablespace to store table Y This is one of the things I was wondering about.. If I have multiple InnoDB tablespaces, and I fire up the MySQL command-line client and issue a "Create Table... TYPE=InnoDB", how do I tell it I want the table created in InnoDB space #1 or #2...?? As far as I can tell, it would appear that MySQL/InnoDB get the deciding vote there.. Perhaps I'm just missing something.. -- Rick --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php