Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to collect MySQL_ Global_ Status_ QCache related indicators #804

Open
ktpktr0 opened this issue Jan 17, 2024 · 1 comment
Open

Unable to collect MySQL_ Global_ Status_ QCache related indicators #804

ktpktr0 opened this issue Jan 17, 2024 · 1 comment

Comments

@ktpktr0
Copy link

ktpktr0 commented Jan 17, 2024

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?

@bajo
Copy link

bajo commented Jul 16, 2024

I have the same situation in a few of our servers.
However, I can add one more data point.
If the DB is MySQL we have missing data. Where we use mariadb, mysqld_exporter with the same settings delivers data just fine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants