Plugins : mysql_querycache

This plugin shows the efficiency of the mysql query cache, showing the percentage of select queries which were served directly from the cache.

Language	Perl
Supported platforms	Only tested on Linux
Written by	Paul Dixon lordelph@gmail.com
See also	mysql_cachememory

Installation

• Copy attached file to /usr/share/munin/plugins
• Symlink it into your node configuration, e.g.
• ln -s /usr/share/munin/plugins/mysql_querycache /etc/munin/plugins/mysql_querycache
• If you've got other mysql plugins working, this one will use the same configuration.
• restart the munin node

Configuration

Chances are good you've already got other mysql plugins configured and working. If so, you don't need to do any further configuration. Otherwise, ensure your /etc/munin/plugin-conf.d/munin-node file contains something like this

[mysql*]
user root
env.mysqlopts --defaults-extra-file=/etc/mysql/debian.cnf

The options are whatever mysqladmin will need to obtain status variables. On Debian, you can use the one above, or you could pass a username and password instead.