Adam/Tom,
Thank you for looking into this so deeply. I know your time is valuable.
These switch ports are just apartment internet users with home wifi routers. Being able to see how much each port has done since last port reset is good enough for what I need to do. The hogs will stand out. I only need to see this on one device at a time so I’m going to just duplicate that page and get it to sort on that value.
Justin
On Dec 13, 2014, at 10:04 PM, Adam Armstrong adama@memetic.org wrote:
That number is in the database to calculate rates. It's functionally useless unless you know when the counter was last reset.
It isn't exposed in the UI precisely because it's such a functionally useless number.
What /might/ be vaguely useful would be calculating an average traffic rate for the port by tracking the "last reset" time for the counter. But even then, this is only really useful if the port has *always* been active for the uptime of the switch. It would take literally weeks for a port flatlining 1GB to overtake a port which had been pushing 100mbit for a few months.
There are other possibilities, such as storing a series of values at various timepoints so we can "sort of" give a value like "xbps over the past 24 hours", but these get terribly inefficient and slow, especially considering that we're using MEMORY tables to hold this data, and pretty irritating things happen when those tables fill up.
I don't think exposing a value which is only comparable with other ports on the same device active for the same amount of time which haven't had their counters reset is particularly useful (and seems particularly confusing).
adam.
------ Original Message ------ From: "Justin Miller" <observium@dynstatic.net mailto:observium@dynstatic.net> To: "Observium Network Observation System" <observium@observium.org mailto:observium@observium.org> Sent: 12/12/2014 1:21:55 PM Subject: Re: [Observium] Sort ports based on total data usage
In the db observium.ports-state, there is ifInOctlets, ifInOctlets_delta, and ifInOctets_rate. It’s also there for ifOutOctlets, ifOutOctlets_delta, and ifOutOctets_rate. So the values I want are already in the database.
Furthermore, when the html/pages/devie/port.inc.php invokes includes/print-interface.inc.php to print each interface, $port contains those values.
Hacking it into the view
'<i class="icon-circle-arrow-down" style="',$port['bps_in_style'], '"></i> <span class="small" style="',$port['bps_in_style'], '">' , formatStorage($port['ifInOctets']) , '</span><br />', '<i class="icon-circle-arrow-up" style="',$port['bps_out_style'],'"></i> <span class="small" style="',$port['bps_out_style'],'">' , formatStorage($port['ifOutOctets']) , '</span><br />',Produces somewhat correct results which are good enough for what I need. I just need to sort it now. Maybe make a new page.
<Screenshot 2014-12-12 14.11.20.png>
On Dec 12, 2014, at 12:19 PM, Tom Laermans <tom.laermans@powersource.cx mailto:tom.laermans@powersource.cx> wrote:
Nope.
On 12/12/2014 06:11 PM, Justin Miller wrote:
Because it’s a round robin database and it has to sum the octlets for that given time, right?
Doesn’t the poller read how many packets have been send or received on every port anyways? ifOutOclets / ifInOclets ? Isn’t that a running total? Then to get the rate you take the difference between the current poll and the last poll and divide it by the time between polls?
There has to be an OID for this which would be easy to store at poll time, right?
Justin
On Dec 12, 2014, at 10:50 AM, Tom Laermans <tom.laermans@powersource.cx mailto:tom.laermans@powersource.cx> wrote:
It will take about 15 minutes to generate that page, then.
On 12/12/2014 04:14 PM, Justin Miller wrote:
This information is already in the RRD file is it not? Can’t you export the numerical value for the TOTAL from the graph for each port and then sort based on that?
It does not have to be 100% accurate, I’m not billing for it. I just need to see what the top 10 busiest ports are on a switch.
<Mail Attachment.png>
> On Dec 12, 2014, at 2:24 AM, Adam Armstrong <adama@memetic.org mailto:adama@memetic.org> wrote: > > Total in what time frame? Day, week, month, year, decade? Whence would this information come? > > No, doing this isn't really realistically possible to do in a non-slow way (or useful) > > adam. > > ------ Original Message ------ > From: "Justin Miller" <observium@dynstatic.net mailto:observium@dynstatic.net> > To: "Observium Network Observation System" <observium@observium.org mailto:observium@observium.org> > Sent: 12/11/2014 12:17:56 PM > Subject: Re: [Observium] Sort ports based on total data usage > >> That appears to be instantaneous amount when the poller collected it. I need how many bytes total. Not how many bits per second. >> >> I need to see that this port downloaded 3.4 TB of data, not that it’s doing 7 megabits per second. >> >> Justin >> >>> On Dec 11, 2014, at 1:12 PM, Spencer Gaw <spencerg@frii.net mailto:spencerg@frii.net> wrote: >>> >>> Click on the Traffic column on the ports page. >>> >>> Regards, >>> >>> SG >>> >>> On 12/11/2014 11:08 AM, Justin Miller wrote: >>>> We need to view the top X ports on switches which have used the most traffic (in & out) for a given time. I haven't been able to find this view. Is there a way to see this or will we have to create a special page to view this? >>>> >>>> Justin >>>> _______________________________________________ >>>> observium mailing list >>>> observium@observium.org mailto:observium@observium.org >>>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> >>> _______________________________________________ >>> observium mailing list >>> observium@observium.org mailto:observium@observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > _______________________________________________ > observium mailing list > observium@observium.org mailto:observium@observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium