Customized rras

[kyosanim]

Hi community,

i created my own customized rras.
can someone please check if my calculating is right or wrong?

Hourly 5 Minute AVG: Step 1 Rows 100 Timespan 14400
Daily 5 Minute AVG: Step 1 Rows 600 Timespan 86400
Weekly 5 Minute AVG:Step 6 Rows 11520 Timespan 604800
Monthly 2 Hour AVG: Step 24 Rows 775 Timespan 2678400
Yearly 12 Hour AVG: Step 114 Rows 1594 Timespan 33053184

my calculation is based on gandalfs example in the cacti-doku.

thanks

[noflies]

I calcuated the same for all except your HOURLY. Timespan on hourly should be 3600 not 14400.

This assumes there are 31 24-hour days in each month and 382.56 24-hour days in each year. Why the year RRA was setup like this is a mystery to me, but perhaps someone else can shed light on this?? Bueller? Bueller?

BTW: I'm not sure why you'd have so many rows for weekly and so relatively few for other RRAs. If I'm not mistaken the defaults are documented in the cacti manual.

[kyosanim]

thanks for your reply...

now i know some of my calculating was totaly wrong
i red gandalfs post about "Howto define a very BIG rra without data loss".
and i think i know the trick, now.

Hourly 5 Minute AVG: Step 1 Rows 25 Timespan 3600
Daily 5 Minute AVG: Step 1 Rows 600 Timespan 86400
Weekly 5 Minute AVG:Step 1 Rows 4800 Timespan 604800
Monthly 30 Min AVG: Step 6 Rows 3400 Timespan 2678400
6 Month 2Hour AVG: Step 24 Rows 5100 Timespan 16526592
Yearly 12 Hour AVG: Step 144 Rows 1700 Timespan 33053184

can someone confirm that?
i still don't know why gandalf is calculation a year with 400 days.

[gandalf]

i still don't know why gandalf is calculation a year with 400 days.

Well, it's just about rounding up.
Reinhard

[TFC]

I wanna store 3 month data with 5 min average (just for zoom not on graph).
Can anybody share me rra values?

[noflies]

I wanna store 3 month data with 5 min average (just for zoom not on graph).
Can anybody share me rra values?

Is this what you want?

Daily (5 min Avg), store 91 days
xff: 0.5
Steps: 1
Rows: 26208
Timespan: 86400

[TFC]

The Timespan value is correct?
Actually what is Timespan
İf I am not mistaken timespan defines of graph's horizontal dimension. Right?
So that 86400= 24 hour.
And, what is row actually. Is ıt defines database size?

[noflies]

The Timespan value is correct?
Actually what is Timespan
İf I am not mistaken timespan defines of graph's horizontal dimension. Right?
So that 86400= 24 hour.
And, what is row actually. Is ıt defines database size?

Yes, the TIMESPAN is the "width" of the graph in seconds.
Number of ROW affects the RRD filesize.
ROWS times STEP interval equals total archive seconds.
NOTE step *interval*...to be more precise for the example above)
STEPS = 1
step interval = 300 (seconds)
ROWS = 26208
(1 * 300 * 26,208) = 7,862,400 seconds = 91 days

[TFC]

perfect answer.
Simple and understandable