MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Partitions by key alternatively empty
Posted by: Mattias Jonsson
Date: December 14, 2010 04:47AM

You can try to use LINEAR KEY partitioning, which has a different distribution, or change the number of partitions to an uneven number (a prime value would probably be best).

The KEY partitioning calculates a HASH (integer) value from the given key columns, and then uses the modulus operator for the partition id. The LINEAR KEY uses another distribution algorithm, see:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-key.html
http://dev.mysql.com/doc/refman/5.1/en/partitioning-linear-hash.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Partitions by key alternatively empty
3168
Mat N
December 10, 2010 06:24AM
Re: Partitions by key alternatively empty
1585
Rick James
December 11, 2010 02:04PM
Re: Partitions by key alternatively empty
1517
Mat N
December 13, 2010 08:01AM
Re: Partitions by key alternatively empty
1592
Mattias Jonsson
December 14, 2010 04:47AM


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.