[rrd-users] Re: Get not a right graphic.

Fri May 5 13:50:55 MEST 2006

On Fri, May 05, 2006 at 01:28:06PM +0200, Greta wrote:
> Hello,
> I want to create a graphic with rrdtool.exe but it doesn't work like I want
> to.
> 
> I have on MySQL a table with values measured every 5 minutes. For the test
> al the values are 50. When I make a graphic for one day (00:00 to 23:55)

A day starts at 00:00 and ends at 00:00.

> like below I don't get a right graphic. (See image).
> 
> rrdtool.exe create --start 1146096000 file.rrd DS:in:GAUGE:300:0:100
> RRA:AVERAGE:0.5:1:300

All timeslots upto and including the one ENDING at 1146096000 are
skipped.  The database starts with the interval STARTING at 1146096000.

This is Thu Apr 27 02:00:00 2006 local time for European summer time.

You are using GAUGE so this should work.  Be aware when using COUNTER
you would not be able to get a rate for the first interval.

> rrdtool.exe graph praph.png --start 1146096000 --end
> 1146182100 --width=400 --imgformat=PNG --vertical-label="Test"
> DEF:in=file.rrd:in:AVERAGE AREA:in#00CC00

1146096000 means Thu Apr 27 02:00:00 2006 european time
1146182100 means Fri Apr 28 01:55:00 2006 european time

You are asking for 23 hours and 55 minutes, starting at 02:00 local time.

> So you can see isn't the time correct from 00:00 to 23:55. On the graphic it
> runs form 00:00 to 03:00 the next day.

No, the graph you sent runs from 02:00 to 01:55 the next day.  Exactly what
you asked for but not what you expected.  Count the vertical lines.  Each
line is "on the hour" and there are four lines left of "06:00".

> Can anyone tell me what I doing wrong?

Error 1: you forgot to think about time zones
Error 2: you think rrdtool data is at points in time.  It is not, it is
data over a range of time

-- 
Alex van den Bogaerdt
http://www.vandenbogaerdt.nl/rrdtool/

--
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://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi