[collectd] MySQL plugin reports wrong numbers on mysqld restart

[XANi]

Dnia 2010-09-29, śro o godzinie 03:09 +0200, Bostjan Skufca pisze:

> Maybe it's time to make a script for automated dump/change obviously
> invalid data to NaN/import of rrds.
> 
> Anyway, it is indeed COUNTER in my RRD files.
> Do you know how  why it was not DERIVE specified at rrd creation?
> 
> Probably I should consult google and manuals for this, but: is there
> an easy way to change from COUNTER to DERIVE or do I have to dump and
> reload the data?
> 
> Thanks!
> b.
> 

Easiest fix would be stopping collectd for a minute, and then mysql
restart. Datatype was not DERIVE probably because mysql plugin (as many
other) is much older than actual DERIVE support in collectd :)
As for changing counter to derive, simple rrdtool dump to xml file and
find/replace should be enougth

-- 
Mariusz Gronczewski (XANi) <xani666 at gmail.com>
GnuPG: 0xEA8ACE64
http://devrandom.pl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20100929/f7c9b94c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20100929/f7c9b94c/attachment.pgp>