Biased graph - shifted average periods

View: New views
2 Messages — Rating Filter:   Alert me  

Biased graph - shifted average periods

by Igor I. Shulz :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Help pls
My brain is boiling out.

I've created rrd-file to accumulate data on a per-hour-basis (--step 3600). Thre are two AVERAGE sets:
RRA:AVERAGE:0.5:4:62
RRA:AVERAGE:0.5:24:45

--start set on the edge of a day - 1242248400

But 4-hour averages are not set on even 4-hour ranges (00:00, 04:00, 08:00 etc), but are set on ranges 03:00, 07:00, 11:00. This is part of dump of my rrd-file:

                <cf> AVERAGE </cf>
                <pdp_per_row> 4 </pdp_per_row> <!-- 14400 seconds -->
                <xff> 5.0000000000e-01 </xff>
...
                <database>
                        <!-- 2009-05-03 19:00:00 EEST / 1241366400 --> <row><v> NaN .........
                        <!-- 2009-05-03 23:00:00 EEST / 1241380800 --> <row><v> NaN .........
                        <!-- 2009-05-04 03:00:00 EEST / 1241395200 --> <row><v> NaN .........
                        <!-- 2009-05-04 07:00:00 EEST / 1241409600 --> <row><v> NaN .........

Daily average (by 24 points) is also shifted - periods are not 00:00-23:59, but 03:00-02:59:

                <cf> AVERAGE </cf>
                <pdp_per_row> 24 </pdp_per_row> <!-- 86400 seconds -->
                <xff> 5.0000000000e-01 </xff>
............
                <database>
                        <!-- 2009-03-30 03:00:00 EEST / 1238371200 --> <row><v> NaN ....
                        <!-- 2009-03-31 03:00:00 EEST / 1238457600 --> <row><v> NaN ....
                        <!-- 2009-04-01 03:00:00 EEST / 1238544000 --> <row><v> NaN ....

As result I have ugly shifted line on a graphs.

Is it possible to set average periods on the more reasonable points?
00:00, 04:00 ... for 4-hour average
and
00:00, 00:00 ... for daily average

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

Re: Biased graph - shifted average periods

by Simon Hobson-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Igor I.  Shulz wrote:

>I've created rrd-file to accumulate data on a per-hour-basis (--step
>3600). Thre are two AVERAGE sets:
>RRA:AVERAGE:0.5:4:62
>RRA:AVERAGE:0.5:24:45
>
>--start set on the edge of a day - 1242248400
>
>But 4-hour averages are not set on even 4-hour ranges (00:00, 04:00,
>08:00 etc), but are set on ranges 03:00, 07:00, 11:00.
...
>Is it possible to set average periods on the more reasonable points?
>00:00, 04:00 ... for 4-hour average
>and
>00:00, 00:00 ... for daily average

What is the local timezone on the server ? I'm guessing that since
your email says +4, your server might be set to +3 and this would
account for your problem.

RRD uses UTC, and all steps are aligned on Unix epoch (ie "start of
time" at midnight 1st Jan 1970). Hourly/daily etc steps will always
be aligned on midnight UTC.

It's been discussed regularly in the past, but I can't recall what
teh answer was.

--
Simon Hobson

Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed
author Gladys Hobson. Novels - poetry - short stories - ideal as
Christmas stocking fillers. Some available as e-books.

_______________________________________________
rrd-users mailing list
rrd-users@...
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users