From 7c349a69497c598b94b6a54e3e63d1bb3e59e4f5 Mon Sep 17 00:00:00 2001
From: Sebastian Harl <sh@tokkee.org>
Date: Fri, 20 Mar 2009 21:36:01 +0100
Subject: [PATCH] collectd.conf(5): Documented the <Database> blocks.

Also, updated the sample configuration in collectd.conf.in.
---
 src/collectd.conf.in  | 15 +++++++++++----
 src/collectd.conf.pod | 29 ++++++++++++++++++++++++-----
 2 files changed, 35 insertions(+), 9 deletions(-)

diff --git a/src/collectd.conf.in b/src/collectd.conf.in
index 3abc24d1..44eaa974 100644
--- a/src/collectd.conf.in
+++ b/src/collectd.conf.in
@@ -318,10 +318,17 @@ FQDNLookup   true
 #</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>
diff --git a/src/collectd.conf.pod b/src/collectd.conf.pod
index 19ca6c50..00854ef6 100644
--- a/src/collectd.conf.pod
+++ b/src/collectd.conf.pod
@@ -1375,10 +1375,10 @@ TCP-Port to connect to. Defaults to B<11211>.
 
 =head2 Plugin C<mysql>
 
-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
@@ -1387,7 +1387,26 @@ C<Handler_*>, C<Qcache_*> and C<Threads_*> return values. Please refer to the
 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>.
 
 =over 4
 
-- 
2.30.2