[rrd-users] Re: Integrating Oracle with RRDTOOL

[Kempf, Reed]

I agree with Thomas on his points.  The only thing I would have to add
is that if you have many data sources in a temporary RRD or tons of rows
in your oracle DB, then you may have some performance impacts when
creating this on the fly.  

I chose to keep data in both because I do custom reporting off the
oracle db and display trend graphs from the RRD databases.  My oracle DB
has over 150 million rows in it and to pull that info out and create an
RRD on the fly and then query from that would take my server down no
matter how good my summary tables are set up since I need data for
daily, weekly, monthly and yearly time periods.

I guess it depends on how much data you have and the frequency you need
it.

HTH

ReedK

 

-----Original Message-----
From: Thomas Erskine [mailto:thomas.erskine at sympatico.ca] 
Sent: Thursday, July 03, 2003 7:28 AM
To: Lozovsky, Daniel; rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: Integrating Oracle with RRDTOOL


At 23:49 2003-07-02, Lozovsky, Daniel wrote:
 >Thanks Reed for your reply.
 >Let me clerify what I am asking.  I am trying to query the oracle
database  >on the fly and create graphs based on the selected data using
rrdtool.  I am  >trying to find out how to setup rrdtool to accomplish
this task.  I do not  >want to keep redundant data in rrdtool but point
the tool to generate graphs  >directly from the data in the Oracle
database.  >  >Is this possible? If so, how?

No.  You would have to create a temporary RRD, populate it with the 
information of interest and generate the graph off that rrd.  It can be 
done on the fly; I've done it.  You really want to make sure you clean
up 
those temp rrds, or you can run out of disk space really quickly with 
significant data sets.

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

Thomas Erskine <thomas.erskine at sympatico.ca> +1.613.591.8490 


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