Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Request: 95th percentile calculation in RRD

    Scheduled Pinned Locked Moved 2.0-RC Snapshot Feedback and Problems - RETIRED
    22 Posts 11 Posters 9.5k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      joebarnhart
      last edited by

      clarknova is right.  The billing model is imposed by the seller of bandwidth here, it's not a choice we can elect to take or not.  All of our "wholesale" transport is priced this way.  I have only one question, tho… Wouldn't we need to input the "window" over which the 95th percentile is calculated?  In order to match our billing?

      1 Reply Last reply Reply Quote 0
      • C
        cmb
        last edited by

        there is a feature request open on this.
        http://redmine.pfsense.org/issues/796

        @joebarnhart:

        I have only one question, tho… Wouldn't we need to input the "window" over which the 95th percentile is calculated?  In order to match our billing?

        Yes, though I believe custom periods with RRD can accomplish that

        1 Reply Last reply Reply Quote 0
        • B
          bardelot
          last edited by

          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

          1 Reply Last reply Reply Quote 0
          • D
            databeestje
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • C
              clarknova
              last edited by

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

              db

              1 Reply Last reply Reply Quote 0
              • B
                bardelot
                last edited by

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

                1 Reply Last reply Reply Quote 0
                • D
                  databeestje
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • P
                    podilarius
                    last edited by

                    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

                    1 Reply Last reply Reply Quote 0
                    • C
                      clarknova
                      last edited by

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

                      db

                      1 Reply Last reply Reply Quote 0
                      • C
                        clarknova
                        last edited by

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

                        95th.png
                        95th.png_thumb

                        db

                        1 Reply Last reply Reply Quote 0
                        • D
                          databeestje
                          last edited by

                          oops

                          1 Reply Last reply Reply Quote 0
                          • G
                            geeknik
                            last edited by

                            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

                            status_rrd_graph_img.php.png
                            status_rrd_graph_img.php.png_thumb

                            1 Reply Last reply Reply Quote 0
                            • D
                              databeestje
                              last edited by

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

                              1 Reply Last reply Reply Quote 0
                              • B
                                Bill48105
                                last edited by

                                @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.

                                1 Reply Last reply Reply Quote 0
                                • C
                                  clarknova
                                  last edited by

                                  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.

                                  Screenshot.png
                                  Screenshot.png_thumb

                                  db

                                  1 Reply Last reply Reply Quote 0
                                  • D
                                    dzeanah
                                    last edited by

                                    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.

                                    1 Reply Last reply Reply Quote 0
                                    • First post
                                      Last post
                                    Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.