# MySQL query response time dashboard no results

**URL:** <https://forums.percona.com/t/mysql-query-response-time-dashboard-no-results/5225>\
**Category:** PMM 1.x\
**Created:** [November 23, 2016, 12:01am UTC](https://forums.percona.com/t/mysql-query-response-time-dashboard-no-results/5225 "2016-11-23T00:01:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![goldstrike](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@goldstrike](https://forums.percona.com/u/goldstrike)\
**Post date:** [November 23, 2016, 12:01am UTC](https://forums.percona.com/t/mysql-query-response-time-dashboard-no-results/5225/1 "2016-11-23T00:01:46Z")

</div>

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](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/6e36fa0ce64918b1c1d849567aa3a048e19855f7.jpeg)

![2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/70604cf74a7bc0f04b78944808eeb76245e4f4e2.jpeg)

![3.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/b5d8a953ccef0d46c6c924346c847be5a427a47e.jpeg)

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [November 23, 2016, 7:18am UTC](https://forums.percona.com/t/mysql-query-response-time-dashboard-no-results/5225/2 "2016-11-23T07:18:03Z")

</div>

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 🙂

---

<div class="post-metadata">

**Author:** ![goldstrike](https://avatars.discourse-cdn.com/v4/letter/g/a587f6/32.png) [@goldstrike](https://forums.percona.com/u/goldstrike)\
**Post date:** [December 5, 2016, 4:29am UTC](https://forums.percona.com/t/mysql-query-response-time-dashboard-no-results/5225/3 "2016-12-05T04:29:10Z")

</div>

Thank you very much, the display problem is solved.