mysql 轮询 特别慢_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信息：

5923***(/usr/sbin/logrotate-f/data/scripts/mysql-log-rotate>/dev/null2>&1)