MySQL / MariaDB DBA

Query Performance & EXPLAIN

Question

EXPLAIN versus execution-aware plan analysis: what differs, and when should each be used?

Answer

EXPLAIN reports the optimizer’s intended access plan and estimates. Execution-aware analysis runs the statement and reports observed work; use it on representative, safe workloads to test estimate accuracy. Applies to MySQL and MariaDB.

This is 10 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples