[collectd] How to store MySQL statistics?

Jan Huijsmans bofh at koffie.nu
Tue Dec 20 16:29:54 CET 2005

On Tue, Dec 20, 2005 at 02:08:14PM +0100, Niki Waibel wrote:
> > During some tests I found that relpacing / with __ (2x _) is very usefull.
> > Programs don't crash on this en people don't use a double _ in the directory
> > name.
> well, 1 _ was just to make it very easy to convert the c char* string.
> it is compleately suboptimal, but for testing it is fine.

Ah, ok.

> > Oh, I was wondering, why include a type and name in the filename? With id and
> > dir you should be able to identify the quota you're storing? (or am i missing
> > something?)
> seems you are missing sthg. it makes a great difference if
> you are counting the
>         redflag user quota, dir=/home/redflag, id=5000 (uid)
> or the
>         redflag group quota, dir=/home/redflag, id=5000 (gid)
> assuming that NOT JUST redflag CAN WRITE INTO /home/redflag!!!!!


You'll get a lot of files this way, but hey, unix should be able to cope
with them. To differentiate between uiser or group id I would use the type
field, but I'm still missing the use of the name field. The name of the
group/user can be found via systemcalls or in plain files while processing
the rrddata instead of during data gathering. (or at least, it looks like it
would simplify the gathering process a bit)


Jan Huijsmans              bofh at koffie.nu

... cannot activate /dev/brain, no response from main coffee server

More information about the Collectd mailing list