配置mysql的 log rotate

mysql的error log还有general log等需要进行切割。可以结合logrotate进行log 切割

拷贝support_files下的mysql-log-rotate文件到/etc/logrotate.d/目录下，然后将权限修改为644

需要对mysql-log-rotate的内容继续修改已适应文件所在位置及切割的要求

[root@rws1270149 logrotate.d]# cat mysql-log-rotate | grep -v ‘#’

/scratch/mysql-5.7.25-linux-glibc2.12-x86_64/data/mysqld.log {
notifempty
daily
rotate 10
missingok
compress
dateext
postrotate
if test -x /scratch/mysql-5.7.25-linux-glibc2.12-x86_64/bin/mysqladmin &&
/scratch/mysql-5.7.25-linux-glibc2.12-x86_64/bin/mysqladmin ping &>/dev/null
then
/usr/local/mysql/bin/mysqladmin flush-logs
fi
endscript
}
/scratch/mysql-5.7.25-linux-glibc2.12-x86_64/data/rws1270149.log {
notifempty
daily
rotate 10
missingok
compress
dateext
postrotate
if test -x /scratch/mysql-5.7.25-linux-glibc2.12-x86_64/bin/mysqladmin &&
/scratch/mysql-5.7.25-linux-glibc2.12-x86_64/bin/mysqladmin ping &>/dev/null
then
/usr/local/mysql/bin/mysqladmin flush-logs
fi
endscript
}

测试配置是不是正确

/usr/sbin/logrotate -d /etc/logrotate.d/mysql-log-rotate

强制运行logrotate，不等crontab调用

/usr/sbin/logrotate -f /etc/logrotate.d/mysql-log-rotate