[HN Gopher] Visualize MySQL query execution plans as interactive...
___________________________________________________________________
Visualize MySQL query execution plans as interactive FlameGraphs
Author : tanelpoder
Score : 61 points
Date : 2026-02-06 22:02 UTC (5 days ago)
(HTM) web link (github.com)
(TXT) w3m dump (github.com)
| vgrippa wrote:
| Thanks for posting!
| dveeden2 wrote:
| 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.
| lofaszvanitt wrote:
| Any slides maybe?
| vgrippa wrote:
| You can find the slides here: https://github.com/vgrippa/pres
| entations/blob/main/2026_FOSD...
| lofaszvanitt wrote:
| Do you have slides from your FOSDEM presentation? The video has
| this funny angle :(.
| vgrippa wrote:
| Hi!
|
| The slides can be found here:
| https://github.com/vgrippa/presentations/blob/main/2026_FOSD...
| javier2 wrote:
| Thanks for sharing!
| hobs wrote:
| 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.
| bonesss wrote:
| That feeling when your fancy graph points out the obvious, and
| 'bad thing bad' is the only takeaway.
|
| Data science <pew pew>!
| ab_testing wrote:
| 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.
| vgrippa wrote:
| Indeed, but it was easier to implement the logic since original
| flamegraphs are in Perl.
| bmn__ wrote:
| 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
| vgrippa wrote:
| Thanks for the suggestion. Actually I received some feedback to
| produce something like flamescope from netflix
| https://github.com/Netflix/flamescope
|
| I will take a look at the treemaps and try to incorporate.
___________________________________________________________________
(page generated 2026-02-11 23:01 UTC)