MySQL Forums
Forum List  »  Custom Storage Engines

MYSQL Key Partitioning - Uneven Distribution of data across partitions
Posted by: prikshat heera
Date: August 30, 2013 03:27PM

Hi

We are facing issues with uneven distribution of data across key partitions. The partition key is a UUID column. When we create 36 partitions, only 9 partitions are populated and when we create 100 partitions, only 25 partitions get populated. What could be the cause of that ? Is there some issue with MYSQL key partition while working with UUIDs?

Also, is there a way to customize the MYSQL key partitioning implementation so that we could use something like mod(crc32(<UUID column>),36)

Thanks for your help.
Prikshat

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL Key Partitioning - Uneven Distribution of data across partitions
4818
August 30, 2013 03:27PM


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.