Tag

Explain Analyze

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
May 13, 2025 · Databases

Visualizing MySQL Execution Plans with Flame Graphs

This article explains how to use Flame Graphs to visualize MySQL execution plans, discusses the limitations of traditional EXPLAIN output, introduces the EXPLAIN ANALYZE feature in MySQL 8.0, provides sample SQL and command‑line usage, and shows how the visual tool helps quickly identify performance bottlenecks.

Database OptimizationExplain AnalyzeFlame Graph
0 likes · 11 min read
Visualizing MySQL Execution Plans with Flame Graphs
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 25, 2019 · Databases

Understanding MySQL 8.0.18 EXPLAIN ANALYZE: Usage, Output, and Performance Insights

MySQL 8.0.18 adds the EXPLAIN ANALYZE feature, which runs a query and reports actual execution times, row counts, and loop iterations, enabling developers to compare estimated costs with real performance and fine‑tune their queries for better efficiency.

Explain AnalyzePerformance TuningQuery Optimization
0 likes · 8 min read
Understanding MySQL 8.0.18 EXPLAIN ANALYZE: Usage, Output, and Performance Insights