问题背景:
为便于问题排查和减小日志文件大小,需对慢查询日志和错误日志按天轮询
轮询脚本(/data/scripts/mysql-log-rotate):
"/data/dbdata/otherlog/slow_query.log" "/data/dbdata/otherlog/mysql_error.log" { create 660 mysql mysql dateext notifempty daily maxage 60 rotate 30 missingok compress olddir /data/dbdata/otherlog postrotate if /usr/local/mysql/bin/mysqladmin ping -uroot -S /var/run/mysql/mysql.sock &>/dev/null; then /usr/local/mysql/bin/mysqladmin flush-logs -uroot -S /var/run/mysql/mysql.sock fi endscript }
CRONTAB信息:
5923***(/usr/sbin/logrotate-f/data/scripts/mysql-log-rotate>/dev/null2>&1)
转载于:https://blog.51cto.com/sofar/1303771