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:

Options: ReplyQuote

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