読者です 読者をやめる 読者になる 読者になる

RDS監視をMunin標準のMySQLプラグイン(mysql_)を修正して実装する

AWS MySQL Munin

以下の記事でRDSをCloudWatch経由でMunin監視する方法について書きましたが、標準Pluginのmysql2(mysql_)で監視する方法について書きます。

yomon.hatenablog.com

標準プラグインの修正

最終的に出力するグラフをきれいにするために、ほんの少し(1行)だけ標準のプラグインを修正します。

標準のmysql2のPluginをバックアップしておきます。

# cd /usr/share/munin/plugins
# cp -ai mysql_ mysql_.org

修正は以下の一行追加するだけです。

print "host_name $ENV{'dbname'}\n";

バージョンによって多少異なるかもしれませんが、以下のように行を追加しています。

# grep -n -10 'dbname' mysql_
823-    #   +--------------------------+-------+
824-    #   | low_priority_updates     | OFF   |
825-    #   | sql_low_priority_updates | OFF   |
826-    #   +--------------------------+-------+
827-    #   2 rows in set (0.00 sec)
828-    #
829-    # Not a problem since we don't graph these
830-
831-    die 'Unknown graph ' . ($graph_name ? $graph_name : '')
832-   unless $graphs{$graph_name};
833:    print "host_name $ENV{'dbname'}\n"; #<-この行を追加
834-
835-    my $graph = $graphs{$graph_name}; 
836-
837-    my %conf = (%{$defaults{global_attrs}}, %{$graph->{config}{global_attrs}});
838-    while (my ($k, $v) = each %conf) {
839-   print "graph_$k $v\n";
840-    }
841-    print "graph_category mysql2\n";
842-
843-    my $i = 0;

設定ファイルに接続設定追加

以下のファイルを修正します。

# vi /etc/munin/plugin-conf.d/munin-node

RDSのMySQLへの接続情報を追加します。mysqlX_*という設定がありますが、ここの値を後に出てくるシンボリックリンク名と合わせます。

先ほど標準プラグインに追加した行を活かすために、設定値にも標準の内容に加えてenv.dbnameというパラメータを追加します。ここでの値がMuninのグラフでノード名として表示されることになります。

[mysql1_*]
env.dbname mydb01
env.mysqlconnection DBI:mysql:mysql;host=mydb01.xxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com
env.mysqluser root
env.mysqlpassword passw0rd

[mysql2_*]
env.dbname mydb02
env.mysqlconnection DBI:mysql:mysql;host=mydb02.xxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com
env.mysqluser root
env.mysqlpassword passw0rd

プラグインインストール(シンボリックリンク作成)

mysql2のプラグインで取得できる内容は以下の通りです。

# /usr/share/munin/plugins/mysql_ suggest
bin_relay_log
commands
connections
files_tables
innodb_bpool
innodb_bpool_act
innodb_insert_buf
innodb_io
innodb_io_pend
innodb_log
innodb_rows
innodb_semaphores
innodb_tnx
myisam_indexes
network_traffic
qcache
qcache_mem
replication
select_types
slow
sorts
table_locks
tmp_tables

設定値で設定したようにmysql1*とmysql2*のインスタンスに対してプラグインを導入(シンボリックリンクの作成)します。

以下のように一つづつ作成していくこともできますが、

# ln -s /usr/share/munin/plugins/mysql1_ /etc/munin/plugins/mysql2_commands
# ln -s /usr/share/munin/plugins/mysql2_ /etc/munin/plugins/mysql2_commands

一気に作ってしまいます。

# /usr/share/munin/plugins/mysql_ suggest | xargs -Ixxx ln -s /usr/share/munin/plugins/mysql_ /etc/munin/plugins/mysql1_xxx
# /usr/share/munin/plugins/mysql_ suggest | xargs -Ixxx ln -s /usr/share/munin/plugins/mysql_ /etc/munin/plugins/mysql2_xxx

リンクが作成されました。

# ll /etc/munin/plugins/mysql*
lrwxrwxrwx. 1 root root 31  513 03:10 /etc/munin/plugins/mysql1_bin_relay_log -> /usr/share/munin/plugins/mysql_
lrwxrwxrwx. 1 root root 31  513 03:10 /etc/munin/plugins/mysql1_commands -> /usr/share/munin/plugins/mysql_
lrwxrwxrwx. 1 root root 31  513 03:10 /etc/munin/plugins/mysql1_connections -> /usr/share/munin/plugins/mysql_
--省略

munin-nodeを再起動して反映させます。

# systemctl restart munin-node

コマンドラインから挙動確認

munin-runコマンドで挙動確認します。

設定が正しくできていると、一番上に「host_name mydb01」や「host_name mydb02」が出るはずです。

# munin-run mysql1_commands config
host_name mydb01
graph_args --base 1000
graph_title Command Counters
graph_vlabel Commands per ${graph_period}
--省略

# munin-run mysql2_commands config
host_name mydb02
graph_args --base 1000
graph_title Command Counters
graph_vlabel Commands per ${graph_period}
--省略

