MySQL Forums
Forum List  »  Partitioning

Re: subpartiton by key doesn't evenly distribute data
Posted by: jongse park
Date: June 15, 2015 10:41PM

Thanks for your reply.

I wander that Key partitioning is used primaryly to ensure an even distribution of data like hash partitioning.

This is about Hash Partitioning:
https://dev.mysql.com/doc/refman/5.6/en/partitioning-hash.html
-----------------------------------------------------------------------------
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions.
-----------------------------------------------------------------------------

And then This is about Key Partitioning;
https://dev.mysql.com/doc/refman/5.6/en/partitioning-key.html
------------------------------------------------------------------------------
Partitioning by key is similar to partitioning by hash
------------------------------------------------------------------------------

Is there a performance issue in my table schema.
What do I have to change for the table schema ?


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: subpartiton by key doesn't evenly distribute data
868
June 15, 2015 10:41PM


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.