MySQL Forums
Forum List  »  Partitioning

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2712
December 10, 2010 06:24AM
1326
December 11, 2010 02:04PM
1280
December 13, 2010 08:01AM
Re: Partitions by key alternatively empty
1300
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.