In this thread I talked to myself http://www.zabbix.com/forum/showthread.php?t=4190
But if anybody out there is looking for the answer on how to fix it I have it below.
Problem: 64 bit servers showing up as GBps instead of proper mb/s
More info: This only happens on servers that have high values for RX bytes or TX bytes, I.E. servers that have a LOT of data moving back and forth. For me it was on high availablity 64bit Database servers.
The Fix:
Alter column 'prevorgvalue' in table 'items' from double(16,4) to double(20,4) in the database to allow more characters
Walkthrough: (change the obvious fields to suit your needs for db and user)
mysql -u root -p
use database zabbix;
show tables;
show columns on items;
ALTER TABLE items MODIFY prevorgvalue double(20,4);
Done. I hope this helps somebody else. I pulled my hair out for days on this.
But if anybody out there is looking for the answer on how to fix it I have it below.
Problem: 64 bit servers showing up as GBps instead of proper mb/s
More info: This only happens on servers that have high values for RX bytes or TX bytes, I.E. servers that have a LOT of data moving back and forth. For me it was on high availablity 64bit Database servers.
The Fix:
Alter column 'prevorgvalue' in table 'items' from double(16,4) to double(20,4) in the database to allow more characters
Walkthrough: (change the obvious fields to suit your needs for db and user)
mysql -u root -p
use database zabbix;
show tables;
show columns on items;
ALTER TABLE items MODIFY prevorgvalue double(20,4);
Done. I hope this helps somebody else. I pulled my hair out for days on this.