[rrd-users] Re: Faster tool to generate graphs using RRD file s

[Saravia, Jovanny - (Col)]

I understand the point, but my question is which tool could be faster in
order to graph a rrd file. Or maybe if is better just using rrdgraph or
something like this. The query is working fine, but the problem is that the
apache server is saturated.

I could modify the mrtg-rrd.cgi script or maybe ask in the list associated.
But my question here is if someone knows a better grapher than mrtg-rrd.cgi.
Or someone that have handled a similar situation when the web server have a
lot of clients.

Right now I am using 3 servers with Apache in a round robin configuration in
the DNS like a workaround. But I would like to see another kind of solution.
Of courser that could be better than this one.

I am guessing that using php could be better, I am starting to search in
internet. But will be great for me if someone had solved this issued using a
tool or maybe an own solution.

-- Jovanny Saravia

-----Original Message-----
From: Alex van den Bogaerdt [mailto:alex at ergens.op.het.net]
Sent: Lunes, 10 de Noviembre de 2003 04:55 p.m.
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: Faster tool to generate graphs using RRD files


On Mon, Nov 10, 2003 at 04:23:14PM -0500, Saravia, Jovanny - (Col) wrote:

> I am using mrtg-rrd.cgi to graph these rrd files. But due to the high
volume
> of request, the client experience a lot of time while the graph is being
> generated. So, I am trying to change my frontend. I would like to hear of
> the people in this list, which tool I could check in order to generate in
a
> faster way these graphs request from RRD files.

Make sure the query matches the database.

If you store data similar to what MRTG does, make sure the clients
will only query for data in the same resolution.

For instance: if you are storing 600 rows of data, each row being
300 seconds apart, make sure:

1: both the begin time and the end time are a whole number times 300
2: are within the stored range

Likewise for the other RRAs.

Also,
   "--end 1068494400" "--start end-1day"
may be much faster than
   "--end 1068494100" "--start end-1day"

This example may not show it; it surely makes a big difference
when rrdtool can choose between both the 5-minute averages and
the 30-minute averages and need to produce an image that shows
30 minute per pixel (200 hours on a 400-pixel wide image).

It's hard to tune a system when one doesn't know the details,
hopefully you understand what I ment to say.

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