Aikesheng Open Source Community

May 30, 2023 · Databases

Understanding MySQL Optimizer Trace: Viewing the Full Query Optimization Process

This article explains how to enable MySQL's optimizer_trace feature, retrieve the detailed execution plan from the information_schema.OPTIMIZER_TRACE table, and interpret the cost‑based optimization phases (prepare, optimize, execute) to understand why the optimizer selects a particular index for a query.