[collectd] Mysql plugin works very strange

[Benjamin Wang (gendwang)]

Hi,
  When I setup collectd and mysql, there are 5 rrd files generated for mysql_commands as following:
mysql_commands-admin_commands.rrd
mysql_commands-select.rrd
mysql_commands-show_databases.rrd
mysql_commands-show_master_status.rrd
mysql_commands-show_status.rrd

Then I reboot the machine, two strange things happen:

1.      mysql_commands-show_master_status.rrd will not be updated

2.      There are 3 more rrd files generated(mysql_commands-change_db.rrd, mysql_commands-show_fields.rrd, mysql_commands-show_tables.rrd)

Next is the latest ls result:
[root at crdc-c210-141 mysql-example]# ls -al
total 156
drwxr-xr-x.  2 root root  4096 Mar 21 14:03 .
drwxr-xr-x. 13 root root  4096 Mar 14 14:40 ..
-rw-r--r--.  1 root root  5320 Mar 21 22:37 mysql_commands-admin_commands.rrd
-rw-r--r--.  1 root root  5320 Mar 21 16:34 mysql_commands-change_db.rrd
-rw-r--r--.  1 root root  5320 Mar 21 22:37 mysql_commands-select.rrd
-rw-r--r--.  1 root root  5320 Mar 21 22:37 mysql_commands-show_databases.rrd
-rw-r--r--.  1 root root  5320 Mar 21 16:34 mysql_commands-show_fields.rrd
-rw-r--r--.  1 root root  5320 Mar 21 16:34 mysql_commands-show_master_status.rrd
-rw-r--r--.  1 root root  5320 Mar 21 22:37 mysql_commands-show_status.rrd
-rw-r--r--.  1 root root  5320 Mar 21 16:34 mysql_commands-show_tables.rrd


B.R.
Benjamin Wang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20130321/09b5c73c/attachment.html>