Enable high precision float values, Zabbix 5.0

Rename existing float tables:
alter table trends rename to trends_tmp;
alter table history rename to history_tmp;
create table trends like trends_tmp;
create table history like history_tmp;
Modify double.sql script to use *_tmp tables

Keep in mind that while this process is running, history data from trends and history tables won't be visible in the frontend.

Rename back and insert missing date:
alter table trends rename to trends_new;
alter table history rename to history_new;
alter table trends_tmp to trends;
alter table history_tmp to history;
insert into history select * from history_new;
insert into trends select * from trends_new;

No comments: