MySQL too many connections (> 80%) warning
>>>
max_over_time
(
mysql_global_status_threads_connected
[1m]) /
mysql_global_variables_max_connections
* 100 > 80
The rule computes the peak number of MySQL threads connected over the past minute, divides it by the configured max_connections, multiplies by 100 to get a usage percentage, and fires when this exceeds 80 %. In other words, the alert triggers for an instance whenever more than 80% of its allowed MySQL connections are in use.
Exporters Used
Related Alerts
MySQL High QPS
MySQL InnoDB Force Recovery is enabled
MySQL InnoDB history_len too long
MySQL InnoDB log waits
MySQL Slave IO thread not running
MySQL Slave SQL thread not running
MySQL Slave replication lag
MySQL down
MySQL high prepared statements utilization (> 80%)
MySQL high threads running
MySQL restarted
MySQL slow queries
MySQL too many open files
MySQLDown
MySQLGaleraDonorFallingBehind
MySQLGaleraNotReady
MySQLGaleraOutOfSync
MySQLInnoDBLogWaits
MySQLReplicationLag
MySQLReplicationLag
MySQLReplicationNotRunning