MySQL Forums
Forum List  »  InnoDB

How do I control which table on which disk? (MySql 5, Multiple tablespaces)
Posted by: Tore Krudtaa
Date: November 02, 2005 06:35AM

Hi.

I want to use multiple tablespaces.

I also would like to control which disk each of the tables are stored.
Would also like to make this work on both linux and windows.
At least in linux where my production data are.

Would like to see some example on how to configure this, if possible.
Have looked through MySql documentation and also the link below without finding any examples on how to do that.

Any suggestions?

Ref. mysql.com in this link:
http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html


" Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of the remaining InnoDB tables.
"

Options: ReplyQuote


Subject
Views
Written By
Posted
How do I control which table on which disk? (MySql 5, Multiple tablespaces)
2098
November 02, 2005 06:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.