zabbix 清理旧数据

zabbix 清理旧数据

#!/bin/bashUser=userPasswd=passwdDate=`date -d $(date -d "-30 day" +%Y%m%d) +%s` #取30天之前的时间戳$(which mysql) -u${User} -p${Passwd}  -S /tmp/mysql.sock -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;"

mysql ibdata空间清理

mysqldump -u [username] -p[root_password] [database_name] >dumpfilename.sqlDROP DATABASE database_name/etc/init.d/mysqld stoprm /var/lib/mysql/ibdata1 rm /var/lib/mysql/ib_logfile*/etc/init.d/mysqld startcreate database [database_name]mysql -u [username]-p[root_password] [database_name] < dumpfilename.sql