[smokeping-users] Question about Database Config.

[Gregory Sloop]

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
---