Detecting slow queries in MySQL using check_mysql_health
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
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
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)
Any explanation will be highly appreciable. Thanks in Advance.
Regards,
Kaushal