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?
Thanks,
Andy Grove
http://www.codesuccess.com/blog/
Subject
Views
Written By
Posted
Partitioning across multiple drives
6762
August 06, 2007 04:15PM
3444
September 12, 2007 11:33AM
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.