<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hello,<div class=""><br class=""></div><div class="">We also face these issues at Interlan IX. From time to time we normalize the data using <a href="https://github.com/mhagander/rrdclean" class="">https://github.com/mhagander/rrdclean</a> . </div><div class=""><br class=""></div><div class="">The tool analyzes the values inside the RRD database and you can select a cutoff point. All values above the cutoff point are modified to the value specified.</div><div class=""><br class=""></div><div class="">Hth,<br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><table width="540.0" cellspacing="0" cellpadding="0" class="" style="width: 540px;"><tbody class=""><tr class=""><td colspan="2" valign="top" class="" style="width: 540px;"><div class="" style="margin: 0px; font-size: 10px; font-family: Verdana; color: rgb(53, 90, 120);"></div><div class="" style="margin: 0px; font-size: 10px; font-family: Verdana; color: rgb(53, 90, 120);"><b class="">--</b></div><div class="" style="margin: 0px; font-size: 10px; font-family: Verdana; color: rgb(53, 90, 120);"><b class="">Andrei DINU</b></div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;">Technical Manager</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;">Digital IT Consulting</div><div class="" style="margin: 0px; font-size: 12px; font-family: Verdana; color: rgb(153, 153, 153);">-----------------------------</div><table cellspacing="0" cellpadding="0" class=""><tbody class=""><tr class=""><td valign="middle" class="" style="width: 34px;"><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;">Mobile:</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;">Fax:</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;">Web:</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana; min-height: 11px;"><br class=""></div></td><td valign="middle" class="" style="width: 108px;"><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;"> +40 728 777 794</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana;"> +40 314 050 150</div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana; color: rgb(71, 135, 255);"><span class="" style="color: rgb(0, 0, 0);"> <a href="http://www.digitalit.ro/" class="">http://www.digitalit.ro</a></span></div><div class="" style="margin: 0px; font-size: 9px; font-family: Verdana; min-height: 11px;"><br class=""></div></td></tr></tbody></table></td></tr><tr class=""><td colspan="2" valign="top" class="" style="width: 540px;"><div class="" style="margin: 0px; font-size: 9px; font-family: Arial; color: rgb(153, 153, 153);">Privileged/Confidential information may be contained in this message. If you are not in the addresses indicated in this message or responsible for delivery of the message to such person you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail.</div></td></tr></tbody></table><div class=""><br class=""></div></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 28 Mar 2020, at 14:53, <<a href="mailto:remy.guenter@swissix.ch" class="">remy.guenter@swissix.ch</a>> <<a href="mailto:remy.guenter@swissix.ch" class="">remy.guenter@swissix.ch</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">We face the same problem on the historical data for month and year:<br class=""><br class=""><a href="https://ixpmanager.swissix.ch/statistics/ixp" class="">https://ixpmanager.swissix.ch/statistics/ixp</a><br class=""><br class="">To fix this we can not just simply change some text in a log file. For us<br class="">this would mean - in my view - to dump the rrd datafiles (our installation<br class="">does not write to log files), correct the values and then restore to rrd-db.<br class=""><br class=""><br class="">That would require a script to find the "wrong" entries in the dumped XML,<br class="">correct them (average of entry before/after) and write back the XML to be<br class="">reloaded.<br class=""><br class="">Is there a simpler procedure?<br class=""><br class="">Rémy<br class=""><br class="">-----Original Message-----<br class="">From: ixpmanager <ixpmanager-bounces@inex.ie> On Behalf Of Nick Hilliard<br class="">(INEX)<br class="">Sent: Saturday, 28 March 2020 1:40 pm<br class="">To: INEX IXP Manager Users Mailing List <ixpmanager@inex.ie><br class="">Subject: Re: [ixpmanager] Spikes on MRTG graphs<br class=""><br class="">Barry O'Donovan wrote on 28/03/2020 10:38:<br class=""><blockquote type="cite" class="">This is exactly as Martin suggests and also how we fix it too.<br class=""></blockquote><br class="">also, ixp manager puts in spike limits by counting up the total possible<br class="">bandwidth of each individual graph. E.g. the total possible bandwidth of<br class="">the ixp would be the sum of all the edge ports, etc. So there are checks in<br class="">there already, but even still MRTG manages to mess things up from time to<br class="">time.<br class=""><br class="">Nick<br class="">_______________________________________________<br class="">INEX IXP Manager mailing list<br class="">ixpmanager@inex.ie<br class="">Unsubscribe or change options here:<br class="">https://www.inex.ie/mailman/listinfo/ixpmanager<br class=""><br class="">_______________________________________________<br class="">INEX IXP Manager mailing list<br class="">ixpmanager@inex.ie<br class="">Unsubscribe or change options here: https://www.inex.ie/mailman/listinfo/ixpmanager<br class=""></div></div></blockquote></div><br class=""></div></body></html>