cleardbzabbix.sql

use zabbix;
truncate table history;
truncate table history_log;
truncate table history_str;
truncate table history_text;
truncate table history_uint;
truncate table trends;
truncate table trends_uint;
optimize table history;
optimize table history_log;
optimize table history_str;
optimize table history_text;
optimize table history_uint;
optimize table trends;
optimize table trends_uint;