Gentlemen, I'm currently working with an ISP in order to implement pmacct's sFlow collector to assist in billing practices.
Their billing process relies on average Mbs used per month. While looking through the data (logged into mySQL) we were trying to interpret the way pmacct logs the data. The first question is, the two rows, packets and bytes, is that to mean, "I've captured x amount of packets, and together they equal y." or does it mean "I've captured x packets, each of which are y in size." I'm using this tool for byte to Mb for conversions during testing: > http://www.unitconversion.org/data-storage/bytes-to-megabits-conversion.html > The number of samples on each VLAN is 1/1000. > For example: If sfacct reports 7 packets, 542 bytes, that's 7 packets > whose total equal 542 bytes. That being the case, I ran a query for all > packets,bytes for VLAN 78 within 10 minutes, 12:30-12:40 PM, > That totaled out at 1,193,384 bytes and according to that online > calculator, > that's 9.1Mb a second (which seems consistent to some of what we saw > watching that java applet), which I figured, to get the average bytes, > therefore average Mb, you just divide the bytes by total number of the > total > number of packet rows, 17, which gave .5Mb over 10 minutes. Thinking about > it though, I'm not sure how correct my method to get the average is. > > I tried the packets*bytes*8 and got astronomical numbers, for instance the > biggest packet/byte size in that sample was 803 packets, 1146376 bytes, > using that formula that's 7023.1 Mb (7Gb at that point?), where as just the > total bytes there is 8.7Mbs, which seems a bit more reasonable. > More clearly, we're attempting to figure out what the formula is to give Mbs used over a certain period of time given the data pmacct collects. Thanks all in advance, Michael
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
