mysql-exporter adapted for mysql v8.x version

[xiaoyuan2019]

Host operating system: output of uname -a

Linux ksops_test 3.10.0-1127.el7.x86_64 #1 SMP Tue Mar 31 23:36:51 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

/ $ 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

v8.0.37

mysqld_exporter command line flags

/bin/mysqld_exporter --web.listen-address=:11010 --web.config.file=/etc/mysql_exporter_auth.yml --mysqld.address=localhost:3306 --mysqld.username=wps

What did you do that produced an error?

What did you expect to see?

no error

What did you see instead?

• SHOW ALL SLAVES STATUS：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL SLAVES STATUS' at line 1
• SHOW ALL SLAVES STATUS NONBLOCKING：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL SLAVES STATUS NONBLOCKING' at line 1
• SELECT @@query_response_time_stats：Unknown system variable 'query_response_time_stats'