Home Directory Plugins Databases MySQL check_mysql_threads

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

check_mysql_threads

Current Version
1.0
Last Release Date
2014-05-03
License
BSD
Hits
18980
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
Nagios plugin for MySQL.

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.