mysqld_exporter icon indicating copy to clipboard operation
mysqld_exporter copied to clipboard

Unable to collect MySQL_ Global_ Status_ QCache related indicators

Open ktpktr0 opened this issue 7 months ago • 0 comments

Host operating system: output of uname -a

Linux ecs-33049370.novalocal 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.15.1 (branch: HEAD, revision: cc349684494b5038ec5a52233bdca9eb9291e6f2)
  build user:       root@d89c15b9f5ad
  build date:       20231212-07:55:09
  go version:       go1.21.5
  platform:         linux/amd64
  tags:             unknown

MySQL server version

8.0.25

mysqld_exporter command line flags

[Unit]
Description=Prometheus mysqld-exporter
After=network.target

[Service]
Type=simple

ExecStart=/opt/mysqld-exporter/mysqld-exporter --config.my-cnf=/opt/mysqld-exporter/auth.cnf \
  --collect.global_status \
  --collect.auto_increment.columns \
  --collect.info_schema.processlist \
  --collect.binlog_size \
  --collect.info_schema.tablestats \
  --collect.global_variables \
  --collect.info_schema.innodb_metrics \
  --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 \
  --collect.info_schema.tables.databases=* \
  --collect.perf_schema.replication_group_members \
  --collect.perf_schema.replication_group_member_stats

[Install]
WantedBy=multi-user.target

What did you do that produced an error?

Unable to find the following starting indicators mysql_global_status_qcache_xxx

What did you expect to see?

You can see MySQL in the collected metrics_ Global_ Status_ Indicators starting with qcache

Also, where can I see a list of all the metrics metrics that can be collected

What did you see instead?

ktpktr0 avatar Jan 17 '24 02:01 ktpktr0