Mysql log file too large
Mysql log file too large
My server had 100% disk usage.
Upon investigating, I found that mysql log file was taking 36GB of space.
How do I prevent it from happening again?
Location of log file:
/var/lib/mysql/vestacp.log
I am running ubuntu 20.04 and Hestia version v1.5.10.
Upon investigating, I found that mysql log file was taking 36GB of space.
How do I prevent it from happening again?
Location of log file:
/var/lib/mysql/vestacp.log
I am running ubuntu 20.04 and Hestia version v1.5.10.
Re: Mysql log file too large
One solution is to use the logrotate command via cron.
Re: Mysql log file too large
Try including the following lines in the /etc/logrotate.d/vesta file:
/var/lib/mysql/vestacp.log {
create 600 mysql mysql
missingok
notifempty
daily
rotate 3
compress
}
Check that files like vestacp.log-20220331.gz are created in the /var/lib/mysql directory and make the necessary adjustments to make it the way you need it.
/var/lib/mysql/vestacp.log {
create 600 mysql mysql
missingok
notifempty
daily
rotate 3
compress
}
Check that files like vestacp.log-20220331.gz are created in the /var/lib/mysql directory and make the necessary adjustments to make it the way you need it.