Revamp MySQL Query Optimization and Overcome Slowness of ORDER BY with LIMIT Queries
Percona
DECEMBER 21, 2023
However, for 16 years since 2007, the MySQL query optimizer has had a “bug” that not only makes LIMIT 1 slower than LIMIT 10 but can also make the former a table scan, which tends to cause problems. The MySQL team tested and analyzed most of the bugs reported in this area and identified the above problems with the algorithm.
Let's personalize your content