Also, updated the sample configuration in collectd.conf.in.
#</Plugin>
#<Plugin mysql>
#</Plugin>
#<Plugin mysql>
-# Host "database.serv.er"
-# User "db_user"
-# Password "secret"
-# Database "db_name"
+# <Database db_name>
+# Host "database.serv.er"
+# User "db_user"
+# Password "secret"
+# Database "db_name"
+# </Database>
+#
+# <Database db_name2>
+# Host "localhost"
+# Socket "/var/run/mysql/mysqld.sock"
+# </Database>
#</Plugin>
#<Plugin netlink>
#</Plugin>
#<Plugin netlink>
-The C<mysql plugin> requires B<mysqlclient> to be installed. It connects to the
-database when started and keeps the connection up as long as possible. When the
-connection is interrupted for whatever reason it will try to re-connect. The
-plugin will complaint loudly in case anything goes wrong.
+The C<mysql plugin> requires B<mysqlclient> to be installed. It connects to
+one or more databases when started and keeps the connection up as long as
+possible. When the connection is interrupted for whatever reason it will try
+to re-connect. The plugin will complaint loudly in case anything goes wrong.
This plugin issues the MySQL C<SHOW STATUS> command and collects information
about MySQL network traffic, executed statements, requests, the query cache
This plugin issues the MySQL C<SHOW STATUS> command and collects information
about MySQL network traffic, executed statements, requests, the query cache
B<MySQL reference manual>, I<5.1.6. Server Status Variables> for an
explanation of these values.
B<MySQL reference manual>, I<5.1.6. Server Status Variables> for an
explanation of these values.
-Use the following options to configure the plugin:
+Synopsis:
+
+ <Plugin mysql>
+ <Database foo>
+ Host "hostname"
+ User "username"
+ Password "password"
+ Port "3306"
+ </Database>
+
+ <Database bar>
+ Host "localhost"
+ Socket "/var/run/mysql/mysqld.sock"
+ </Database>
+ </Plugin>
+
+A B<Database> block defines one connection to a MySQL database. It accepts a
+single argument which specifies the name of the database. None of the other
+options are required. MySQL will use default values as documented in the
+section "mysql_real_connect()" in the B<MySQL reference manual>.