MySQL high prepared statements utilization (> 80%) warning
>>>
max_over_time
(
mysql_global_status_prepared_stmt_count
[1m]) /
mysql_global_variables_max_prepared_stmt_count
* 100 > 80
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.
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 SQL thread not running
MySQL Slave replication lag
MySQL down
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