[collectd] How to store MySQL statistics?

[Jan Huijsmans]

On Tue, Dec 20, 2005 at 10:45:51AM +0100, Niki Waibel wrote:
> i have EXACTLY the same problem with the quota plugin!!!!!
> there can be more or less users, groups and dirs!!!
> it is even worse!!!
> 
> at the moment i create files like this:
>         quota-<type>-<name>-<id>-<dir>.rrd
> type: usr/grp/prj
> name: niki/octo/users/...
> id:   100/101/500/...
> dir:  ie _
>       or _video
>       or _crypto_disc_a
> (dir: all / converted to _)

I found that using _ to replace / can cause some problems. Some people
tend to use the _ in the directory name. No problem in storing the data,
but during report you would want to convert the _ back again to / to be
able to display the correct path.

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.

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?)

Just my 2 euro cents.

---

Jan Huijsmans              bofh at koffie.nu
                           huysmans at xs4all.nl