wiki:PluginPortrait/mysql_query_cache

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.

LanguagePerl
Supported platformsOnly tested on Linux
Written byPaul Dixon lordelph@…
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.

Last modified at 2006-08-22T23:31:47+02:00 Last modified on 2006-08-22T23:31:47+02:00

Attachments (1)

Download all attachments as: .zip