Promhub Logo Prom hub

MySQL high prepared statements utilization (> 80%)
warning

Description High utilization of prepared statements (>80%) on {{ $labels.instance }}
Query for 2m 
>>>
	
				
					
					
						max_over_time
					
				
			
				
					(
				
			
				
					
				
			
				
					[1m]) / 
				
			
				
					
				
			
				
					 * 100 > 80
Query Explanation

The rule computes the maximum mysql_global_status_prepared_stmt_count observed in the last minute, divides it by the configured mysql_global_variables_max_prepared_stmt_count, multiplies by 100, and fires when the result exceeds 80 % – i.e., when prepared‑statement usage is above 80 % of the allowed limit on the instance.

Get Alert✕
Download
Copy to Clipboard