Visualize MySQL query execution plans as interactive FlameGraphs

#1

Post by tanelpoder » Fri, Feb 06, 2026, 10:02 PM UTC

Visualize MySQL query execution plans as interactive FlameGraphs
github.com

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#2

Post by vgrippa » Sat, Feb 07, 2026, 12:24 AM UTC

Thanks for posting!

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#3

Post by dveeden2 » Wed, Feb 11, 2026, 2:02 PM UTC

The video from the presentation on this: https://youtu.be/tdx9leN2kBg?si=uYa7xsOvpoonjaxB

This was part of the MySQL Belgian Days that was organized in the days before FOSDEM.

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#4

Post by lofaszvanitt » Wed, Feb 11, 2026, 2:27 PM UTC

dveeden2 wrote: post #3

The video from the presentation on this: https://youtu.be/tdx9leN2kBg?si=uYa7xsOvpoonjaxB This was part of the MySQL Belgian Days that was organized in the days before FOSDEM.

Any slides maybe?

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#5

Post by lofaszvanitt » Wed, Feb 11, 2026, 2:28 PM UTC

Do you have slides from your FOSDEM presentation? The video has this funny angle :(.

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#6

Post by javier2 » Wed, Feb 11, 2026, 3:19 PM UTC

Thanks for sharing!

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#7

Post by hobs » Wed, Feb 11, 2026, 3:56 PM UTC

Hah I did this for SQL Server execution graphs at one point (via profiler or extended events) and then I of course realized that anything that goes more than one or two events deep is just hellish SQL anyway, love to see the execution plan version that's much smarter.

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#8

Post by bonesss » Wed, Feb 11, 2026, 4:18 PM UTC

hobs wrote: post #7

Hah I did this for SQL Server execution graphs at one point (via profiler or extended events) and then I of course realized that anything that goes more than one or two events deep is just hellish SQL anyway, love to see the execution plan version that's much smarter.

That feeling when your fancy graph points out the obvious, and ‘bad thing bad’ is the only takeaway.

Data science !

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#9

Post by ab_testing » Wed, Feb 11, 2026, 4:50 PM UTC

Very cool but also more interesting is using Perl for any newish project.

It is hard to find maintainers or developers knowing Perl nowadays. Especially in data science related projects as python has been the de-facto tool for that field for some time now.

Re: Visualize MySQL query execution plans as interactive FlameGraphs

#10

Post by bmn__ » Wed, Feb 11, 2026, 5:13 PM UTC

If I were in vgrippa's place, I would have not produced flamegraphs, but treemaps. It's the far superior choice for visualising profiling/query plans and the like, no matter along which property one would measure.

Munging the mysql output into something that is delectable as input to kcachegrind is straight-forward. Screenshots: https://ddg.gg/?q=%21i+kcachegrind