how to clear out a LARGE spike that screws up the graph

[rtparies]

Hello,
I have got a really large spike that screws up the display in the graph for that device. How can i reset it ?

Thanks

[BSOD2600]

Use removespikes here: http://people.ee.ethz.ch/~oetiker/webto ... b/contrib/

[rtparies]

Sorry, this may be obvious, but i am not sure if i understand the readme.
I want to make sure i do not remove the spikes that i am really interested

Where: number is the % limit of spikes to chop (default: 0.6)
and name_of_database ir the rrd file to be treated.

this i am not sure what it means
The graph i have , the normal max is 6 -7 M and the spike is over 60M

No i do have some spike on other graphs up to 10M

So if some one can please explain.
Thanks

[BSOD2600]

For example:

perl removespikes.pl -l 1 webstar_dpx2100_cable_modem_docsis_t3_1.rrd

This would remove all spikes within 1% of the datapoints in the rrd file. If 1% does not fix them, then continue to up the number until it does.

[rtparies]

it worked , thanks

[skatter]

I get this error..

# ./removespikes.pl sdhqir0802_traffic_in_4381.rrd
<<output ommitted>>
Chopping peak at <!-- 2004-11-24 16:00:00 PST / 1101340800 -->
Chopping peak at <!-- 2004-11-26 16:00:00 PST / 1101513600 -->
./removespikes.pl: Unable to execute the rrdtool restore on sdhqir0802_traffic_in_4381.rrd - Illegal seek -
#

[vulturul]

there might seem to be a problem
after i use the removespikes.pl i get no more data into that rrd, traffic showing "nan" any date/time AFTER removing the spike

any idea?

[irfandp]

Same with me too, all in .rrd files become NaN.

[thewall]

I have this error, anyone knows what's wrong??

Code: Select all

root@phoenix:/usr/local/cacti/rra# /usr/local/cacti/removespikes/removespikes.pl 1 pcomamesp_scaetano_traffic_in_3259.rrd
sh: rrdtool: command not found
No peaks found.!
root@phoenix:/usr/local/cacti/rra#

tks

[TheWitness]

If you are using rrdtool 1.2, there is a bug in 1.2.11 that causes versioning problems associated with Import/Export type functions. It will be corrected in 1.2.12.

Larry

[thewall]

Hi,

Is this RRDtool 1.2.12 available for download??

Tks

[BSOD2600]

The beta is floating around out there, yes . You'll have to ask around for it's compiler to provide it to the masses.

[eddievenus]

Is there a way to do this, only instead of using a percentage, using an actual value? Say 10mb on a traffic graph? So I have a graph where the upper vaule should be 10 mb/s but I have spikes up to 600mb/s. I want to essentially remove all spikes over 10mb/s. I want to do the same thing as the percentage version does, only I want it to work off real numbers, not percentages.

I am not a programmer, so I picked up a book on perl and some on PHP in hopes that I could fumble my way through this. But as of yet I can make the script work. I know I am just screwing things up in my scripts, but I feel it is important to try.

In the mean time, I feel that I could get more out of it if I had a working copy that did what I was looking for. 2 reasons there, first I am better at reading the code and determining what the differences do than trying to find what needs to be changed. And second because every one else would benefit for a coold script that could do this.

Lastly I wanted to learn some PHP in hopes of doing it all in PHP, then also I wanted to add this into Cacti, as a plugin so that there was a web GUI I could go into, select the rrd file, select the max level of the graph and maybe even select a time range or the different rras in the rrd. And finally tune the file to that size to hopefully prevent this from happening more. (however I have my doubts that this actually works, as I have several files tuned to 1.5mb/s that get spikes up to 600mb/s)

This way it may even be added right to the graph page, so while looking at a graph, if you notice a spike you could simply click on an icon which would automatically load the rrd you are viewing, and then you just select a max value, click go and away it goes.

I know I will never acutally get to a point where I can do this, I have a list of things I want to learn that is as long as my arm. Learning perl and PHP are not near the top of the list so they may never actually get done.

This brings me to the actual question here. Can someone write this function into an addon or better yet a plugin to Cacti? I would even offer to pay for the time, assuming that this required a pro. If I had to pay, I would of course give the code back to the forum here for everyone to use. And of course make sure the coder got all the credit.

EddieVenus

[gandalf]

I'd like to recomment omitting the spikes. Define a MAX value at the Data Source level in the Data Template. Readings will be set to NaN during rrdtool update. To do this for existing rrd's, you'll have to use rrdtool tune <file> --maximum <ds>:<value>
Reinhard

[eddievenus]

lvm

Thank you. I do this to all new graphs I make. I have tuned all the graphs I have already, for the most part. It takes a while to find the rrd, the max, the rra and ds names, etc. I know I missed some, since I keep getting spikes. I am not sure how well that worked either, as some graphs that I have clearly changed the max values from within Cacti just after creation, now have spikes.

I appreciate the advice, but it is only part of the solution, and it is the part I already had. I am looking for the other half, where when I find spikes I can eliminate them, and tune the rrd at the same time.