Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Query response times not populated

Description

 

Configured according to PMM instructions.

Average Query Response Time: no data points

Query Response Time Distribution: All 0 flat line

 

SHOW PLUGINS; ... | QUERY_RESPONSE_TIME_AUDIT | ACTIVE | AUDIT | query_response_time.so | GPL | | QUERY_RESPONSE_TIME | ACTIVE | INFORMATION SCHEMA | query_response_time.so | GPL | | QUERY_RESPONSE_TIME_READ | ACTIVE | INFORMATION SCHEMA | query_response_time.so | GPL | | QUERY_RESPONSE_TIME_WRITE | ACTIVE | INFORMATION SCHEMA | query_response_time.so | GPL | +-------------------------------+----------+--------------------+------------------------+---------+ 57 rows in set (0.00 sec) mysql1> select @@query_response_time_stats; +-----------------------------+ | @@query_response_time_stats | +-----------------------------+ | 1 | +-----------------------------+ 1 row in set (0.00 sec)

 

How to test

None

How to document

None

Attachments

2
  • 09 Sep 2019, 09:29 AM
  • 09 Sep 2019, 09:26 AM

Smart Checklist

Activity

Lalit Choudhary September 9, 2019 at 9:33 AM

Issue reproduciable in my test only for "Average Query Response Time "  graph.

Test: pmm-server-2.0.0-beta6 and PS 5.7.26

Step: 

1.Install pmm-server pmm-server-2.0.0-beta6

2. install  Query Response time plugin

https://www.percona.com/doc/percona-monitoring-and-management/2.x/manage/conf-mysql-ps-qrt.html#id1

mysql [localhost] {msandbox} (test) > show variables like '%query%respo%';
---------------------------------------------+

Variable_name

Value

---------------------------------------------+

query_response_time_exec_time_debug

0

query_response_time_flush

OFF

query_response_time_range_base

10

query_response_time_session_stats

GLOBAL

query_response_time_stats

ON

---------------------------------------------+
5 rows in set (0.01 sec)

3. add mysql from pmm-clinet  

4. run read write load via sysbench 

5.  you will find "Average Query Response Time "  graph with 'No data Point'

Lalit Choudhary September 9, 2019 at 9:29 AM

Hi Matthew,

I only see an issue with "Average Query Response Time "  and not for "Query Response Time Distribution" .

 

Further, Read/Write Split with Average Query Response Time also visible in the next graphs.

Details

Assignee

Reporter

Priority

Labels

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created September 6, 2019 at 1:52 AM
Updated March 27, 2024 at 2:58 PM

Flag notifications