zabbix 清理旧数据

#!/bin/bashUser=userPasswd=passwdDate=`date-d$(date-d"-30day"+%Y%m%d)+%s`#取30天之前的时间戳$(whichmysql)-u${User}-p${Passwd}-S/tmp/mysql.sock-e"usezabbix;DELETEFROMhistoryWHERE'clock'<$Date;optimizetablehistory;DELETEFROMhistory_strWHERE'clock'<$Date;optimizetablehistory_str;DELETEFROMhistory_uintWHERE'clock'<$Date;optimizetablehistory_uint;DELETEFROMhistory_textWHERE'clock'<$Date;optimizetablehistory_text;DELETEFROMtrendsWHERE'clock'<$Date;optimizetabletrends;DELETEFROMtrends_uintWHERE'clock'<$Date;optimizetabletrends_uint;DELETEFROMeventsWHERE'clock'<$Date;optimizetableevents;"

mysql ibdata空间清理

mysqldump-u[username]-p[root_password][database_name]>dumpfilename.sqlDROPDATABASEdatabase_name/etc/init.d/mysqldstoprm/var/lib/mysql/ibdata1rm/var/lib/mysql/ib_logfile*/etc/init.d/mysqldstartcreatedatabase[database_name]mysql-u[username]-p[root_password][database_name]<dumpfilename.sql