MySQL query response time dashboard no results

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

Everything is fine but can’t get the “MySQL query response time” dashboard to display data, thanks for helping me.

My Variable is here

Persona Server 5.6.33-79.0
plugin-load = “audit_log=audit_log.so;QUERY_RESPONSE_TIME=query_response_time.so;QUERY_RESPONSE_TIME_AUDIT=query_response_time.so;QUERY_RESPONSE_TIME_READ=query_response_time.so;QUERY_RESPONSE_TIME_WRITE=query_response_time.so”
query_response_time_stats = 1
userstat = 1
thread_statistics = 1

query_response_time_flush | OFF |
query_response_time_range_base | 10 |
query_response_time_stats | ON |

QUERY_RESPONSE_TIME | ACTIVE | INFORMATION SCHEMA | query_response_time.so | GPL |
QUERY_RESPONSE_TIME_AUDIT | ACTIVE | AUDIT | 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 |

Grafana 3.1.1 with percona/grafana-dashboards and apply patch
sed -i ‘s/expr=(.).replace((.).expr,(.).scopedVars(.*)var (.)=(.).interval/expr=\1.replace(\2.expr,\3.scopedVars\4var \5=\1.replace(\6.interval, \3.scopedVars)/’ /usr/share/grafana/public/app/plugins/datasource/prometheus/datasource.js
sed -i ‘s/,range_input/.replace(/“{/g,”"“).replace(/}”/g,“"”),range_input/; s/step_input:“”/step_input:this.target.step/’ /usr/share/grafana/public/app/plugins/datasource/prometheus/query_ctrl.js

Prometheus 1.3.1
mysqld_exporter, version 0.9.0 (branch: master, revision: 8400af20ccdbf6b5e0faa2c925c56c48cd78d70b)

Running using an environment
./mysqld_exporter -config.my-cnf=“.my.cnf” -collect.auto_increment.columns=true -collect.binlog_size=true -collect.engine_innodb_status=true -collect.info_schema.clientstats=true -collect.info_schema.innodb_metrics=true -collect.info_schema.innodb_tablespaces=true -collect.info_schema.processlist=true -collect.info_schema.query_response_time=true -collect.info_schema.tablestats=true -collect.info_schema.userstats=true -collect.perf_schema.eventsstatements=true -collect.perf_schema.eventswaits=true -collect.perf_schema.file_events=true -collect.perf_schema.indexiowaits=true -collect.perf_schema.tableiowaits=true -collect.perf_schema.tablelocks=true

[ATTACH=CONFIG]n46466[/ATTACH]

[ATTACH=CONFIG]n46467[/ATTACH]

[ATTACH=CONFIG]n46468[/ATTACH]

1.png

2.png

3.png

2

So it’s not PMM, you are running separate components.

I think you are using outdated version of mysqld_exporter, version 0.9.0 (branch: master, revision: 8400af20ccdbf6b5e0faa2c925c56c48cd78d70b)

In PMM, we use our custom mysqld_exporter. Also on the upstream after 0.9.0 release, we have made a fix to query response time.

So you can whether build mysqld_exporter from master yourself and use it with the latest dashboards or use PMM :slight_smile:

3

Thank you very much, the display problem is solved.