zabbix housekeeper 太大 清理

217G  housekeeper.ibd

rename table housekeeper to housekeeper_bak_20220801;Query OK, 0 rows affected (40.94 sec)

直接rename 不会对zabbix运行和功能产生任何影响

rename table housekeeper to housekeeper_bak_20220801;

CREATE TABLE `housekeeper` (

`housekeeperid` bigint unsigned NOT NULL,

`tablename` varchar(64) DEFAULT '' NOT NULL,

`field` varchar(64) DEFAULT '' NOT NULL,

`value` bigint unsigned NOT NULL,

PRIMARY KEY (housekeeperid)

) ENGINE=InnoDB;

查看原文