MySQL

check_mysql_longqueries

Write a Review

Description:

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.

Current Version

Last Release Date

May 28, 2009

Compatible With

Owner

Nagios Exchange

Copy Page Link Recommend Login to Add to Favorites Login to Claim
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.

Download Now

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!
Project Files
FileDescription
check_mysql_longqueries.pl

check_mysql_longqueries

Project Notes
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.
Reviews (0) Add a Review
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
0 (0)
Favorites
0
Views
103,794