vim mysql-log-rotate
#写入以下命令代码
/var/log/mysqld.log {
create 644 mysql mysql
dateext
notifempty
daily
maxage 60
rotate 30
missingok
compress
olddir /var/log/old_log
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping -uroot -p密码 -S /var/lib/mysql/mysql.sock &>/dev/null
then
/usr/bin/mysqladmin flush-logs -uroot -p密码 -S /var/lib/mysql/mysql.sock
fi
endscript
}
/var/log/mysql/mysql-slow.log{
create 644 mysql mysql
dateext
notifempty
daily
maxage 60
rotate 30
missingok
compress
olddir /var/log/old_log
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping -uroot -p密码 -S /var/lib/mysql/mysql.sock &>/dev/null
then
/usr/bin/mysqladmin flush-logs -uroot -p密码 -S /var/lib/mysql/mysql.sock
fi
endscript
}
定时
crontab -e
* 2 * * * /usr/sbin/logrotate -f /root/mysql-log-rotate
#命令加文件名路径