Page 1 of 1

Nagios plugins for mysql older versions

Posted: Mon Sep 14, 2015 9:02 am
by yunushaikh
Hello Experts,

I was using mysqld_check and mysql_counters plugin for monitoring mysql as they have some nice graphs template in pnp4nagios. But the problem is that those plugins only work with mysql versions higher than 5.1.x

I have some mysql which are on mysql 5.0.80. Are there any similar plugins available to monitor InnoDB engine and performance of mysql for MySQL 5.0.80. Please suggest.

Re: Nagios plugins for mysql older versions

Posted: Mon Sep 14, 2015 3:57 pm
by hsmith
Have you had a look through the MySQL section on Nagios Exchange?

Re: Nagios plugins for mysql older versions

Posted: Tue Sep 15, 2015 4:41 am
by yunushaikh
Yes i already went through that page and I like those plugins check_mysqld and mysql_counters but those are only used for mysql version higher than 5.1.
I am already using those plugins as they have very nice pnp4nagios graph templates.

I need same type of plugin for older mysql version 5.0.80.

Please suggest me those type of plugins which can give me information better for INNODB databases

I want to monitor
Query per seconds
max user connection
slow queries
show processlist
innodb buffer pool usage

Re: Nagios plugins for mysql older versions

Posted: Tue Sep 15, 2015 11:25 am
by tmcdonald
I was able to find a page online that hosts some MySQL plugins written by people who administer MySQL machines:

https://www.percona.com/doc/percona-mon ... index.html

I could not find any version support, but those might be worth looking into.

Re: Nagios plugins for mysql older versions

Posted: Tue Sep 15, 2015 11:27 am
by jdalrymple
So just to clear this up, we're talking about a major version of open source software that has been out of support for almost 4 years. This means it's unlikely that anything will get generated new for this line of monitoring. You can try consol labs plugin, it was originally developed back then and either:

a) It may just support what you want.
or
b) If you can download an ancient version it may work for you.

Good luck.

https://labs.consol.de/nagios/check_mys ... index.html

Re: Nagios plugins for mysql older versions

Posted: Tue Sep 15, 2015 11:36 am
by ssax
These are said to work with 5.0, the Percona ones look very interesting and might be what you're looking for.

https://exchange.nagios.org/directory/P ... ld/details
https://exchange.nagios.org/directory/T ... os/details