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:

  • 100ms - 1s

  • 1s - 10s

  • > 10s

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:

  • 100ms - 1s

  • 1s - 10s

  • > 10s

Write Query Response Time Distribution

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

  • 100ms - 1s

  • 1s - 10s

  • > 10s

  • Page updated 2020-11-23

Contents

Previous topic

MySQL Performance Schema Details

Next topic

MySQL Replication Summary

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.