MySQL Forums
Forum List  »  Partitioning

Re: Data not balanced in partitions
Posted by: Rick James
Date: November 28, 2011 11:25AM

PARTITION BY KEY uses a very simple hash. Even if the key is random enough, the partitions will rarely be "perfectly" balanced.

How many rows do you expect when the table is filled?

Why do this PARTITIONing? This is a serious question. I can't think of any performance benefit. I can't think of any coding benefit. Or any other benefit.

Options: ReplyQuote


Subject
Views
Written By
Posted
2633
November 26, 2011 05:41AM
1249
November 26, 2011 12:34PM
1561
November 26, 2011 12:51PM
Re: Data not balanced in partitions
1415
November 28, 2011 11:25AM


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.