Promhub Logo Prom hub

MySQL too many open files
warning

Description MySQL has too many open files, consider increase variables open_files_limit on {{ $labels.instance }}.
Query for 2m 
>>>
	
				
					
				
			
				
					 / 
				
			
				
					
				
			
				
					 * 100 > 75
Query Explanation

The rule computes the percentage of InnoDB open files (mysql_global_status_innodb_num_open_files) against the configured open_files_limit (mysql_global_variables_open_files_limit) and fires when this value exceeds 75 %, meaning MySQL is using more than three‑quarters of its allowed open file descriptors on the instance.

Get Alert✕
Download
Copy to Clipboard