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 SourceForge.net 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

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
kaushalshriyan
 
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.
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html#statvar_Slow_queries
Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
tgriep
Madmin
 
Posts: 4593
Joined: Thu Oct 30, 2014 9:02 am


Return to Nagios Core

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 11 guests