mysqld_exporter: Mysql Schema is missing in mysql_info_schema_table_size

Host operating system: output of `uname -a`

Linux 3.10.0-693.17.1.el7.x86_64 (Centos 7.4)

mysqld_exporter version: output of `mysqld_exporter --version`

mysqld_exporter, version 0.10.0 (branch: master, revision: 80680068f15474f87847c8ee8f18a2939a26196a) build user: root@3b0154cd9e8e build date: 20170425-11:24:12 go version: go1.8.1

MySQL server version

5.6

mysqld_exporter command line flags

None Passed (Default Used)

What did you do that produced an error?

Started Mysqld_exporter with Default setup using systemd service

What did you expect to see?

All schema should be listed when metric mysql_info_schema_table_size is used.

What did you see instead?

Few schema is missing when using mysql_info_schema_table_size.

About this issue

Original URL
State: closed
Created 6 years ago
Comments: 15 (6 by maintainers)

Most upvoted comments

I ran into the same problem and downgraded to v0.11.0 to solve it

yiranzai on Jan 19, 2020

I can confirm that using version ‘v0.11.0’ docker container from https://hub.docker.com/r/prom/mysqld-exporter/tags solves the issue.

sschamp on Aug 29, 2019

Same issue with the latest image

prom/mysqld-exporter@sha256:9fe9938c4ac9216cc24005144338f14fac4f604f139b481cc541bead008db3c1).

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

But… its working with the older version:

prom/mysqld-exporter@sha256:9f4fb61cca309cb4a8c1b9ed9fb4aa75af0f7a21f36d3954667db37c062a0172

mysqld_exporter, version 0.11.0 (branch: HEAD, revision: 5d7179615695a61ecc3b5bf90a2a7c76a9592cdd)
  build user:       root@3d3ff666b0e4
  build date:       20180629-15:00:35
  go version:       go1.10.3

mrceperka on Aug 29, 2019