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.
Speaker card
