We are having an issue with the default MySql schema with Zabbix where it stores all trend values as a double(16,4).
ex.
value_min double(16,4) DEFAULT '0.0000' NOT NULL,
value_avg double(16,4) DEFAULT '0.0000' NOT NULL,
value_max double(16,4) DEFAULT '0.0000' NOT NULL,
We have large file clusters with multiple terabytes of data. When looking at the data using the history table, it works fine because it is reading out of history_uint and can store large values. When reading data from the trends table (graphs showing more than 3 days) all values show as 931.32GB on the graph (or 100000000000.0000 inside the trends table).
Does anyone have experience with changing the trend values (min,avg,max) to either double(20,4) or maybe bigint? Right now we can't trend any data on a drive larger than a terabytes due to this constraint.
I noticed that the default oracle schema has these values listed as number(20,4) so I am hoping someone here has experience changing this in MySQL to match.
I can see in the 1.6.X and beyond there is a separate trends_uint table. However, I am running Zabbix 1.4.6.
Thanks
ex.
value_min double(16,4) DEFAULT '0.0000' NOT NULL,
value_avg double(16,4) DEFAULT '0.0000' NOT NULL,
value_max double(16,4) DEFAULT '0.0000' NOT NULL,
We have large file clusters with multiple terabytes of data. When looking at the data using the history table, it works fine because it is reading out of history_uint and can store large values. When reading data from the trends table (graphs showing more than 3 days) all values show as 931.32GB on the graph (or 100000000000.0000 inside the trends table).
Does anyone have experience with changing the trend values (min,avg,max) to either double(20,4) or maybe bigint? Right now we can't trend any data on a drive larger than a terabytes due to this constraint.
I noticed that the default oracle schema has these values listed as number(20,4) so I am hoping someone here has experience changing this in MySQL to match.
I can see in the 1.6.X and beyond there is a separate trends_uint table. However, I am running Zabbix 1.4.6.
Thanks