zabbix历史数据库清除，数据库瘦身脚本分享
没清除之前的数据库大小：
查看各个表的大小：
下面是数据库脚本分享：
#!/bin/bash
# date：2020-01-17 10:50:22
# version：1.0
# name：wangxuejin
# by zabbix history mysql_data delete
##############################################################
User="zabbix"
Passwd="xxxxxx"
Date=date -d $(date -d "-90 day" +%Y%m%d) +%s #取7天之前的时间戳
MYSQL=/usr/local/mysql/bin/mysql
$MYSQL -u${User} -p${Passwd} -e "
use zabbix;
DELETE FROM history WHERE 'clock' < $Date;
optimize table history;
DELETE FROM history_str WHERE 'clock' < $Date;
optimize table history_str;
DELETE FROM history_uint WHERE 'clock' < $Date;
optimize table history_uint;
DELETE FROM history_text WHERE 'clock' < $Date;
optimize table history_text;
DELETE FROM trends WHERE 'clock' < $Date;
optimize table trends;
DELETE FROM trends_uint WHERE 'clock' < $Date;
optimize table trends_uint;
DELETE FROM events WHERE 'clock' < $Date;
optimize table events;
"
查看缩减之后的大小：
成功缩减了18G！
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。
