Division by 1000 yields this

+-----------------+----------------+
| ifInOctets_rate | ConvertedValue |
+-----------------+----------------+
|        54634728 | 437.08 Mbps    |
+-----------------+----------------+

Graph value: 445






On Tue, Aug 19, 2014 at 11:32 AM, Nikolay Shopik <shopik@inblock.ru> wrote:
Because network speed are muliply of 1000 not 1024

On 19 авг. 2014 г., at 10:17, Senses0 <senses0@gmail.com> wrote:

Hi,

I am using below query to convert ifInOctets_rate to Mbps value.

mysql> SELECT ifInOctets_rate, CONCAT(ROUND((ifInOctets_rate*8)/1024/1024,2), " Mbps") ConvertedValue FROM `ports-state` WHERE port_id=105;
+-----------------+----------------+
| ifInOctets_rate | ConvertedValue |
+-----------------+----------------+
|        55014356 | 419.73 Mbps    |
+-----------------+----------------+

The value I get different from the value printed on the graph for the same port_id. On the graph I got 427Mbps, while this conversion gives me 419. 

Since I don't know where in the code this conversion happens, I couldn't figure out if this is the way to go about it or not. 

Could someone shed some light?

Thanks
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium