Wiki Navigation

mysql_size

Hack of a plugin to show size of databases.

Language	Bourne shell
Requirements	MySQL client
Supported platforms	Any
Written by	Rune Nordbøe Skillingstad - rune.skillingtad@ntnu.no
Latest release	http://munin.projects.linpro.no/attachment/wiki/plugin-mysql_size/mysql_size.5

Copy mysql_size to /usr/share/munin/plugins

Configure mysqlopts in /etc/munin/plugin-conf.d/munin-node

Run munin-node-configure

# munin-node-configure --shell
ln -s /usr/share/munin/plugins/mysql_size /etc/munin/plugins/mysql_size

Run the ln commands.

Restart munin-node

Add options like user, host and password to pass to mysql command.

[mysql*]
   env.mysqlopts -u muninuser --password=hidd4nsEacrat

mysql_size (1.4 kB) - added by rune.skillingstad@ntnu.no on 07/06/06 09:37:52.
mysql_size.2 (1.4 kB) - added by = vmware_gsx_ = Multi function plugin for monitoring memory, disk IO and ethernet IO pr virtual machine. ||Language||Perl|| ||Requirements||Perl VMware::Config::Server VMware::Config::VM|| ||Supported platforms||VMware GSX|| ||Written by||Rune Nordbøe Skillingstad rune@skillingtad.no|| == Install == Copy vmware_gsx_ to /usr/share/munin/plugins Run ''munin-node-configure'' {{{ # munin-node-configure --shell ln -s /usr/share/munin/plugins/vmware_gsx_ /etc/munin/plugins/vmware_gsx_disk ln -s /usr/share/munin/plugins/vmware_gsx_ /etc/munin/plugins/vmware_gsx_memory ln -s /usr/share/munin/plugins/vmware_gsx_ /etc/munin/plugins/vmware_gsx_net }}} Run the ''ln'' commands. Restart ''munin-node'' == Configuration == If run from GSX server, no configuration is needed. If run remote the following variables should be added (default port is 902) {{{ [vmware_gsx*] env.host gsx-server.domain.tld env.port 902 env.user munin rune.skillingstad@ntnu.no on 07/06/06 13:27:49.
mysql_size.3 (1.8 kB) -New version, handling MySQL versions >= 4.1, added by rune.skillingstad@ntnu.no on 10/03/06 10:17:08.
mysql_size.4 (1.8 kB) -new version, properly escapes tablenames containing sprecial chars (such as '-'), added by david82 on 06/27/08 15:01:08.
mysql_size.5 (1.9 kB) -some more special-char-fixes (munin field names), added by david82 on 06/27/08 15:38:33.