About

PyMunin Multigraph Munin Plugin for monitoring MySQL Database Server.

Multigraph Plugin: Yes
Multi-instance Plugin: Yes

Graphs

The plugin implements the following graphs:

  • mysql_connections

  • mysql_traffic

  • mysql_slowqueries

  • mysql_rowmodifications

  • mysql_rowreads

  • mysql_tablelocks

  • mysql_threads

  • mysql_proc_states

  • mysql_proc_db

  • mysql_commits_rollbacks

  • mysql_qcache_memory

  • mysql_qcache_hits

  • mysql_qcache_prunes

  • mysql_myisam_key_buffer_util

  • mysql_myisam_key_read_reqs

  • mysql_innodb_buffer_pool_util

  • mysql_innodb_buffer_pool_activity

  • mysql_innodb_buffer_pool_read_reqs

  • mysql_innodb_row_ops

Configuration

Configuration variables are passed to the Munin Plugins using environment variables. The environment variables for plugins are usually set in the plugin configuration files in the folder: /etc/munin/plugin-conf.d

The configuration variables implemented by the plugin are listed in the following table:

Variable Description
host MySQL Server IP
(Defaults to UNIX socket if not provided.)
port MySQL Server Port
(Defaults to 3306 for network connections.)
database MySQL Database (NULL by default.)
user Database User Name
(The default is the login of OS user for UNIX sockets.
Must be specified for network connections.)
password Database User Password
(Attempt login without password by default.)
include_db Comma separated list of databases to include in detail graphs.
(All enabled by default.)
exclude_db Comma separated list of databases to exclude from detail graphs.
detail_graphs Enable (on) / disable (off) detail graphs.
(Disabled by default.)
include_engine Comma separated list of storage engines to include graphs. (All enabled by default.)
exclude_engine Comma separated list of storage engines to exclude from graphs.
include_graphs Comma separated list of enabled graphs.
(All graphs enabled by default.)
exclude_graphs Comma separated list of disabled graphs.

Additionally the following configuration variables are implemented by the plugin for Multi Instance support:

Variable Description
instance_name Name of instance.
instance_label Graph title label for instance. (Default is the same as instance name.)
instance_label_format Controls how the instance label will be added to the graph title:
  • suffix (Default)
  • prefix
  • none

Credits

MySQL Database Server Plugin ( mysqlstats ) has been developed by Ali Onur Uyar ([aouyar @ GitHub] (https://github.com/aouyar)).

License

MySQL Database Server Plugin ( mysqlstats ) is copyrighted free software made available under the terms of the GPL License Version 3 or later.

See the file COPYING that acompanies the code for full licensing information.