[ZBXNEXT-2994] Modify value_avg type in trends_uint (MySQL) Created: 2015 Oct 01  Updated: 2015 Oct 01

Status: Confirmed
Project: ZABBIX FEATURE REQUESTS
Component/s: Server (S)
Affects Version/s: 2.4.6
Fix Version/s: None

Type: Change Request Priority: Major
Reporter: Kanstantin Assignee: Unassigned
Resolution: Unresolved Votes: 4
Labels: database, trends
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Hi there,

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.
Best Regards.



 Comments   
Comment by richlv [ 2015 Oct 01 ]

initially mentioned in ZBX-3643

Generated at Fri Apr 19 02:46:54 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.