Home Directory Plugins Databases MySQL check_mysql_longqueries

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

check_mysql_longqueries

Rating
0 votes
Favoured:
0
Hits
103733
Files:
FileDescription
check_mysql_longqueries.plcheck_mysql_longqueries
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
check_mysql_longqueries is a Nagios plugin written in Perl that monitors a MySQL database server for queries (commands, and/or threads) that run longer than the configured threshold. Long running queries are especially problematic on tables whose engines require table locks for reads and write (ie: MyISAM). This plugin was designed to alert an administrator of long queries in the case action needs to be taken.
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.