没清除之前的数据库大小:
查看各个表的大小:
下面是数据库脚本分享:
#!/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' <