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:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 5:55 PM To: Alex van den Bogaerdt Cc: rrd-users@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, [EMAIL PROTECTED] "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:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 2:46 PM To: Alex van den Bogaerdt Cc: rrd-users@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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alex van den Bogaerdt Sent: Monday, September 22, 2003 3:35 PM To: rrd-users@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:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi