MySQL Query Response Time Details¶
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.