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