Tory M Blue | 18 Aug 19:40 2009
Picon

Graphing the Delta

W0w seems like it's been some time since I've had to ask a question.

I'm looking to trend/graph the delta. I will have an ever increasing
counter that I would like to grab the delta and graph that. (for
trending).

So I really want to be able to subtract the current result from the
previous result and having a hard time working that out. What am I
missing?

Thanks
Tory

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Chris Adams | 18 Aug 22:37 2009
Picon

Re: Graphing the Delta

Once upon a time, Tory M Blue <tmblue <at> gmail.com> said:
> W0w seems like it's been some time since I've had to ask a question.
> 
> I'm looking to trend/graph the delta. I will have an ever increasing
> counter that I would like to grab the delta and graph that. (for
> trending).
> 
> So I really want to be able to subtract the current result from the
> previous result and having a hard time working that out. What am I
> missing?

That's the way the interface counters work, so you can look at those for
examples.  You want to use DERIVE or COUNTER as your rrd-ds-type; note
that this is set at RRD creation time, so simply changing the Cricket
config later won't help.  You'll have to re-create (or at least dump,
edit, and restore) your RRDs.

See "man rrdcreate" for a little bit of discussion about DERIVE vs.
COUNTER.

--

-- 
Chris Adams <cmadams <at> hiwaay.net>
Systems and Network Administrator - HiWAAY Internet Services
I don't speak for anybody but myself - that's enough trouble.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
(Continue reading)

Tory M Blue | 19 Aug 00:07 2009
Picon

Re: Graphing the Delta

Chris responded>
> That's the way the interface counters work, so you can look at those for
> examples.  You want to use DERIVE or COUNTER as your rrd-ds-type; note
> that this is set at RRD creation time, so simply changing the Cricket
> config later won't help.  You'll have to re-create (or at least dump,
> edit, and restore) your RRDs.
>
> See "man rrdcreate" for a little bit of discussion about DERIVE vs.
> COUNTER.

Thanks guys,

Ya I rebooted and figured out that my question was flawed (brain
reboot, not system). I'm running a query on a DB and getting a
response with say, how many rows , I than run that same query an hour
later and would like to know how much it's changed.

Using DERIVE and COUNTERS my numbers in the graphs are like 6 1 2 when
the actual results of the query were;

Retrieved data for rows (): 281392,20695,88650

And the numbers previous were

 Retrieved data for rows (): 281016,20654,88501

So I'm unclear where cricket/rrd is grabbing the results of 6,1,2 ( as
seen in the graph), when the differential is quite a bit more.

I thought maybe it was in my scaling or use of integer in precision,
(Continue reading)

Chris Adams | 19 Aug 02:48 2009
Picon

Re: Graphing the Delta

Once upon a time, Tory M Blue <tmblue <at> gmail.com> said:
> Ya I rebooted and figured out that my question was flawed (brain
> reboot, not system). I'm running a query on a DB and getting a
> response with say, how many rows , I than run that same query an hour
> later and would like to know how much it's changed.
> 
> Using DERIVE and COUNTERS my numbers in the graphs are like 6 1 2 when
> the actual results of the query were;
> 
> Retrieved data for rows (): 281392,20695,88650
> 
> And the numbers previous were
> 
>  Retrieved data for rows (): 281016,20654,88501

(281392 - 281016) / 60 = 6.27 (6) per minute
(20695 - 20654) / 60 = 0.68 (1) per minute
(88650 - 88501) / 60 = 2.48 (2) per minute

> So I'm unclear where cricket/rrd is grabbing the results of 6,1,2 ( as
> seen in the graph), when the differential is quite a bit more.

What are you expecting your graph to look like?

--

-- 
Chris Adams <cmadams <at> hiwaay.net>
Systems and Network Administrator - HiWAAY Internet Services
I don't speak for anybody but myself - that's enough trouble.

------------------------------------------------------------------------------
(Continue reading)

Tory M Blue | 19 Aug 06:46 2009
Picon

Re: Graphing the Delta

On Tue, Aug 18, 2009 at 5:48 PM, Chris Adams<cmadams <at> mail.hiwaay.net> wrote:

>
> (281392 - 281016) / 60 = 6.27 (6) per minute
> (20695 - 20654) / 60 = 0.68 (1) per minute
> (88650 - 88501) / 60 = 2.48 (2) per minute
>
>> So I'm unclear where cricket/rrd is grabbing the results of 6,1,2 ( as
>> seen in the graph), when the differential is quite a bit more.
>
> What are you expecting your graph to look like?

Your a smart one :) Thanks.. I don't really care about the per minute,
I need to know how many rows have been added in the hour. And really
thanks, I had no idea. but that makes perfect sense now.

What I would like it to look like? I would like it to show me how many
rows were added in the last hour. I guess with what you told me here,
I could multiple the results by 60 (that just seems silly). It's
dawning on me that I'm missing a large bit of
information/understanding of what rrd/cricket is doing here

thanks Chris

Tory

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
(Continue reading)

Richman, Marc | 18 Aug 20:05 2009

Re: Graphing the Delta

Is there a reason you are not using the DERIVE datasource type?

-----Original Message-----
From: Tory M Blue [mailto:tmblue <at> gmail.com] 
Sent: Tuesday, August 18, 2009 1:40 PM
To: cricket-users <at> lists.sourceforge.net
Subject: [cricket-users] Graphing the Delta

W0w seems like it's been some time since I've had to ask a question.

I'm looking to trend/graph the delta. I will have an ever increasing
counter that I would like to grab the delta and graph that. (for
trending).

So I really want to be able to subtract the current result from the
previous result and having a hard time working that out. What am I
missing?

Thanks
Tory

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
cricket-users mailing list
cricket-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/cricket-users
(Continue reading)


Gmane