MySQL high threads running warning
>>>
max_over_time
(
mysql_global_status_threads_running
[1m]) /
mysql_global_variables_max_connections
* 100 > 60
The rule computes the highest count of MySQL threads in the Running state over the last minute, divides that by the configured max_connections, multiplies by 100, and fires when the result exceeds 60 %. In short, if more than 60 % of the allowed MySQL connections are active (running), the alert triggers for that instance.
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 restarted
MySQL slow queries
MySQL too many connections (> 80%)
MySQL too many open files
MySQLDown
MySQLGaleraDonorFallingBehind
MySQLGaleraNotReady
MySQLGaleraOutOfSync
MySQLInnoDBLogWaits
MySQLReplicationLag
MySQLReplicationLag
MySQLReplicationNotRunning