Shulou(Shulou.com)06/01 Report--

Zabbix cleans up old data

#! / bin/bashUser=userPasswd=passwdDate= `date-d $(date-d "- 30 day" +% Y%m%d) +% s` # take the timestamp of 30 days ago $(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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.