[smokeping-users] Question about Database Config.

[Darren Murphy]

Somewhat tangentially related (and apologies in advance for the
shameless personal plug)...

I once found the need to do a mass resize of my RRD files.
This was complicated somewhat by the fact that my existing RRD's were
of varying sizes (due to an earlier resizing exercise).

So I knocked up a script to handle this, which did the job rather well.

A copy is at http://perlmonks.org/?node_id=874274

cheers,
Darren

On 8 December 2011 08:40, Gregory Sloop <gregs at sloop.net> wrote:
> Provided I understand these configs right, you've got:
>
> BC> AVERAGE  0.5   1  5040  #1008
> 5040 minutes of 1 min resolution data. (i.e. 84 hours or 3.5 days)
>
> BC> AVERAGE  0.5  12  21600 #4320
> BC>     MIN  0.5  12  21600 #4320
> BC>     MAX  0.5  12  21600 #4320
>
> Then the next set is 12 minute steps, and you've got 180 days of 12min
> data.
>
> [These compress the prior 1 min steps by a factor or 1:12.
> Again, provided I understand correctly. This seems excessive - I'd
> probably keep 30 - 90 days of 12 min data. But I'm not sure what your
> goals are - perhaps that 12 minute data is more important than I
> realize. But I think I should catch most important stuff in 3 days,
> and after 30 days, the data's not terribly important for higher
> resolution needs.]
>
> BC> AVERAGE  0.5 144   3600 #720
> BC>     MAX  0.5 144   3600 #720
> BC>     MIN  0.5 144   3600 #720
> Then 360 days of 144 minute (~2.3 hr resolution) data.
>
> ---
> Here's what I do:
>
> I keep one minute data too, and I use
> BC> AVERAGE  0.5   1  4320  #3 days, 60 sec resolution
>
> BC> AVERAGE  0.5  10  4320 #30 days at 10 min resolution
> BC>     MIN  0.5  10  4320 #
> BC>     MAX  0.5  10  4320 #
> [90 days might be better, but I don't often wish for more than 30-60
> days]
>
> BC> AVERAGE  0.5 144   2400 #400 days at 2 hr resolution
> BC>     MAX  0.5 144   2400 #
> BC>     MIN  0.5 144   2400 #
>
> IIRC, this results in about 8.5MB rrd files for each monitored device.
> This seems like a pretty reasonable file size for me.
>
> I just calculated it, and this appears to use roughly 0.77 KB per row of
> data. [~770KB per 1000 RRD rows or ~1300 rows/MB.]
>
> HTH
>
> -Greg
>
>
>
>
> BC> Hi All,
>
> BC> Thank you for amazing piece of software!
>
> BC> I had to very aggressively test packet loss to some servers so I
> BC> made the following changes to the Database config.
>
> BC> *** Database ***
>
> BC> step     = 60
> BC> pings    = 20
>
> BC> # consfn mrhb steps total
>
>
> BC> AVERAGE  0.5  12  21600 #4320
> BC>     MIN  0.5  12  21600 #4320
> BC>     MAX  0.5  12  21600 #4320
> BC> AVERAGE  0.5 144   3600 #720
> BC>     MAX  0.5 144   3600 #720
> BC>     MIN  0.5 144   3600 #720
>
>
> BC> Basically I multiplied the steps in the config below by 5 as I
> BC> was reducing the step period by a factor of 5.
>
> BC> Should I do this or should I just leave the bits below at their default values?
>
> BC> Thanks in advance.
> BC> Brian
> BC> _______________________________________________
> BC> smokeping-users mailing list
> BC> smokeping-users at lists.oetiker.ch
> BC> https://lists.oetiker.ch/cgi-bin/listinfo/smokeping-users
>
> --
> Gregory Sloop, Principal: Sloop Network & Computer Consulting
> Voice: 503.251.0452 x82
> EMail: gregs at sloop.net
> http://www.sloop.net
> ---
>
> _______________________________________________
> smokeping-users mailing list
> smokeping-users at lists.oetiker.ch
> https://lists.oetiker.ch/cgi-bin/listinfo/smokeping-users