Query Response graphs has no buckets for <100ms

Description

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.

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Needs Doc

Planned Version/s

Fix versions

Story Points

Affects versions

Smart Checklist Progress

Smart Checklist

Created May 15, 2024 at 1:18 PM
Updated August 8, 2024 at 5:02 AM
Resolved June 12, 2024 at 7:57 AM