Re: [collectd] mysql plugin display same data for different databases

2010-09-03 Thread 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/


signature.asc
Description: Digital signature
___
collectd mailing list
collectd@verplant.org
http://mailman.verplant.org/listinfo/collectd

Re: [collectd] mysql plugin display same data for different databases

2010-09-03 Thread 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 s...@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-


___
collectd mailing list
collectd@verplant.org
http://mailman.verplant.org/listinfo/collectd