[collectd] mysql plugin display same data for different databases

[Salimane Adjao Moustapha]

Hi,

Thanks for the explanation, but if the "database" option could be available
, it would be awesome.

Thanks

  *Salimane Adjao Moustapha*
 Thinker, Trend Watcher, Real Solutions Builder
 *Software Craftsman @  Ethos Technologies <http://www.ethos.com.cn/>*

 [image: LinkedIn] <http://www.linkedin.com/in/salimane> [image:
Google]<http://www.google.com/profiles/salimane>
 [image: SlideShare] <http://www.slideshare.net/salimane/favorites> [image:
YouTube] <http://youtube.com/user/salimanevideos> [image:
Twitter]<http://twitter.com/msalimane>
 [image: Facebook] <http://www.facebook.com/salimane>



On Fri, Sep 3, 2010 at 4:50 PM, Sebastian Harl <sh at tokkee.org> wrote:

> Hey,
>
> On Fri, Sep 03, 2010 at 08:36:15AM +0200, Florian Forster wrote:
> > 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.
>
> The problem is that "SHOW STATUS" reports accumulated information for
> the whole process only. If you know some way to get statistics about a
> single database only, that could be added to the plugin as well. If you
> did up a way to get those information, I'd provide a patch for the
> plugin ;-)
>
> > 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.
>
> Right ;-)
>
> Cheers,
> Sebastian
>
> --
> Sebastian "tokkee" Harl +++ GnuPG-ID: 0x8501C7FC +++ http://tokkee.org/
>
> Those who would give up Essential Liberty to purchase a little Temporary
> Safety, deserve neither Liberty nor Safety.         -- Benjamin Franklin
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAkyAtuwACgkQEFEKc4UBx/zlnwCgjdoxR1H8tRjjc/k2UwexY0A1
> H3UAn3j/YoPZlySVcTZ5jH0E0ArbzvwQ
> =Ef1j
> -----END PGP SIGNATURE-----
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20100903/b92b6d86/attachment-0001.htm>