MySQLReplicationLag
critical

Description The mysql slave replication has fallen behind and is not recovering
Query for 1m
>>>
	
				
					(
				
			
				
					
				
			
				
					 > 30) and on(instance) (
				
			
				
					
					
						predict_linear
					
				
			
				
					(
				
			
				
					
				
			
				
					[5m], 60 * 2) > 0)
				
			
    
Query Explanation

The alert fires when the MySQL slave’s replication lag (instance:mysql_slave_lag_seconds) is already above 30 seconds and a linear prediction of the lag over the next two minutes (based on the last 5 minutes) shows a positive slope, i.e., the lag is still increasing. In short, it alerts when the slave is lagging and the lag is not recovering.

Exporters Used

Related Alerts

Get Alert
Download
Copy to Clipboard