wiki:PluginPortrait/mysql_cache_memory

Plugins? : mysql_cachememory

This plugin shows the total amount of memory set aside for the MySQL query cache, and the amount currently in use.

LanguagePerl
Supported platformsOnly tested on Linux
Written byPaul Dixon lordelph@…
See also mysql_querycache?

Example

example graph

Installation

  • Copy attached file to /usr/share/munin/plugins
  • Symlink it into your node configuration, e.g.
  • ln -s /usr/share/munin/plugins/mysql_cachememory/etc/munin/plugins/mysql_cachememory
  • 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-25T02:45:14+02:00 Last modified on 2006-08-25T02:45:14+02:00

Attachments (2)

Download all attachments as: .zip