Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-10-04 Thread XANi
Do you know how why it was not DERIVE specified at rrd creation? Datatype was not DERIVE probably because mysql plugin (as many other) is much older than actual DERIVE support in collectd :) 100% right: Support for DERIVE was added relatively late – much later than the MySQL plugin.

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-29 Thread 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?

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-29 Thread Florian Forster
Hi Bostjan, Mariusz and everybody else ;) On Wed, Sep 29, 2010 at 02:47:08PM +0200, XANi wrote: 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. What's obvious to you

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-29 Thread Bostjan Skufca
Hey, by my calculations in six hours I should receive a reply with even easier solution to all issues mentioned and maybe some other ones too. :) Serious business below. :) On 29 September 2010 17:56, Florian Forster o...@collectd.org wrote: Hi Bostjan, Mariusz and everybody else ;) On Wed,

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-29 Thread Bostjan Skufca
This COUNTER-DERIVE does the trick. Transition script complete, thanks for all your help. b. On 29 September 2010 20:15, Bostjan Skufca bost...@a2o.si wrote: Hey, by my calculations in six hours I should receive a reply with even easier solution to all issues mentioned and maybe some other

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-28 Thread Bostjan Skufca
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

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-28 Thread matthew sporleder
The types database determines what type of RRA is used. I would call this an enhancement to the mysql plugin. As far as changing it, I'm not totally sure about the best way. On Tue, Sep 28, 2010 at 9:09 PM, Bostjan Skufca bost...@a2o.si wrote: Maybe it's time to make a script for automated

[collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-27 Thread Bostjan Skufca
Hi all! Has anyone else noticed that MySQL plugin reports wrong numbers when mysql is restarted and collectd is not? It seems like it takes absolute value of i.e. queries per second (0 when mysql is restarted minus i.e. 8 million just before restart) and calculates abs(- 8 million) = 8Mqps. If I

Re: [collectd] MySQL plugin reports wrong numbers on mysqld restart

2010-09-27 Thread matthew sporleder
On Mon, Sep 27, 2010 at 7:44 AM, Bostjan Skufca bost...@a2o.si wrote: Hi all! Has anyone else noticed that MySQL plugin reports wrong numbers when mysql is restarted and collectd is not? It seems like it takes absolute value of i.e. queries per second (0 when mysql is restarted minus i.e. 8