Vesta Control Panel - Forum

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.

One solution is to use the logrotate command via cron.

sandro wrote: ↑

Mon Mar 21, 2022 12:17 pm

One solution is to use the logrotate command via cron.

Hello, how to do that please?

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.