Not the answer you need?
Register and ask your own question!

MySQL query response time dashboard no results

goldstrikegoldstrike ContributorInactive User Role Beginner
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



Attachment not found.


Attachment not found.

Attachment not found.
1.png 10.4K
2.png 12.4K
3.png 12.6K

Comments

  • weberweber Advisor Inactive User Role Beginner
    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 :)
  • goldstrikegoldstrike Contributor Inactive User Role Beginner
    Thank you very much, the display problem is solved.
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.