Zabbix history and trends cleanup

Shut down the Zabbix server and frontend connections to the DB

If using MySQL, make sure auto_recalc is 1 otherwise you will have to analyze all these tables. The default value is 1.

CREATE TABLE history_new LIKE history;

CREATE TABLE history_log_new LIKE history_log;

CREATE TABLE history_str_new LIKE history_str;

CREATE TABLE history_text_new LIKE history_text;

CREATE TABLE history_uint_new LIKE history_uint;

CREATE TABLE trends_new LIKE trends;

CREATE TABLE trends_uint_new LIKE trends_uint;

ALTER TABLE trends RENAME trends_old;

ALTER TABLE trends_new RENAME trends;

ALTER TABLE trends_uint RENAME trends_uint_old;

ALTER TABLE trends_uint_new RENAME trends_uint;

ALTER TABLE history RENAME history_old;

ALTER TABLE history_new RENAME history;

ALTER TABLE history_log RENAME history_log_old;

ALTER TABLE history_log_new RENAME history_log;

ALTER TABLE history_str RENAME history_str_old;

ALTER TABLE history_str_new RENAME history_str;

ALTER TABLE history_text RENAME history_text_old;

ALTER TABLE history_text_new RENAME history_text;

ALTER TABLE history_uint RENAME history_uint_old;

ALTER TABLE history_uint_new RENAME history_uint;

DROP TABLE trends_old;

DROP TABLE trends_uint_old;

DROP TABLE history_old;

DROP TABLE history_log_old;

DROP TABLE history_str_old;

DROP TABLE history_text_old;

DROP TABLE history_uint_old;

delete from events;

That's all.