値が取れることも確認しておきます。認証情報や接続先情報が間違っているとエラー出るはずです。

# munin-run mysql1_commands
Com_delete.value 4
Com_insert.value 22966
Com_insert_select.value 1
Com_load.value 0
Com_replace.value 0
Com_replace_select.value 0
Com_select.value 58556
Com_update.value 19
Com_update_multi.value 1

# munin-run mysql2_commands
Com_delete.value 4
Com_insert.value 22966
Com_insert_select.value 1
Com_load.value 0
Com_replace.value 0
Com_replace_select.value 0
Com_select.value 58556
Com_update.value 19
Com_update_multi.value 1

DB接続用のモジュールが入っていない場合は以下の通りインストールします。

# yum -y install DBD::mysql

Munin設定

仮想ノードを追加します。

# vi /etc/munin/munin.conf 
[rds;mydb01]
    address 127.0.0.1
    use_node_name no

[rds;mydb02]
    address 127.0.0.1
    use_node_name no

念のためmunin-nodeを再起動して設定は完了です。

systemctl restart munin-node

できたグラフがこちらになります。PluginはMuninと同一サーバー上で動いているのですが、仮想ノードとして登録することで見やすくしています。

f:id:yomon8:20160513182613p:plain

f:id:yomon8:20160513182621p:plain

デバッグ方法

上手くグラフが出ない場合は、以下の方法でデバッグしていきます。

# su - munin --shell=/bin/sh
$ /usr/share/munin/munin-update --debug --nofork --host mydb01 --service mysql1_commands

上記コマンドの正常な場合のアウトプットを載せておきます。

