mysqld_exporter icon indicating copy to clipboard operation
mysqld_exporter copied to clipboard

Exporter can’t get binlog_size from percona 8 server

Open olddanmer opened this issue 4 years ago • 0 comments

Host operating system: output of uname -a

CentOS 7 Linux server-mysql80 3.10.0-1062.1.2.el7.x86_64 #1 SMP Mon Sep 30 14:19:46 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.12.1 (branch: HEAD, revision: 48667bf7c3b438b5e93b259f3d17b70a7c9aff96) build user: root@0b3e56a7bc0a build date: 20190729-12:35:58 go version: go1.12.7

MySQL server version

Percona-Server-8.0.16-7

mysqld_exporter command line flags

/usr/local/bin/mysqld_exporter
--config.my-cnf /usr/local/etc/.mysqld_exporter.cnf
--collect.auto_increment.columns
--collect.binlog_size
--collect.engine_innodb_status
--collect.global_status
--collect.global_variables
--collect.info_schema.clientstats
--collect.info_schema.innodb_metrics
--collect.info_schema.innodb_cmp
--collect.info_schema.innodb_cmpmem
--collect.info_schema.processlist
--collect.info_schema.query_response_time
--collect.info_schema.tables
--collect.info_schema.tablestats
--collect.info_schema.schemastats
--collect.info_schema.userstats
--collect.perf_schema.eventsstatements
--collect.perf_schema.eventsstatementssum
--collect.perf_schema.eventswaits
--collect.perf_schema.file_events
--collect.perf_schema.file_instances
--collect.perf_schema.indexiowaits
--collect.perf_schema.tableiowaits
--collect.perf_schema.tablelocks
--collect.perf_schema.replication_group_member_stats
--collect.perf_schema.replication_applier_status_by_worker
--collect.slave_status
--web.listen-address=0.0.0.0:9104

What did you do that produced an error?

Run exporter. curl -XGET 'server-mysql80:9104/metrics'

What did you expect to see?

binlog_size metrics in the output

What did you see instead?

A lot of metrics, but binlog_size metric is absent. Also collector collect.binlog_size finished without error: mysql_exporter_collector_duration_seconds{collector="collect.binlog_size"} 0.230414609 Full curl output is attached. mysql-exp.txt

olddanmer avatar May 21 '20 17:05 olddanmer