[rrd-users] rrdtool fetch question- actual output

[John Giordano]

thanks to Alex for responding.  thanks to Tobi for helping me out on the list probs I was having.

ok.  I agree that the numbers on BW pulled from the data inside the .RRD seem legit.  what I was trying to ask is how
can I look at the actual data inside the .RRD to see if they add up to ~40 GigaBytes for that month.

this customer never pushed this kind of BW so I was hoping to use rrdtool fetch to see when and how much they pushed at certain times during the month.  basically I don't trust the SNMP data that was sent from the router to the .RRD

ala:

[Wed May 14 | isaac at serengeti:/home/mrtg_user/bin/rrdtool-1.0.33/MooreSoftCheck]$ ./rrdtool fetch 206.63.1.249_206.129.54.65.rrd AVERAGE -s '4/1/03' -e '5/1/03' 

                      ds0           ds1

1049220000: 3.6988782715e+00 4.0780449382e+00
1049227200: 3.6753437936e+00 4.1396493491e+00

basically the rrdtool fetch gives me three columns:

time:   DS0:    DS1:

thanks,
jg



-----Original Message-----
From: Alex van den Bogaerdt [mailto:alex at ergens.op.het.net]
Sent: Saturday, May 17, 2003 3:22 AM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: rrdtool fetch question- what is what?


On Fri, May 16, 2003 at 04:11:38PM -0700, John Giordano wrote:

> foo moved:  39.7927987740375 GigaBytes for 4/1/03 2:30pm to 5/1/03 2:30pm (this would be for both INBOUND and OUTBOUND)

It seems you are mixing output from the command with your own remarks.
Please don't.  This makes it hard to follow.


> serengeti# cat working-cmd-month-stdout-IN
> ./rrdtool graph /dev/null  --start '4/1/03 2:30pm' --end '5/1/03 2:30pm' DEF:inoctets=myrouter.rrd:ds0:AVERAGE CDEF:in=inoctets,8,* PRINT:in:AVERAGE:"%lf"
> ##This is inoctets multiplied by 8 thereby giving me bits

> serengeti# ./working-cmd-month-stdout-OUT
> 0x0
> 65164.533407 / 8 * 86400 * 30 = 21113136000

> serengeti# ./working-cmd-month-stdout-IN
> 0x0
> 65978.750124 / 8 * 86400 * 30 = 21376872000
> serengeti#

So the output would be

    0x0
    65164.533407

and

    0x0
    65978.750124

On average this user has approximately 65 kbps outbound and 66 kbps inbound.
This is pretty low.  On a graph this will show up as a couple of lines on
top of the X-Axis, especially if there are larger peaks to, say, 2 Mbps.

Let's work with 64 kbps just to make easy example numbers.  64 kilobit
each second.  That's 64*3600 = 230400 kilobit or 230 megabit per hour.
It's also 64*86400 = 5529600 kilobit or 6629 megabit or 6.6 gigabit per day.

6.6 gigabit per day...  times 30 for a month, divide by 8 for bytes, this
is about 24 GBytes.

The traffic is full duplex so 24*2 = 48 GBytes.  *Why* is there no way
this user consumed 42 GB of precious bandwidth ?

You say it yourself, the traffic looks normal,  as do the calculations.
42 GB *is* a normal number.

cheers,
Alex
-- 
Much of what looks like rudeness in hacker circles is not intended to give
offence. Rather, it's the product of the direct, cut-through-the-bullshit
communications style that is natural to people who are more concerned about
solving problems than making others feel warm and fuzzy.

http://www.tuxedo.org/~esr/faqs/smart-questions.html

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi