[collectd] mysql plugin display same data for different databases

[Florian Forster]

Hi Salimane,

On Thu, Sep 02, 2010 at 05:54:43PM +0800, Salimane Adjao Moustapha wrote:
>  even though i specified different databases , collection3 display the same
> data for all the databases.
> 
>  <Database core>
> Host "10.0.0.1"

> <Database core_oma>
> Host "10.0.0.1"

> <Database core_uutiset>
>  Host "10.0.0.1"

thanks to MySQL, the terminology here is a bit confusing. The term
"database" is used both, for the MySQL *process* and for an abstract
unit -- a set of tables -- within such a process.

The MySQL plugin collects information concerning the *process*, not the
set of tables. Therefore, connecting to the same process three times
*should* produce the same statistics three times.

In all likelihood, you can omit the "Database" option within the
"<Database />" block altogether -- "selecting" a "database" is only
necessary to satisfy some weird access configurations, afaIk.

Regards,
--octo
-- 
Florian octo Forster
Hacker in training
GnuPG: 0x0C705A15
http://octo.it/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: Digital signature
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20100903/e9e1f138/attachment.pgp>