sensu/sensu-community-plugins — pull request #333 by jblackburn22 (2013-10-30 21:19:47+00:00)
Title: Monitor prepared statement usage

I have expanded mysql-graphite to track prepared_stmt_count and max_prepared_stmt_count. Need to track this since we are using a large number of prepared statements and want to track its usage. Below is a description of max_prepared_stmt_count from Mysql 5.0 reference.

This variable limits the total number of prepared statements in the server. (The sum of the number of prepared statements across all sessions.) It can be used in environments where there is the potential for denial-of-service attacks based on running the server out of memory by preparing huge numbers of statements. If the value is set lower than the current number of prepared statements, existing statements are not affected and can be used, but no new statements can be prepared until the current number drops below the limit. The default value is 16,382. The permissible range of values is from 0 to 1 million. Setting the value to 0 disables prepared statements. This variable was added in MySQL 5.0.21.