We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it soon. Read more about it: https://vestacp.com/docs/vesta-2-development
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.