Nagios plugins for mysql older versions

[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.

[hsmith]

Have you had a look through the MySQL section on Nagios Exchange?

[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

[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.

[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

[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