1.安装 mailx并配置参数文件
yum install mailx -y
填写smtp地址等相关配置
vi /etc/mail.rc
set from=
set smtp=
set smtp-auth-user=
set smtp-auth-password=
2.安装pt工具
安装步骤就不一一介绍了,可以参考https://blog.csdn.net/u014609263/article/details/86063905
3.脚本编写(需要修改日志路径,邮箱地址等)
mkdir /data/weekly/slow -p
vi /data/weekly/slow/slow.sh
#!/bin/bash
dt=`date +%Y_%m_%d`
/usr/local/bin/pt-query-digest /data/mysql/data/slow.log >/data/weekly/slow/slow$dt.log
echo "(xxx平台host:192.168.0.1)上周最新慢日志,请查收!" | /bin/mail -s "last_week.SLOWlog" -a /data/weekly/slow/slow$dt.log xxx@qq.com,xxxxx@qq.com
cp -f /data/mysql/data/slow.log /data/weekly/slow/$dtslow.log
>/data/mysql/data/slow.log
find /data/weekly/slow/ -mtime +15 -name "*slow*.log" -exec rm -rf {} \;