Detecting slow queries in MySQL using check_mysql_health

An open discussion forum for obtaining help with Nagios Core. Nagios Core users of all experience levels are welcome here. Subforum have been created for the discussion of Nagios Core and Nagios Plugin development.

NOTE: The mailing lists have been deprecated in favor of this forum in order to expedite support and provide additional features not available on the old mailing list.

Detecting slow queries in MySQL using check_mysql_health

Postby kaushalshriyan » Thu Apr 20, 2017 9:36 am


Can somebody please help me understand how check_mysql_health Nagios plugin work. I am referring to ... index.html

For example :-

command[check_slow_queries]=/usr/lib64/nagios/plugins/check_mysql_health --hostname localhost --username admin --password admin --socket /var/lib/mysql/mysql.sock --warning 10 --critical 20 --mode slow-queries

Code: Select all
  Keyword                                    Description                                 Range
slow-queries                Rate of queries that were detected as “slow”           0..n/sec (0.1, 1)

Does check_mysql_health nagios plugin read the /var/lib/mysql/mysql.sock file to detect slow queries in MySQL DB server or does it use SHOW GLOBAL STATUS command as mentioned in ... ables.html?

Any explanation will be highly appreciable. Thanks in Advance.


Posts: 42
Joined: Fri May 22, 2015 7:12 am

Re: Detecting slow queries in MySQL using check_mysql_health

Postby tgriep » Thu Apr 20, 2017 4:42 pm

I took a quick look at the plugin and is looks like it is running this for slow queries.
Code: Select all
SHOW STATUS LIKE 'Slow_queries'

This is the description of that query.
Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
Posts: 4560
Joined: Thu Oct 30, 2014 9:02 am

Return to Nagios Core

Who is online

Users browsing this forum: jmac727 and 22 guests