Skip to content

MySQL Query Response Time Details

!image

Average Query Response Time

The Average Query Response Time graph shows information collected using the Response Time Distribution plugin sourced from table INFORMATION_SCHEMA.QUERY_RESPONSE_TIME. It computes this value across all queries by taking the sum of seconds divided by the count of queries.

Query Response Time Distribution

Query response time counts (operations) are grouped into three buckets:

  • 100 ms - 1 s

  • 1 s - 10 s

  • > 10 s

Average Query Response Time

Available only in Percona Server for MySQL, provides visibility of the split of READ vs WRITE query response time.

Read Query Response Time Distribution

Available only in Percona Server for MySQL, illustrates READ query response time counts (operations) grouped into three buckets:

  • 100 ms - 1 s

  • 1 s - 10 s

  • > 10 s

Write Query Response Time Distribution

Available only in Percona Server for MySQL, illustrates WRITE query response time counts (operations) grouped into three buckets:

  • 100 ms - 1 s

  • 1 s - 10 s

  • > 10 s

Get expert help

If you need assistance, you can find comprehensive and free database knowledge on our community forum or blog posts. For professional support and services, contact our Percona Database Experts.