accidental max value shrink graph

[jehan.procaccia]

hello,

after rebooting a service (tomcat connection counter is accidentally very high), or because a network latency I have my hping graph climbing temporarely to thousand of ms instead of usual 10 to 50 ms. In consequence, that accidental very high value complety hide valuable data graph before and after the "pic" .
I supose I have to play with max value, or autoscale, but none works for me right now . How can I tell cacti or rrd file to forget values up to a certain level . For exemple in my hping program to forget value upper than 500 ?

here is an exemple, and png attach

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="sonde - sonde.int-evry.fr - Hping graph" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
--slope-mode \
....

[gandalf]

Please use killspike.pl from Tobi Oetikers rrdtool site, see contrib section
Reinhard

[bort13]

http://oss.oetiker.ch/rrdtool/pub/contrib/

I recently used removespikes.pl and it worked like a charm.

[jehan.procaccia]

I suppose it will work indeed, but it seems a little bit "destructive" as it removes information in the rra. I was expecting something smoother, that would prevent to graph extreme high values but still keeping them in the RRA files. In the graph template I use, I can see "Upper Limit" and "scale / autoscale" what are these parameters use for ?
I was expecting that setting "Upper limit" to 800 would prevent graphs to go upper than 800, but it still goes up to 3000 sometimes .
And for rra datas, I set in the corresponding data source template a "maximum value" to 800 , how comes I finnaly get values up to 3000 !?

usually I get values between 10 and 100 (its ping round trip time)
[root@supervis /usr/share/cacti/rra]
$ rrdtool fetch sonde_min_825.rrd AVERAGE
max loss min avg

1214465100: 4.1912000000e+01 0.0000000000e+00 4.0400000000e+01 4.1241333333e+01
1214465400: 4.1430000000e+01 0.0000000000e+00 4.0430000000e+01 4.0945000000e+01

and accidentally I get these:
1214544000: 5.2932200000e+02 8.4666666667e+01 6.3940000000e+00 2.4054933333e+02
1214544300: 2.8767500000e+03 1.6666666667e+01 3.4750000000e+01 1.3073333333e+03

again, how can I keep these values in rra, but only graph them up to a certain Upper limit !?

Thanks.

[gandalf]

Use rigid mode to make upper limits take effect even if data is higher than that
Reinhard

[jehan.procaccia]

Great, that was it, setting "rigid" and removing "auto-scale" made it work, thanks .
in the sample below I set uper limit to 200, and now the graph is much more relevant