MySQL Forums
Forum List  »  Partitioning

Re: Using hash to partition
Posted by: Jonathan Stephens
Date: July 05, 2007 02:50AM

Yes, that should work. The only issue might be that, if the table already contains a lot of data, it could take some time for the rows to be re-allocated to the new partitions.

BTW, PARTITION BY KEY() with no column specified will work if the table has a primary key or unique key; if it doesn't, then you need to specify the column.

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
4573
June 04, 2007 05:17AM
2849
June 14, 2007 03:53PM
2644
July 04, 2007 07:09AM
Re: Using hash to partition
2638
July 05, 2007 02:50AM


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.