We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
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.