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
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
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
What graph value you compare to?
On 19/08/14 10:41, Senses0 wrote:
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Bits/s In.
I also checked tabulated, numeric value for the same... under Ports menu.
On Tue, Aug 19, 2014 at 12:40 PM, Nikolay Shopik shopik@inblock.ru wrote:
What graph value you compare to?
On 19/08/14 10:41, Senses0 wrote:
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
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
On 19.08.2014 11:50, Senses0 wrote:
Bits/s In.
I also checked tabulated, numeric value for the same... under Ports menu.
This difference how calculate 'Last' rates in db and rrd: - DB calculate real rates betwen 2 poll times - in RRD graphs 'Last/Now' rates calculate betwen (current time) and (current time - 300), but betwen current time and last poll time RRD artificially fills with zero data..
Therefore rate in the graph is lower than from DB..
On Tue, Aug 19, 2014 at 12:40 PM, Nikolay Shopik <shopik@inblock.ru mailto:shopik@inblock.ru> wrote:
What graph value you compare to? On 19/08/14 10:41, Senses0 wrote: > 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 <mailto:shopik@inblock.ru>> wrote: > >> Because network speed are muliply of 1000 not 1024 >> >> On 19 авг. 2014 г., at 10:17, Senses0 <senses0@gmail.com <mailto: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 <mailto:observium@observium.org> >> 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 >> >> > > > > _______________________________________________ > observium mailing list > observium@observium.org <mailto:observium@observium.org> > 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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Also, ports poller ifInOctets_rate and billing poller are polled at different times, so they're not comparable either.
RRD value gives you the computed average rate between two time points 300 seconds apart, ifInOctets_rate gives you the absolute rate between two exactly timed data points calculated by php.
Either way, it's just a maths one-liner, and there is no scope for mistakes to be made.
adam.
On 2014-08-19 10:35, Mike Stupalov wrote:
On 19.08.2014 11:50, Senses0 wrote:
Bits/s In.
I also checked tabulated, numeric value for the same... under Ports menu.
This difference how calculate 'Last' rates in db and rrd: - DB calculate real rates betwen 2 poll times - in RRD graphs 'Last/Now' rates calculate betwen (current time) and (current time - 300), but betwen current time and last poll time RRD artificially fills with zero data..
Therefore rate in the graph is lower than from DB..
On Tue, Aug 19, 2014 at 12:40 PM, Nikolay Shopik shopik@inblock.ru wrote:
What graph value you compare to?
On 19/08/14 10:41, Senses0 wrote: 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 [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
-- Mike Stupalov http://observium.org [2]
Links:
[1] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [2] http://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Mike Stupalov -
Nikolay Shopik -
Senses0