MySQL Forums
Forum List  »  Partitioning

Partitioning across multiple drives
Posted by: Andy Grove
Date: August 06, 2007 04:15PM

I would like to use MySQL partitioning to distribute a table across two physical hard drives in the hope of improving performance of concurrent writes to that table.

According to another thread in this forum it is not possible to specify the location of partitions when using InnoDB.

So my questions are:

1. Have I understood this correctly i.e. I must use MyISAM if I want to partition across multiple disks?
2. Are there plans to support paritioning of InnoDB tables with user-specified locations?


Andy Grove

Options: ReplyQuote

Written By
Partitioning across multiple drives
August 06, 2007 04:15PM

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.