check_mysql_longqueries

Run check_mysql_longqueries --help for all of the available options. The options -w and -c are required, as they are the warning and critical thresholds for long running queries. The options --user and --password are not required, but will be necessary in most environments. The options --host, --port, and --socket can be used to define how the plugin connects to MySQL.

Additional options can be used to limit the scope of the check to include or exclude queries based on the database, MySQL user, or client host address.

By default, queries running as 'system user' and threads tagged with a Command of Sleep, Binlog Dump, Ping, or Processlist are excluded from the check.

This plugin requires the perl DBI module, as well as Nagios::Plugin.