MySQL Forums
Forum List  »  Partitioning

Re: how to partition a table with string type unique column .
Posted by: Mattias Jonsson
Date: August 16, 2012 02:16AM

All partitioning fields must be part of all unique keys (including the primary key).

HASH partitioning works only on integer columns (uid), KEY partitioning works on all columns.

Please read more about it in the manual:
http://dev.mysql.com/doc/refman/5.1/en/partitioning.html

In 5.5 you can also use RANGE/LIST COLUMNS partitioning.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to partition a table with string type unique column .
1904
August 16, 2012 02:16AM


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.