Zabbix stores value_avg as BIGINT(20) in mysql DB.
It makes trends_uint almost unusable because of huge inaccuracy.
In point of view it make a lot more sense to store value as DOUBLE(16,4).
We've tried to modify column type in DB, but it haven't made any affect, because zabbix calculates avg value as integer.
Could you please modify it on zabbix server side?
Thanks in advance.