Efficient Ops
Feb 9, 2020 · Databases
Why a MySQL Query Took 30 Seconds and How a Hidden Index Cut It to 0.2 s
A production MySQL query on a table with five million rows took over 30 seconds, and after reproducing the issue, examining execution plans, trying various index and query tweaks, discovering that SQLyog adds a hidden LIMIT, and finally forcing the correct index, the runtime dropped to under a second, illustrating the importance of proper index usage and tool‑specific quirks.
Execution PlanIndex OptimizationSQLyog
0 likes · 6 min read