Aikesheng Open Source Community

Feb 2, 2026 · Databases

Unlock MySQL’s Optimizer Trace: Reveal the ‘Why’ Behind Execution Plans

This article explains MySQL’s Optimizer Trace feature, covering its purpose, required system variables, how to enable it, the structure of its JSON output, and how to interpret the preparation, optimization, and execution stages to diagnose query‑plan decisions.