MySQL Forums :: Partitioning :: subpartiton by key doesn't evenly distribute data


Advanced Search

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
subpartiton by key doesn't evenly distribute data 1326 jongse park 06/10/2015 11:20PM
Re: subpartiton by key doesn't evenly distribute data 691 Rick James 06/13/2015 08:25AM
Re: subpartiton by key doesn't evenly distribute data 736 jongse park 06/15/2015 12:01AM
Re: subpartiton by key doesn't evenly distribute data 683 Rick James 06/15/2015 07:07PM
Re: subpartiton by key doesn't evenly distribute data 787 jongse park 06/15/2015 10:41PM
Re: subpartiton by key doesn't evenly distribute data 727 Rick James 06/16/2015 07:36PM


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.