Re: Partition and subpartition are different column

[Rick James]

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.