Nagios Support Forum

Posted: **Thu Apr 20, 2017 9:36 am**

Hi,

Can somebody please help me understand how check_mysql_health Nagios plugin work. I am referring to https://labs.consol.de/nagios/check_mys ... 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 https://dev.mysql.com/doc/refman/5.7/en ... ables.html?

Any explanation will be highly appreciable. Thanks in Advance.

Regards,

Kaushal

Posted: **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.
https://dev.mysql.com/doc/refman/5.7/en ... ow_queries

Posted: **Tue May 02, 2017 8:13 am**

Thanks tgriep for the explanation

Posted: **Tue May 02, 2017 9:30 am**

Did you have any further (related) questions or are we okay to close this thread?

Nagios Support Forum

Detecting slow queries in MySQL using check_mysql_health

Detecting slow queries in MySQL using check_mysql_health

Re: Detecting slow queries in MySQL using check_mysql_health

Re: Detecting slow queries in MySQL using check_mysql_health

Re: Detecting slow queries in MySQL using check_mysql_health