Brendan Gregg developed flame graphs, which provide a powerful way to visualize hierarchical data. Later on, Tanel Poder introduced the same concept for Oracle queries. This time, I’m bringing this idea for the first time as an open-source project to MySQL. Using the new JSON format for MySQL, we can now perform detailed query analysis based on the actual execution plan, displaying the query’s internal operations in a way that can be programmatically consumed and visualized. In this session, we will walk through how to transform raw execution-plan data into flame graphs and explore the benefits that visualization brings and how it helps us to interpret and diagnose query behavior.
Bringing Flamegraphs to MySQL Query Optimization
Speaker card
