Re: MySQL Partitioning showing low performance

[Rick James]

> Is there any record count till which doing partitioning could be useful for the above query? Or is it that partitioning is not a good idea at all for this specific query?

I have a Rule of Thumb: Do not partition a table unless it has at least a million rows.
-- http://mysql.rjweb.org/doc.php/ricksrots

But, that is not what you asked. I know of 3 uses for Partitioning. Only one of them speeds up by using PARTITIONs. That case involves 2-dimensional lookups.

Partitioning does not help that particular query, regardless of how many rows it returns.

Partitioning _may_ help some other query.