清理Zabbix历史数据

发表于 | 分类于 | | 浏览量
| 字数 37 | 耗时 1分

统计Zabbix各表的大小

1
2
3
4
5
SELECT table_name AS "Tables",
	round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
	FROM information_schema.TABLES
	WHERE table_schema = 'zabbix'
	ORDER BY (data_length + index_length) DESC;

ZHANGCHI wechat
关注微信号进一步交流