<强> zabbix清理旧数据
# !/bin/bash
用户=用户
Passwd=Passwd
日期=' date -d $ (date -d “-30天,”,Y + % % m % d), + % s ', #取30天之前的时间戳
$ (which mysql), - u $ {User}, - p $ {Passwd},, -S /tmp/mysql.sock -e “
use zabbix;
DELETE 得到history WHERE “时钟”,& lt;,美元日期;
optimize table 历史;
DELETE 得到history_str WHERE “时钟”,& lt;,美元日期;
optimize table history_str;
DELETE 得到history_uint WHERE “时钟”,& lt;,美元日期;
optimize table history_uint;
DELETE 得到history_text WHERE “时钟”,& lt;,美元日期;
optimize table history_text;
DELETE 得到,trends WHERE “时钟”,& lt;,美元日期;
optimize table ,趋势;
DELETE 得到trends_uint WHERE “时钟”,& lt;,美元日期;
optimize table trends_uint;
DELETE 得到events WHERE “时钟”,& lt;,美元日期;
optimize table 活动;
"
<强> mysql ibdata空间清理
mysqldump -u 【用户名】,- p [root_password], [database_name],比;
dumpfilename.sql
DROP DATABASE database_name/etc/init.d/mysqld 停止
rm /var/lib/mysql/ibdata1
rm /var/lib/mysql/ib_logfile */etc/init.d/mysqld 开始
create database [database_name]
mysql -u 【用户名】- p [root_password], [database_name], & lt; dumpfilename。sql
