mysqld_exporter icon indicating copy to clipboard operation
mysqld_exporter copied to clipboard

Support for exporting Relay_Master_Log_File, Master_Log_File number in slave_status

Open samitpal opened this issue 5 years ago • 0 comments

Host operating system: output of uname -a

Ubuntu 18.04.2 LTS

mysqld_exporter version: output of mysqld_exporter --version

$ 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

5.7.27-0ubuntu0.18.04.1

mysqld_exporter command line flags

/usr/bin/mysqld_exporter
--config.my-cnf="/opt/prometheus/mysqld_exporter/mysqld_exporter-0.12.1.linux-amd64/.my.cnf"
--web.listen-address="0.0.0.0:9104"
--collect.global_status
--collect.info_schema.innodb_metrics
--collect.auto_increment.columns
--collect.info_schema.processlist
--collect.binlog_size
--collect.info_schema.tablestats
--collect.global_variables
--collect.info_schema.query_response_time
--collect.info_schema.userstats
--collect.info_schema.tables
--collect.perf_schema.tablelocks
--collect.perf_schema.file_events
--collect.perf_schema.eventswaits
--collect.perf_schema.indexiowaits
--collect.perf_schema.tableiowaits
--collect.slave_status

I can see mysql_slave_status_exec_master_log_pos and mysql_slave_status_read_master_log_pos but can't see anything for the equivalent of Relay_Master_Log_File, Master_Log_File . If these are not exported it might be useful to export the file numbers for the above two.

samitpal avatar Oct 25 '19 16:10 samitpal