MySQL Workbench: Performance
MySQL Workbench provides tools for understanding database activity and improving SQL performance. Use Performance Reports, client-connection investigation, and visual query-plan analysis to move from a symptom to useful detail.
Performance Reports
Choose from focused Performance Reports to investigate the areas that need attention. Review Slow Queries to inspect the history of slow statements, or use Statement Histogram to understand the distribution of statement execution times. Table Sizes groups data and index storage by schema, Memory shows current memory usage from sys schema views, and Waits shows cumulative wait latency by class, event, host, or user.
Use the report controls to focus the results—for example, on the top queries ranked by average latency—and move from a summary to the statements and resources behind it.
Visual Explain and Visual Explain Analyze
Visual Explain provides a redesigned graphical representation of query execution plans, including support for newer MySQL capabilities such as the hypergraph optimizer and HeatWave query plans. Use Visual Explain Analyze when you want to compare the plan with runtime behavior.
Investigate Active Work
Use Client Connections to examine active sessions in context. Review connection details, statements, locks, and history to understand what is running and where work may be blocked.
Improve SQL Development Workflows
While working in the SQL editor, use SQL formatting and updated code completion to make routine query development faster and clearer. Always use the latest version of MySQL Workbench for current performance capabilities.