Home Directory Plugins Databases MySQL check_mysql_health

check_mysql_health

Bookmark and Share

Submit reviewRecommendPrintVisit
Rating
18 votes
Favoured:
7
Current Version
2.1.5
Last Release Date
2010-12-20
Compatible With
  • Nagios 1.x
  • Nagios 2.x
  • Nagios 3.x
  • Nagios XI 2009R1
  • Nagios Fusion 2010R1
Owner
lausser
Website
labs.consol.de/nagios/check_mysql_health
Hits
151860
check_mysql_health
check_mysql_health is a plugin for Nagios that allows you to monitor a MySQL database. Among the list of metrics are time to login, index usage, bufferpool hit rate, query cache hit rate, slow queries, temp tables on disk, table cache hit rate, connected threads, and many more. Requirements are either a DBD::mysql Perl module or a MySQL client package.
This plugin can be used to check the following metrics:


connection-time (Time to connect to the server)
uptime (Time the server is running)
threads-connected (Number of currently open connections)
threadcache-hitrate (Hit rate of the thread-cache)
slave-lag (Seconds behind master)
slave-io-running (Slave io running: Yes)
slave-sql-running (Slave sql running: Yes)
qcache-hitrate (Query cache hitrate)
qcache-lowmem-prunes (Query cache entries pruned because of low memory)
keycache-hitrate (MyISAM key cache hitrate)
bufferpool-hitrate (InnoDB buffer pool hitrate)
bufferpool-wait-free (InnoDB buffer pool waits for clean page available)
log-waits (InnoDB log waits because of a too small log buffer)
tablecache-hitrate (Table cache hitrate)
table-lock-contention (Table lock contention)
index-usage (Usage of indices)
tmp-disk-tables (Percent of temp tables created on disk)
slow-queries (Slow queries)
long-running-procs (long running processes)
cluster-ndbd-running (ndnd nodes are up and running)
sql (any sql command returning a single number)
Reviews (3)
Fantastic
bybox2, August 10, 2010
2 of 2 people found this review helpful
This plugin is brilliant. Very easy to set up and gets all the lovely perfdata I need to have historic and highly valuable hard numbers to tune our MySQL servers and application code. No more naysayers with the complaining that 'changing for the sake of changing is not a solution'.

Also the checking of MySQL replication is very awesome.

This plugin defeats any reasons we had for using the MySQL Enterprise Manager software. Saving dollars and cents.
where can I download this plugin?
byaswen, January 24, 2012
1 of 1 people found this review helpful
I'd like to download this plugin, but there are no files listed and there's no download link as well.
Owner's reply

Clicking on "Website
labs.consol.de/nagios/check_mysql_health" a few lines above is very complicated, isn't it?

CPU busy needs help
byMarkJenks, March 6, 2012
Great product, but cpu busy is not coming back very useful and I had to disable it. here is a link that explains a better way to do it.

http://strictlysql.blogspot.com/2010/06/finding-cpu-utilization-in-sql-server.html