删除30天之前的历史数据
User="xxx"
Passwd="xxx"
Date=`date -d $(date -d "-30 day" +%Y%m%d) +%s`
mysql -u${User} -p${Passwd} 2> /dev/null -e "
use zabbix;
DELETE FROM history WHERE 'clock' < $Date;
optimize local table history;
DELETE FROM history_uint WHERE 'clock' < $Date;
optimize local table history_uint;
DELETE FROM history_text WHERE 'clock' < $Date;
optimeze local table history_text;"