Request: 95th percentile calculation in RRD

[bardelot]

Simple patch to include the feature, no configuration or anything like that. Use and modify as you wish.

rrdcolors.inc.txt
status_rrd_graph_img.txt

[databeestje]

Cool, I'll see if I can get this worked in.

[clarknova]

Cool. Thank you. I can't wait to try it.

[bardelot]

fixed the SI magnitude. %sb/s instead of %Sb/s in both GPRINT lines.

[databeestje]

Code committed to the git repo. It should appear in snapshots half a day from now, please test.

[podilarius]

Thank you for this. It looks really good. I have to revert back to an older build and I will miss the functionality.

Good work.

Podilarius

[clarknova]

I finally had a chance to update and try this out. Beautiful. Thank you both and anyone else who contributed to having this included.

[clarknova]

One minor problem, it appears the "out" line for 95th %ile is drawn on the wrong side of 0 on the x axis.

[databeestje]

oops

[geeknik]

I'm pretty sure this commit broke my RRD traffic graphs. Any way to fix this w/o deleting all of my data history?

http://forum.pfsense.org/index.php/topic,34715.0.html

[databeestje]

the color is missing for the theme, nothing to do with the data.

[Bill48105]

@geeknik:

I'm pretty sure this commit broke my RRD traffic graphs. Any way to fix this w/o deleting all of my data history?

http://forum.pfsense.org/index.php/topic,34715.0.html

Howdy,
Yeah I see the same thing when I choose traffic. Logs show:

php: /status_rrd_graph_img.php: Failed to create graph with error code 1, the error is: ERROR: Unknown function string '95,PERCENT,-1,*' in VDEF 'opt1-out_bits_95'/usr/bin/nice -n20 /usr/local/bin/rrdtool graph /tmp/opt1-traffic.rrd-4year.png --start 1175097181 --end 1301586781 --vertical-label "bits/sec" --color SHADEA#eeeeee --color SHADEB#eeeeee --title "`hostname` - TCWIRELESS :: Traffic - 4 years - 1 day average" --height 200 --width 620 DEF:opt1-in_bytes_pass=/var/db/rrd/opt1-traffic.rrd:inpass:AVERAGE DEF:opt1-out_bytes_pass=/var/db/rrd/opt1-traffic.rrd:outpass:AVERAGE DEF:opt1-in_bytes_block=/var/db/rrd/opt1-traffic.rrd:inblock:AVERAGE DEF:opt1-out_bytes_block=/var/db/rrd/opt1-traffic.rrd:outblock:AVERAGE CDEF:"opt1-in_bits_pass=opt1-in_bytes_pass,8,*" CDEF:"opt1-out_bits_pass=opt1-out_bytes_pass,8,*" CDEF:"opt1-in_bits_block=opt1-in_bytes_block,8,*" CDEF:"opt1-out_bits_block=opt1-out_bytes_block,8,*" CDEF:"opt1-in_bytes=opt1-in_bytes_pass,opt1-in_bytes_block,+" CDEF:"opt1-out_byte

Seems it doesn't like something about the option string. I'm not familiar enough with RRD to know for sure why or how to fix it.
As a quick fix I edited /usr/local/www/status_rrd_graph_img.php to make 'out' the same as 'in' (removing ,$multiplier,*) to end up with:

        $graphcmd .= "VDEF:\"$curif-in_bits_95=$curif-in_bits,95,PERCENT\" ";
        $graphcmd .= "VDEF:\"$curif-out_bits_95=$curif-out_bits,95,PERCENT\" ";

I'm guessing that will break the scaling of the 95th line but hey it works for now at least. :D
Bill
Ps. Great work to everyone involved working on pfsense! In process of migrating from m0n0wall (need multiwan mostly) and aside from a few issues, (such as this graphing thing and a PPPoE/interface issue I need to report when I get time), it has been working great.

[clarknova]

Ok, the out line is on the correct (bottom) side of the graph now, but it looks like a 5th percentile calculation instead of a 95th.

[dzeanah]

I just want to chime in and say that I really appreciate the addition of this feature.

Really nice for those of us in datacenters who get billed at the 95% rate.