<html><head><title>Re: [smokeping-users] Smokeping only keeping ~8 weeks of data</title>
<meta charset="utf-8" http-equiv="X-UA-Compatible" content="IE=9; IE=8; IE=7; IE=EDGE" />
</head>
<body>
<span style=" font-family:'Courier New'; font-size: 9pt;">*** Database ***<br>
step = 60<br>
pings = 60<br>
<br>
# consfn mrhb steps total<br>
AVERAGE 0.5 1 1008<br>
AVERAGE 0.5 12 4320<br>
MIN 0.5 12 4320<br>
MAX 0.5 12 4320<br>
AVERAGE 0.5 144 720<br>
MAX 0.5 144 720<br>
MIN 0.5 144 720<br>
<br>
---<br>
Your database section isn't configured to save data any older than 72 days.<br>
<br>
1008 minutes of full res data [Just under 17 hours - that's kind of an odd number, but whatever.]<br>
36 days of 12m data<br>
72 days of 144m data<br>
<br>
If you want to have more data, you're going to have to change the database section to keep more rows.<br>
<br>
Your step is 60s - so 1008 samples of 60s data.<br>
Then 4320 rows averaging 12m of data. (4320*12=Total minutes of data. That comes out to 36 days worth.]<br>
Then 720 rows of 144m averaged data. [720*144=Total minutes of data. That comes out to 72 days.]<br>
<br>
I'll leave it as an exercise to figure out how many rows you'll need to keep of each sample type to have history long enough to cover the time-frame you want.<br>
<br>
But, for example. the 144m samples - if you want 2 years of data [365*2] - you'd need<br>
365 days * 2 = 2 years or 730 days<br>
730 days * 24 hours = 17520 hours.<br>
17520h * 60minutes = 1,051,200 minutes in 2 years.<br>
Now divide those minutes by 144, and that's how many rows you'll need, if you want two years of 144m averaged data.<br>
(i.e. 7300)<br>
***That all assumes you continue to use 60s step times. If you change the step, you'll have to recalculate given the new step size.<br>
If you change your step, you'll either have to re-sample your data, or more likely, dump the old data and let it rebuild the RRD files again with the proper structure and lose the historical data.<br>
<br>
HTH<br>
<br>
-Greg<br>
<br>
<br>
<br>
</span><table style =" border-collapse: collapse;" cellpadding = 1 cellSpacing = 2>
<tr>
<td width=3 bgcolor= #0000ff><br>
</td>
<td ><span style=" font-family:'calibri'; font-size: 12pt;">Hi All,<br>
<br>
I am having an issue with smokeping not displaying any graphs older than ~8 weeks. I have it configured to display graphical data for 3hrs, 30hrs, 10days and 400days.<br>
So far, it does not show anything before the 7th week(in February 2020).<br>
<br>
Is there anything I have configured wrongly here?<br>
<br>
<br>
<br>
<span style=" font-family:'courier new'; font-size: 9pt;">*** General ***<br>
<br>
owner = ######################################<br>
contact = ######################################<br>
#mailhost = my.mail.host<br>
#sendmail = /sbin/sendmail<br>
# NOTE: do not put the Image Cache below cgi-bin<br>
# since all files under cgi-bin will be executed ... this is not<br>
# good for images.<br>
imgcache = /opt/smokeping/cache<br>
imgurl = cache<br>
datadir = /opt/smokeping/data<br>
piddir = /opt/smokeping/var<br>
cgiurl = http://10.20.1.41/smokeping.fcgi<br>
smokemail = /opt/smokeping/etc/smokemail.dist<br>
tmail = /opt/smokeping/etc/tmail.dist<br>
# specify this to get syslog logging<br>
syslogfacility = local0<br>
# each probe is now run in its own process<br>
# disable this to revert to the old behaviour<br>
# concurrentprobes = no<br>
<br>
*** Alerts ***<br>
to = ######################################<br>
from = ######################################<br>
+someloss<br>
type = loss<br>
# in percent<br>
pattern = >0%,*12*,>0%,*12*,>0%<br>
comment = loss 3 times in a row<br>
<br>
<br>
+bigloss<br>
type = loss<br>
# in percent<br>
pattern = ==0%,==0%,==0%,==0%,>0%,>0%,>0%<br>
comment = suddenly there is packet loss<br>
<br>
+startloss<br>
type = loss<br>
# in percent<br>
pattern = ==S,>0%,>0%,>0%<br>
comment = loss at startup<br>
<br>
+rttdetect<br>
type = rtt<br>
# in milli seconds<br>
pattern = <10,<10,<10,<10,<10,<100,>100,>100,>100<br>
comment = routing messed up again ?<br>
<br>
+hostdown<br>
type = loss<br>
# in percent<br>
pattern = ==0%,==0%,==0%, ==U<br>
comment = no reply<br>
<br>
+lossdetect<br>
type = loss<br>
# in percent<br>
pattern = ==0%,==0%,==0%,==0%,>20%,>20%,>20%<br>
comment = suddenly there is packet loss<br>
<br>
<br>
*** Database ***<br>
<br>
step = 60<br>
pings = 60<br>
<br>
# consfn mrhb steps total<br>
<br>
AVERAGE 0.5 1 1008<br>
AVERAGE 0.5 12 4320<br>
MIN 0.5 12 4320<br>
MAX 0.5 12 4320<br>
AVERAGE 0.5 144 720<br>
MAX 0.5 144 720<br>
MIN 0.5 144 720<br>
<br>
*** Presentation ***<br>
<br>
template = /opt/smokeping/etc/basepage.html.dist<br>
<br>
+ charts<br>
<br>
menu = Charts<br>
title = The most interesting destinations<br>
<br>
++ stddev<br>
sorter = StdDev(entries=>4)<br>
title = Top Standard Deviation<br>
menu = Std Deviation<br>
format = Standard Deviation %f<br>
<br>
++ max<br>
sorter = Max(entries=>5)<br>
title = Top Max Roundtrip Time<br>
menu = by Max<br>
format = Max Roundtrip Time %f seconds<br>
<br>
++ loss<br>
sorter = Loss(entries=>5)<br>
title = Top Packet Loss<br>
menu = Loss<br>
format = Packets Lost %f<br>
<br>
++ median<br>
sorter = Median(entries=>5)<br>
title = Top Median Roundtrip Time<br>
menu = by Median<br>
format = Median RTT %f seconds<br>
<br>
+ overview<br>
<br>
width = 600<br>
height = 50<br>
range = 10h<br>
<br>
+ detail<br>
<br>
width = 600<br>
height = 200<br>
unison_tolerance = 2<br>
<br>
"Last 3 Hours" 3h<br>
"Last 30 Hours" 30h<br>
"Last 10 Days" 10d<br>
"Last 400 Days" 400d<br>
<br>
<span style=" font-family:'calibri'; font-size: 12pt;">#+ hierarchies<br>
#++ owner<br>
#title = Host Owner<br>
#++ location<br>
#title = Location<br>
<br>
*** Probes ***<br>
<br>
+ FPing<br>
<br>
binary = /usr/sbin/fping<br>
<br>
*** Slaves ***<br>
secrets=/opt/smokeping/etc/smokeping_secrets.dist<br>
+boomer<br>
display_name=boomer<br>
color=0000ff<br>
<br>
+slave2<br>
display_name=another<br>
color=00ff00<br>
<br>
*** Targets ***<br>
<br>
probe = FPing<br>
<br>
Many Thanks,<br>
Debo</td>
</tr>
</table>
<br>
</body></html>