MySQL Forums
Forum List  »  Partitioning

Re: Partition and subpartition are different column
Posted by: Rick James
Date: July 28, 2012 12:42PM

PARTITIONing for the sake of partitioning is unlikely to provide any benefit. There are only a few use cases where PARTITION helps performance.

Rule of Thumb: Use PARTITION only if you have more than a million rows.
More of my RoTs can be found in the PARTITION section of
http://mysql.rjweb.org/doc.php/ricksrots

To discuss further, please provide SHOW CREATE TABLE, the various SELECTs, whether you have a "purge" policy, etc.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition and subpartition are different column
1344
July 28, 2012 12:42PM


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.