QAN is not match the time range what I want to see

Percona Monitoring and Management (PMM) PMM 1.x
1

hi,

I installed latest percona pmm docker image.

QAN is not match the time range what I want to see.

  1. I checked mysql slow query metric in Grafana.

  2. I drag the timeline what I want to see in mysql slow query metric graph.

  3. I clicked QAN

  4. but there is a lot of results.

  5. I checked mysql-slow-query log in mysql server, but there is only one slow query at that time.

I think QAN results is not match the timeline.

I attached sample picture.

please let me know why it is not match the timeline.

thanks.

photoid=50147
photoid=50147944×260 24.5 KB

photoid=50148
photoid=50148715×507 54.6 KB

photoid=50149

photoid=50150
photoid=501501065×453 144 KB

2

Can you explain what specifically do you see as a problem. I see “MySQL Slow Query Graph” showing time range from some time before 11:11:40 to 11:12:00 (you did not provided exact range which would be shown in the top right corner) The range in QAN is 11:11:39 to 11:12:01 which is within the same range a grafana

When you show the queries in the slow query log with some times.

I see only one query in that period of time in the slow query log however there are much more queries in the image you provided.

It looks to me however you’re using Performance Schema rather than Slow Query log as a source for your Query Analytics and it is showing you all queries rather than only slow queries

3

I found the reason.

when I collect query analyzer information from performance_schema, I could all sql queries. it is not same with my selected time range in grafana.

but when I collect query analyzer information from slow query log, I can see what I selected time range in grafana.

thanks.