[rrd-users] Re: total data querry.

Tue Sep 23 00:05:42 MEST 2003

RRD is the Acronym for Round Robin Database. RRD is a system to store and display time-series data (i.e. network bandwidth, machine-room temperature, server load average). It stores the data in a very compact way that will not expand over time, and it presents useful graphs by processing the data to enforce a certain data density. It can be used either via simple wrapper scripts (from shell or Perl) or via frontends that poll network devices and put a friendly user interface on it.

You'll have to use a different tool.  As you can see, directly from the website, it is a system to store and display time-series data.  Not act like a traditional database like you are asking.

-Jase

-----Original Message-----
From: Logg, Connie A. [mailto:cal at SLAC.Stanford.EDU]
Sent: Monday, September 22, 2003 5:55 PM
To: Alex van den Bogaerdt
Cc: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: total data querry.

I raised a similar question. I want to use rrd's to display netflow record stats. I do not want any averaging, just totalling.
I have tried multiplying the average for the aggregation by number of points in that aggregation to get the "total" for a period, but the values are still not correct.

Here is my original question:

I am defining the following rrd, but I would like the 10 minute period to be the sum of all values entered in that period, And the first aggregation to be 4 points per day which is the sum of 6 hours worth of data, and 
For the final aggregation, I would like it to be the sum of all the values in the day.

This does not appear to be happening.  Is there a way to define the rrd so that it will do that?

I have read the documentation in gory detail, but can't figure it out.

I am processing netflow data as it comes in and want to display total 10 minute, total 6 hour, and total traffic for the day stats.

/afs/slac/package/rrdtool/i386_linux22/rrdtool create /u2/netflow/newrrddir/134.79.199.14/protocol.rrd --start 1041407600 --step 600 \ DS:inall_recs:GAUGE:600:U:U \ DS:outall_recs:GAUGE:600:U:U \ DS:inall_flows:GAUGE:600:U:U \ DS:outall_flows:GAUGE:600:U:U \ DS:inall_pkts:GAUGE:600:U:U \ DS:outall_pkts:GAUGE:600:U:U \ DS:inall_bytes:GAUGE:600:U:U \ DS:outall_bytes:GAUGE:600:U:U \ DS:intcp_recs:GAUGE:600:U:U \ DS:outtcp_recs:GAUGE:600:U:U \ DS:intcp_flows:GAUGE:600:U:U \ DS:outtcp_flows:GAUGE:600:U:U \ DS:intcp_pkts:GAUGE:600:U:U \ DS:outtcp_pkts:GAUGE:600:U:U \ DS:intcp_bytes:GAUGE:600:U:U \ DS:outtcp_bytes:GAUGE:600:U:U \ DS:inudp_recs:GAUGE:600:U:U \ DS:outudp_recs:GAUGE:600:U:U \ DS:inudp_flows:GAUGE:600:U:U \ DS:outudp_flows:GAUGE:600:U:U \ DS:inudp_pkts:GAUGE:600:U:U \ DS:outudp_pkts:GAUGE:600:U:U \ DS:inudp_bytes:GAUGE:600:U:U \ DS:outudp_bytes:GAUGE:600:U:U \ DS:inicmp_recs:GAUGE:600:U:U \ DS:outicmp_recs:GAUGE:600:U:U \ DS:inicmp_flows:GAUGE:600:U:U \
DS:outicmp_flows:GAUGE:600:U:U \ DS:inicmp_pkts:GAUGE:600:U:U \ DS:outicmp_pkts:GAUGE:600:U:U \ DS:inicmp_bytes:GAUGE:600:U:U \ DS:outicmp_bytes:GAUGE:600:U:U \ DS:ingre_recs:GAUGE:600:U:U \ DS:outgre_recs:GAUGE:600:U:U \ DS:ingre_flows:GAUGE:600:U:U \ DS:outgre_flows:GAUGE:600:U:U \ DS:ingre_pkts:GAUGE:600:U:U \ DS:outgre_pkts:GAUGE:600:U:U \ DS:ingre_bytes:GAUGE:600:U:U \ DS:outgre_bytes:GAUGE:600:U:U \ DS:inipv6_recs:GAUGE:600:U:U \ DS:outipv6_recs:GAUGE:600:U:U \ DS:inipv6_flows:GAUGE:600:U:U \ DS:outipv6_flows:GAUGE:600:U:U \ DS:inipv6_pkts:GAUGE:600:U:U \ DS:outipv6_pkts:GAUGE:600:U:U \ DS:inipv6_bytes:GAUGE:600:U:U \ DS:outipv6_bytes:GAUGE:600:U:U \ DS:inother_recs:GAUGE:600:U:U \ DS:outother_recs:GAUGE:600:U:U \ DS:inother_flows:GAUGE:600:U:U \ DS:outother_flows:GAUGE:600:U:U \ DS:inother_pkts:GAUGE:600:U:U \ DS:outother_pkts:GAUGE:600:U:U \ DS:inother_bytes:GAUGE:600:U:U \ DS:outother_bytes:GAUGE:600:U:U \ RRA:AVERAGE:0.5:1:288 \ RRA:AVERAGE:0.5:36:168 \
RRA:AVERAGE:0.5:144:365  

Connie Logg - Network Analyst 
Stanford Linear Accelerator Center 
2575 Sand Hill Road, Menlo Park, CA 94025
650-926-2879, cal at slac.stanford.edu
"If is the middle word in life, but happiness is found along the way, not at the end of the road."

-----Original Message-----
From: Boulytchev, Vasiliy [mailto:vboulytchev at coinfotech.com] 
Sent: Monday, September 22, 2003 2:46 PM
To: Alex van den Bogaerdt
Cc: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: total data querry.

Alex and all,
	So what you are saying is that you can not get "raw" figures out, just averages over a specific time.  I am more comfortable with raw figures, so those can be showed to my customer.  Is there any way to pull "raw" figures?

THANKS!!!!!!!

Vasiliy Boulytchev
Colorado Information Technologies, Inc. http://www.coinfotech.com

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch [mailto:rrd-users-bounce at list.ee.ethz.ch]On Behalf Of Alex van den Bogaerdt
Sent: Monday, September 22, 2003 3:35 PM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: total data querry.

On Mon, Sep 22, 2003 at 03:25:46PM -0600, Boulytchev, Vasiliy wrote:
> Ladies and Gents,
> 	I have a rrd database file I need to querry, and get back the TOTAL 
> amount of bytes transferred in/out, not averages.  Can you point me in 
> the right direction?

You have bytes per second -->  b/s
You know the amount of seconds -->  s

If you multiply those, you get:   (b/s) * s == b

Hence you can calculate the total.

HTH
Alex
-- 
http://www.googlism.com/index.htm?ism=alex+van+den+bogaerdt&type=1

--
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

--
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