Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
check_mysql_threads
Current Version
1.0
Last Release Date
2014-05-03
Owner
License
BSD
Hits
22837
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!
Checks the MySQL processlist for long running threads.
Nagios plugin for MySQL.
Checks the MySQL processlist for long running threads.
Threads which have been running for a long time could signal that something is very wrong within MySQL, such as hung queries wasting CPU cycles.
This could be caused by application contention, for example, when trying to acquire locks on the same rows.
However, long running threads could also be caused by DDL statements, such as running ALTER on large tables.
This plugin can be helpful in monitoring the overall health of an infrastructure, when combined with other standard checks.
For example, a webserver might not be responding to clients' requests.
In such situations, it's tempting to focus only on the webserver, to try and figure out what is wrong.
Although in fact, it might be MySQL who is causing the actual problem, because it can't keep up with SQL queries from the application.
Checks the MySQL processlist for long running threads.
Threads which have been running for a long time could signal that something is very wrong within MySQL, such as hung queries wasting CPU cycles.
This could be caused by application contention, for example, when trying to acquire locks on the same rows.
However, long running threads could also be caused by DDL statements, such as running ALTER on large tables.
This plugin can be helpful in monitoring the overall health of an infrastructure, when combined with other standard checks.
For example, a webserver might not be responding to clients' requests.
In such situations, it's tempting to focus only on the webserver, to try and figure out what is wrong.
Although in fact, it might be MySQL who is causing the actual problem, because it can't keep up with SQL queries from the application.
Reviews (0)
Be the first to review this listing!
