MySQL Forums
Forum List  »  Partitioning

Re: Linear Partioning vs Ordinary
Posted by: Rick James
Date: March 19, 2010 08:09AM

Please describe your situation, then we can discuss how (and whether) distribution techniques may (or may not) help.

Note that default modulo is some simple formula that is not necessarily correctly balanced. Suggest you have a prime number of partitions.

Or, that the MD5 (or other digest) of the primary key to get a more random scattering. Note that it must part of the PK; suggest you put it at the end. 8 bits of the MD5 would let you have 256 partitions with a mere 1-byte overhead.

Options: ReplyQuote


Subject
Views
Written By
Posted
4469
March 15, 2010 02:31AM
Re: Linear Partioning vs Ordinary
2216
March 19, 2010 08:09AM


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.