MySQL query response time dashboard no results

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

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:

Thank you very much, the display problem is solved.