Hello
On 09.05.2012 10:24, Kinh Vân Bộ wrote:
But I can enable plugin MySQL, I uncomment some lines in file config
collectd.confg and restart collectd (/etc/init.d/collect restart)
LoadPlugin mysql
<Plugin mysql>
<Database "my_database">
Host "localhost"
User "user"
Password "password"
Port "3306"
Socket "/var/run/mysqld/mysqld3.sock"
</Database>
</Plugin>
After i access my collectd, but plugin MySQL's not appearance so I hope
your support, it'll help me out. Thank you.
For the MySQL Plugin to work, you need to create a user in MySQL.
This can be done with this commands (replace <password> with a
random string of letters and numbers):
mysql -u root -p
mysql> create user 'collectd'@'localhost' identified by '<password>';
mysql> exit
If you want to monitor the whole MySQL server (and not only a
single database on that server) then you can use this in the
collectd.conf (again, replace <password> with the same letters
and numbers as you have used above in MySQL, also verify the path
to the Socket):
<Plugin mysql>
<Database "">
Host "localhost"
Socket "/var/run/mysqld/mysqld3.sock"
User "collectd"
Password "<password>"
</Database>
</Plugin>
And please can I ask one question, when I comment some line and restart
collect but they still apearance, I don't know why :(, please help me.
If you do disable plugins after they have been in use, collectd
does not remove the already generated *.rrd files. You need to
manually remove them.
bye
Fabian
_______________________________________________
collectd mailing list
[email protected]
http://mailman.verplant.org/listinfo/collectd
