linux mysql清理日志文件

sudo rm /var/log/mysql/error.log
sudo rm /var/log/mysql/slow-query.log

sudo nano /etc/logrotate.d/mysql

/var/log/mysql/error.log {
    daily
    rotate 7
    compress
    delaycompress
    missingok
    notifempty
    create 640 mysql adm
}

/var/log/mysql/slow-query.log {
    daily
    rotate 7
    compress
    delaycompress
    missingok
    notifempty
    create 640 mysql adm
}

sudo logrotate -f /etc/logrotate.d/mysql

sudo nano /etc/mysql/my.cnf

[mysqld]
log-error=/var/log/mysql/error.log
slow-query-log=0
slow-query-log-file=/var/log/mysql/slow-query.log

sudo systemctl restart mysql