Re: subpartiton by key doesn't evenly distribute data

[jongse park]

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