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

  • Page updated 2021-02-10

Contents

Previous page

MySQL Performance Schema Details

Next page

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.