MySQL Forums
Forum List  »  Partitioning

Re: Partitioning across multiple drives
Posted by: Mikael Ronström
Date: September 12, 2007 11:33AM

Hi,

Andy Grove Wrote:
-------------------------------------------------------
> 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?

MyISAM or NDB.

> 2. Are there plans to support paritioning of
> InnoDB tables with user-specified locations?

This is a question for the InnoDB team.

Rgrds Mikael

Options: ReplyQuote


Subject
Views
Written By
Posted
5761
August 06, 2007 04:15PM
Re: Partitioning across multiple drives
3185
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.