MySQL Slave SQL thread not running critical
>>>
(
mysql_slave_status_slave_sql_running
and ON (instance)
mysql_slave_status_master_server_id
> 0) == 0
The expression checks, per instance, whether the replica’s SQL thread (mysql_slave_status_slave_sql_running) is on and the replica is linked to a master (mysql_slave_status_master_server_id > 0). If the combined result equals 0—meaning the SQL thread is stopped (or no master is set) on a configured slave—the alert fires.
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 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