prometheus
feature request: metrics from performance_schema.host_cache
Host operating system: output of uname -a
5.15.0-69-generic #76-Ubuntu SMP Fri Mar 17 17:19:29 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
mysqld_exporter version: output of mysqld_exporter --version
mysqld_exporter, version 0.14.0
MySQL server version
mariaDB 10.6.12
mysqld_exporter command line flags
--web.config.file /etc/mysql/exporter/webconfig.yml --config.my-cnf /opt/mysqld_exporter/my.cnf --web.listen-address 0.0.0.0:9104
What did you do that produced an error?
no error with the exporter itself occured
What did you expect to see?
Due to an incident on my productive mariaDB (10.6) host lately, where my kubernetes cluster was locked out from the DB-server due to being blocked because of too many failed connection attempts, i wanted to see if i can prevent this or react earlier by using the SQL monitoring. However at this point its not possible to get any metrics with informaionts from 'performance_schema.host_cache'. It would be great to have this possibility and at least have infos about those columns (if possible more that make sense):
IP|HOST |HOST_VALIDATED|SUM_CONNECT_ERRORS|COUNT_HOST_BLOCKED_ERRORS
