Munin plugin for showing graphs of MySQL resource usage.

1. Download zip file from Github and unzip (https://github.com/kjellm/munin-mysql/archive/master.zip)
2. Install dependencies
   • munin-node
   • Perl modules: DBI, DBD::mysql, Module::Pluggable
3. Edit Makefile
4. Edit mysql.conf
5. Run `make install'

The plugin documentation is contained in the plugin file as POD. View it with perldoc.

There is a blog post with some general information and screenshots at http://oierud.name/bliki/ImprovedMuninGraphsForMySQL.html

The information on http://code.google.com/p/mysql-cacti-templates/wiki/MySQLTemplates should be relevant (As these munin graphs are heavily inspired by Xaprb's cacti graphs.)

There is a wiki at https://github.com/kjellm/munin-mysql/wiki

The source is hosted at github: http://github.com/kjellm/munin-mysql/

• If you get warnings saying "Output from SHOW ENGINE INNODB STATUS was truncated" that means that a very large deadlock are causing the output to be truncated. The consequence is that data for many of the InnoDB related data sources will be missing. For solutions to this problem see http://www.xaprb.com/blog/2006/08/08/how-to-deliberately-cause-a-deadlock-in-mysql/

• You can find some tips for debugging munin plugin problems here: http://munin.projects.linpro.no/wiki/Debugging_Munin_plugins

• Bugs should be reported to the issue tracker on github http://github.com/kjellm/munin-mysql/issues

Kjell-Magne Øierud <kjellm AT oierud DOT net>

Inspired by the cacti graphs made by Xaprb http://code.google.com/p/mysql-cacti-templates/ as viewed on http://www.xaprb.com/blog/2008/05/25/screenshots-of-improved-mysql-cacti-templates/.

This plugin also contains changes from the upstream munin mysql plugin. See the list of contributors.