MySQL Slave IO thread not running critical
>>>
(
mysql_slave_status_slave_io_running
and ON (instance)
mysql_slave_status_master_server_id
> 0 ) == 0
The query first ensures the instance is a replication slave (mysql_slave_status_master_server_id > 0) and then checks the mysql_slave_status_slave_io_running metric for that same instance. If the instance is a slave and the IO thread metric is 0, the expression evaluates to true and the alert is triggered.
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 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 connections (> 80%)
MySQL too many open files
MySQLDown
MySQLGaleraDonorFallingBehind
MySQLGaleraNotReady
MySQLGaleraOutOfSync
MySQLInnoDBLogWaits
MySQLReplicationLag
MySQLReplicationLag
MySQLReplicationNotRunning