--collect.auto_increment.columns flag didn't work well as expect

[jingzhao-self]

Host operating system: output of uname -a

Linux 4301aa9c57f1 5.19.0-1025-aws #26~22.04.1-Ubuntu SMP Mon Apr 24 01:58:15 UTC 2023 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter --version
mysqld_exporter, version 0.15.0 (branch: main, revision: c8b9064)
build user: root@b4c64f007a9d
build date: 20231003-07:41:56
go version: go1.20.8
platform: linux/amd64
tags: netgo

MySQL server version

8.0.28

mysqld_exporter command line flags

mysqld-exporter --config.my-cnf=/etc/my.cnf --collect.auto_increment.columns

What did you do that produced an error?

didn't create metrics: mysql_info_schema_auto_increment_column and mysql_info_schema_auto_increment_column_max

What did you expect to see?

alert when auto_increment Value Exhaustion.

What did you see instead?

didn't have any error logs.