[rrd-developers] Re: pulling data from MySQL and graphing using R

Alex van den Bogaerdt alex at ergens.op.HET.NET
Mon Apr 8 14:13:06 MEST 2002


"Sheahan, John (PCLN-NW)" wrote:
> 
> HAHA!
> 
> Thanks for giving me a little laughter this morning Alex!
> I will follow your direction but it might take a couple of weeks to sort
> through it all. I will however, follow up and get back to you with my
> results. Thanks for the help!

Oh but I really think it shouldn't be too hard to do.  As long as
you keep your database in a format suitable for rrdtool it probably
is going to be (relatively) easy.  If not, you will have to do
normalizing and in that case it is better to just input the data as
you would normally do.

For starters:
- if you only have one database, it is always going to be the best match
- rrdtool asks for <start> to <end>, at resolution <r>.  You will have
  to return data and tell rrdtool what the real values became
- don't forget that an interval in rrdtool is defined by its *end*time

To me it looks as easy as implementing a new rrd_fetch_fn() that uses
a database lookup from SQL.  There will (of course) be some problems
to solve but that's half the fun!

cheers,
-- 
   __________________________________________________________________
 / alex at slot.hollandcasino.nl                  alex at ergens.op.het.net \
| work                                                         private |
| My employer is capable of speaking therefore I speak only for myself |
+----------------------------------------------------------------------+
| Technical questions sent directly to me will be nuked. Use the list. | 
+----------------------------------------------------------------------+
| http://faq.mrtg.org/                                                 |
| http://rrdtool.eu.org  --> tutorial                                  |
+----------------------------------------------------------------------+

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



More information about the rrd-developers mailing list