On the Query Response Time Distribution graphs, there are no buckets for the <100ms category of queries, of which most of ours fall into. Many queries are sub-1ms, sometimes down at the 300us mark. A typical insert for us would be 7-8ms
How to test
Step1: Start PMM 2.41.2 using the following docker commands:
Step2: Add MySQL 5.7 to the PMM server:
Step3:Configure query_response_time_stats to get the matrix, which is perfectly documented here.
Step 4:Navigate to MySQL / MySQL Query Response Time Details and check the Read Query Response Time Distribution and Write Query Response Time Distribution graph, which shows the following bracket ranges.
How to document
None
AFFECTED CS IDs
CS0046418
Attachments
3
Smart Checklist
hide
Activity
Show:
Aaditya Dubey May 16, 2024 at 9:21 AM
Hi
I’ll test it and update you with the metrics for it.
Nurlan Moldomurov May 16, 2024 at 9:14 AM
Hi , I’ve created Feature Build for this improvement, could you please check it?
Mark Stephenson May 15, 2024 at 4:07 PM
hi guys
MySQL / MySQL Query Response Time Details is the page.
configuration I guess will be that we're using performance schema rather than slow log
Mysql is the Tech
Mark
Nurlan Moldomurov May 15, 2024 at 2:13 PM
Hello , could you please be kind to add which page this panel is belong to and which technology are we talking about? And version of DB and configuration as well.
On the Query Response Time Distribution graphs, there are no buckets for the
<100ms
category of queries, of which most of ours fall into. Many queries are sub-1ms, sometimes down at the 300us mark. A typical insert for us would be 7-8ms