Explore query performance

With telemetry flowing, you can now explore your MySQL query performance using the Queries Overview dashboard. This dashboard is your starting point for identifying slow queries, understanding execution patterns, and finding optimization opportunities.

  1. To explore your MySQL query performance on the Queries Overview dashboard, complete the following steps:

  2. Expand Observability in the navigation menu.

  3. Expand Database in the navigation menu.

  4. Click Queries Overview.

  5. Review the summary metrics at the top of the page: Duration Average (typical query execution time), Errors (total query errors and error percentage), and Rate (queries per second and total count). Spikes in these metrics indicate performance regressions or queries that need investigation.

  6. Scroll down to the query performance table. Each row shows a normalized SQL statement with its duration, call count, errors, and wait events.

  7. Click any query row to drill into its details. The detail view shows explain plans, query samples, and wait event breakdowns for that query.

  8. You’ve explored the Queries Overview dashboard and learned how to identify slow queries and drill into their details.

    From the query detail view, you can:

    • View explain plans showing how MySQL executes the query
    • Examine query samples with individual timing and parameters
    • Analyze wait events revealing resource contention
    • Review table schemas for missing indexes

More to explore (optional)


page 7 of 8