Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes ! This is not a new problem: bugs about this can be traced back to 2014, and a blog post on this subject was published in 2015. But even if this […]
Read MoreMySQL Optimizer: Naughty Aberrations on Queries Combining WHERE, ORDER BY and LIMIT
