X-Git-Url: https://git.verplant.org/?a=blobdiff_plain;f=src%2Fcollectd.conf.pod;h=29a1d1457ca3367587fb80293ec92c06dac54101;hb=4a9d11514a7e95d89dafc3f7f5f4610e707ae9e3;hp=6a1cdd2cad75f2a32103d787cb8335dbe642bc6f;hpb=f4fc8f7c74f2071e02ed40722e044bb8f92aa8d4;p=collectd.git
diff --git a/src/collectd.conf.pod b/src/collectd.conf.pod
index 6a1cdd2c..29a1d145 100644
--- a/src/collectd.conf.pod
+++ b/src/collectd.conf.pod
@@ -3487,7 +3487,8 @@ L.
- Statement "SELECT collectd_insert($1, $2, $3, $4, $5, $6, $7, $8);"
+ Statement "SELECT collectd_insert($1, $2, $3, $4, $5, $6, $7, $8, $9);"
+ StoreRates true
@@ -3510,6 +3511,7 @@ L.
# ...
Writer sqlstore
+ CommitInterval 10
@@ -3686,8 +3688,8 @@ This mandatory option specifies the SQL statement that will be executed for
each submitted value. A single SQL statement is allowed only. Anything after
the first semicolon will be ignored.
-Eight parameters will be passed to the statement and should be specified as
-tokens B<$1>, B<$2>, through B<$8> in the statement string. The following
+Nine parameters will be passed to the statement and should be specified as
+tokens B<$1>, B<$2>, through B<$9> in the statement string. The following
values are made available through those parameters:
=over 4
@@ -3725,6 +3727,13 @@ sources of the submitted value-list).
=item B<$8>
+An array of types for the submitted values (i.Ee., the type of the data
+sources of the submitted value-list; C, C, ...). Note, that if
+B is enabled (which is the default, see below), all types will be
+C.
+
+=item B<$9>
+
An array of the submitted values. The dimensions of the value name and value
arrays match.
@@ -3758,6 +3767,17 @@ for details.
Specify the interval with which the database should be queried. The default is
to use the global B setting.
+=item B I
+
+This option may be used for database connections which have "writers" assigned
+(see above). If specified, it causes a writer to put several updates into a
+single transaction. This transaction will last for the specified amount of
+time. By default, each update will be executed in a separate transaction. Each
+transaction generates a fair amount of overhead which can, thus, be reduced by
+activating this option. The draw-back is, that data covering the specified
+amount of time will be lost, for example, if a single statement within the
+transaction fails or if the database server crashes.
+
=item B I
Specify the hostname or IP of the PostgreSQL server to connect to. If the