check_mysql_query.pl (Advanced Nagios Plugins Collection)

Project Notes

Part of the Advanced Nagios Plugins Collection, download it here:

https://github.com/harisekhon/nagios-plugins

./check_mysql_query.pl --help

Nagios Plugin to check MySQL arbitrary queries against regex matches or numerical ranges, with perfdata support

usage: check_mysql_query.pl [ options ]

-H --host MySQL Host
-P --port MySQL Port
-u --user MySQL user
-p --password MySQL password
-d --database MySQL database
-q --query MySQL query to execute
-f --field Field number/name to check the results of (defaults to '1')
-e --epoch Subtract result from current time in epoch format from result (useful for timestamp based comparisons)
-m --message Message to output after result. Can take a printf string with a single substitution (defaults to 'query returned')
-n --message-prepend Display message before rather than after result (prepend)
-o --output Exact output to expect
-r --regex Regex to match the result against
-w --warning Warning threshold or ran:ge (inclusive)
-c --critical Critical threshold or ran:ge (inclusive)
-g --graph Perfdata output for graphing
-l --label Perfdata label. If not specified uses field name or Undefined if field name doesn't match a known regex of chars
-U --units Units of measurement for graphing output (%/s/ms/us/B/KB/MB/TB/c)
-s --short Shorten output, do not output message just result
--no-querytime Do not output the mysql query time
-h --help Print description and usage options
-t --timeout Timeout in secs (default: 10)
-v --verbose Verbose mode
-V --version Print version and exit