2016/05/13 05:05:15 [DEBUG] Creating new lock file /var/run/munin/munin-update.lock
2016/05/13 05:05:15 [DEBUG] Creating lock : /var/run/munin/munin-update.lock succeeded
2016/05/13 05:05:15 [INFO]: Starting munin-update
2016/05/13 05:05:15 [DEBUG] Creating new lock file /var/run/munin/munin-rds-mydb01.lock
2016/05/13 05:05:15 [DEBUG] Creating lock : /var/run/munin/munin-rds-mydb01.lock succeeded
2016/05/13 05:05:15 [DEBUG] Reading state for rds-mydb01 in /var/lib/munin/state-rds-mydb01.storable
2016/05/13 05:05:15 [INFO] starting work in 3060 for mydb01/127.0.0.1:4949.
2016/05/13 05:05:15 [INFO] node mydb01 advertised itself as localhost.localdomain instead.
2016/05/13 05:05:15 TLS set to "disabled".
2016/05/13 05:05:15 [DEBUG] Negotiating capabilities
2016/05/13 05:05:15 [DEBUG] Writing to socket: "cap multigraph dirtyconfig
".
2016/05/13 05:05:15 [DEBUG] Node says /cap multigraph dirtyconfig/
2016/05/13 05:05:15 [DEBUG] Writing to socket: "list mydb01
".
2016/05/13 05:05:15 [DEBUG] for my mysql1_commands (mysql1_qcache_mem mysql1_innodb_io_pend mysql1_innodb_insert_buf mysql1_myisam_indexes rds_mydb01_cloudwatch mysql1_bin_relay_log mysql1_innodb_tnx mysql1_tmp_tables mysql1_replication mysql1_commands mysql1_table_locks mysql1_innodb_rows mysql1_select_types mysql1_files_tables mysql1_innodb_log mysql1_slow mysql1_connections mysql1_sorts mysql1_innodb_bpool mysql1_innodb_semaphores mysql1_network_traffic mysql1_qcache mysql1_innodb_bpool_act mysql1_innodb_io)
2016/05/13 05:05:15 [DEBUG] Fetching service configuration for 'mysql1_commands'
2016/05/13 05:05:15 [DEBUG] Writing to socket: "config mysql1_commands
".
2016/05/13 05:05:15 [DEBUG] Reading from socket: "host_name mydb01\ngraph_args --base 1000\ngraph_title Command Counters\ngraph_vlabel Commands per ${graph_period}\ngraph_total Questions\ngraph_category mysql2\nCom_delete.draw AREA\nCom_delete.min 0\nCom_delete.label Delete\nCom_delete.type DERIVE\nCom_insert.draw STACK\nCom_insert.min 0\nCom_insert.label Insert\nCom_insert.type DERIVE\nCom_insert_select.draw STACK\nCom_insert_select.min 0\nCom_insert_select.label Insert select\nCom_insert_select.type DERIVE\nCom_load.draw STACK\nCom_load.min 0\nCom_load.label Load Data\nCom_load.type DERIVE\nCom_replace.draw STACK\nCom_replace.min 0\nCom_replace.label Replace\nCom_replace.type DERIVE\nCom_replace_select.draw STACK\nCom_replace_select.min 0\nCom_replace_select.label Replace select\nCom_replace_select.type DERIVE\nCom_select.draw STACK\nCom_select.min 0\nCom_select.label Select\nCom_select.type DERIVE\nCom_update.draw STACK\nCom_update.min 0\nCom_update.label Update\nCom_update.type DERIVE\nCom_update_multi.draw STACK\nCom_update_multi.min 0\nCom_update_multi.label Update multi\nCom_update_multi.type DERIVE".
2016/05/13 05:05:15 [DEBUG] config: 0.091033 sec for 'mysql1_commands' on mydb01/127.0.0.1/4949
2016/05/13 05:05:15 [DEBUG] Now parsing config output from plugin mysql1_commands on mydb01
2016/05/13 05:05:15 [DEBUG] update_rate 0 for mysql1_commands on mydb01/127.0.0.1:4949
2016/05/13 05:05:15 [DEBUG] No service data for mysql1_commands, fetching it
2016/05/13 05:05:15 [DEBUG] Writing to socket: "fetch mysql1_commands
".
2016/05/13 05:05:15 [DEBUG] data: 0.081371 sec for 'mysql1_commands' on mydb01/127.0.0.1/4949
2016/05/13 05:05:15 [DEBUG] Now parsing fetch output from plugin mysql1_commands on mydb01/127.0.0.1:4949
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_delete.value 4
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 4 in Com_delete
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_insert.value 22967
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 22967 in Com_insert
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_insert_select.value 1
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 1 in Com_insert_select
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_load.value 0
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 0 in Com_load
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_replace.value 0
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 0 in Com_replace
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_replace_select.value 0
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 0 in Com_replace_select
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_select.value 58738
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 58738 in Com_select
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_update.value 19
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 19 in Com_update
2016/05/13 05:05:15 [FETCH from mysql1_commands] Com_update_multi.value 1
2016/05/13 05:05:15 [FETCH from mysql1_commands] Storing 1 in Com_update_multi
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_select-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_select-d.rrd with 1463130315:58738
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_delete-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_delete-d.rrd with 1463130315:4
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_insert-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_insert-d.rrd with 1463130315:22967
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_replace-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_replace-d.rrd with 1463130315:0
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_update_multi-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_update_multi-d.rrd with 1463130315:1
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_replace_select-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_replace_select-d.rrd with 1463130315:0
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_insert_select-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_insert_select-d.rrd with 1463130315:1
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_update-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_update-d.rrd with 1463130315:19
2016/05/13 05:05:15 [DEBUG] asking for a rrd of size : normal
2016/05/13 05:05:15 [DEBUG] rrd filename: /var/lib/munin/rds/mydb01-mysql1_commands-Com_load-d.rrd
2016/05/13 05:05:15 [DEBUG] Updating /var/lib/munin/rds/mydb01-mysql1_commands-Com_load-d.rrd with 1463130315:0
2016/05/13 05:05:15 [DEBUG] set_spoolfetch_timestamp(1463130315)
2016/05/13 05:05:15 [DEBUG] Writing to socket: "quit 
".
2016/05/13 05:05:15 [DEBUG] quit: 9.2e-05 sec on mydb01/127.0.0.1/4949
2016/05/13 05:05:15 [DEBUG] Everything went smoothly.
2016/05/13 05:05:15 [DEBUG] Writing state for rds-mydb01 in /var/lib/munin/state-rds-mydb01.storable
2016/05/13 05:05:15 [DEBUG] about to write '/var/lib/munin/state-rds-mydb01.storable'
2016/05/13 05:05:15 [INFO]: Munin-update finished for node rds;mydb01 (0.23 sec)
2016/05/13 05:05:15 [DEBUG] Creating new lock file /var/run/munin/munin-datafile.lock
2016/05/13 05:05:15 [DEBUG] Creating lock : /var/run/munin/munin-datafile.lock succeeded
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.host_name" = "mydb01"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_args" = "--base 1000"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_title" = "Command Counters"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_vlabel" = "Commands per ${graph_period}"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_total" = "Questions"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_category" = "mysql2"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.graph_order" = "Com_delete Com_insert Com_insert_select Com_load Com_replace Com_replace_select Com_select Com_update Com_update_multi"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_select.label" = "Select"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.draw" = "AREA"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_delete.label" = "Delete"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert.label" = "Insert"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace.label" = "Replace"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update_multi.label" = "Update multi"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_replace_select.label" = "Replace select"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_insert_select.label" = "Insert select"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_update.label" = "Update"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.update_rate" = "300"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.draw" = "STACK"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.min" = "0"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.graph_data_size" = "normal"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.type" = "DERIVE"
2016/05/13 05:05:15 [DEBUG] munin_set_var_path: Setting var "rds;mydb01:mysql1_commands.Com_load.label" = "Load Data"
2016/05/13 05:05:15 [DEBUG] Writing state to /var/lib/munin/datafile.storable
2016/05/13 05:05:15 [DEBUG] about to write '/var/lib/munin/datafile.storable'
2016/05/13 05:05:15 [INFO]: Munin-update finished (0.28 sec)