myflames — MySQL Query Plan Visualizer

Demos of the plan views in the myflames desktop app: flame graph, bar chart, Visual Explain and execution tree, drawn from real EXPLAIN ANALYZE FORMAT=JSON plans. View on GitHub →

Documentation

Learn the algorithms

Interactive, offline-first HTML lessons that animate MySQL 8.4 and MariaDB 11.x internals with correct cost models. Every lesson has in-page sliders. The same lessons are in the desktop app's Learn place.

Storage internals Join algorithms
Query optimization

All 9 lessons with descriptions →

Flame graph — full execution hierarchy (default view)

Open full page (interactive) →

Bar chart — slowest operations first

Open full page (interactive) →

Diagram — Visual Explain-style flow

Open full page (interactive) →

Execution tree — collapsible plan tree

Open full page (interactive) →

Query Analysis panel — scenario demos

Each view includes a Query Analysis panel: optimizer features detected, warnings, and concrete tuning suggestions.

Complex queries — real-world patterns

Non-trivial query shapes captured live against MySQL 8.4: multi-CTE with window functions, correlated subqueries (the N+1 anti-pattern), and recursive CTEs for tree traversal. Each demo pipes through the advisor + collector pipeline and emits a JSON sidecar next to the HTML so AI agents and external tools can consume the analysis without parsing the SVG.

CTE + window functions

Top-3 earners per department using ROW_NUMBER() OVER (PARTITION BY …).

Correlated subquery

N+1 anti-pattern: per-row scalar subquery to look up max/count.

Recursive CTE

Org-chart traversal — anchor + recursive JOIN until depth limit.

Optimizer switches — one flag per demo

Plans captured live with a specific @@optimizer_switch feature active, so you can see what each switch looks like in a real EXPLAIN plan and read the one-line impact the advisor emits.

Live plans from real servers

Plans captured live from MySQL 8.4 and MariaDB 11.4. Each one embeds the collected schema, statistics and session variables, plus tuning suggestions from the advisor.

HTML report — self-contained shareable report

A standalone report with the chart, the analysis sidebar and export buttons.

Open HTML report demo →

Before vs After comparison

Time deltas, operator changes and a "what got better / worse" summary.

Open comparison demo →

Repository and README • Handbook