为便于在出问题时排查和减小mysqlrizhi/ target=_blank class=infotextkey>mysql日志文件大小，需对慢查询日志和错误日志按天轮询。
例子，轮询脚本（/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计划任务：
0000***(/usr/sbin/logrotate-f/data/scripts/mysql-log-rotate>/dev/null2>&1)
