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