Check mysql slow queries
- by Rafal Kaminski
Is it possible to monitoring mysql like:
if some queries is run more then 300 seconds - it will be warnings
if some queries is run more then 500 seconds - it will be critical
I tried:
/usr/lib/nagios/plugins/check_mysql_health --hostname localhost --username icinga --password XXX --mode slow-queries --warning 300
But is show only rate slow_queries/per second :( Do you have some idea how i can monitoring sth. like i want?
Thank you for help.
Br,
