Re: Graphing the Delta

Once upon a time, Tory M Blue <[email protected]> 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 <[email protected]>
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