I am facing a serious issue. The mysql logs are generated too frequently and too big files. I only run a small site on the server and the logs consume 38GB space in only a few hours(maybe even minutes). Due to this mysql stops working and site crashes. I have attached logs generated within a few minutes. These are logs just for a few minutes. Please have a look and thanks for the help.
Here's how to fix it.
Edit the file /etc/mysql/my.cnf
Find a line that reads "log_bin" and remove or comment it as follows:
#log_bin = /var/log/mysql/mysql-bin.log
You also need to remove or comment following lines:
#expire_logs_days = 10
#max_binlog_size = 100M
Close and save the file. Finally, restart mysql server:
# service mysql restart
how many sites you have?VPS with just one:
No I did not make any changes.Here's how to fix it.
Your regular donations is what keep this project moving forward. If you like Webinoly, buy me a coffee or a beer to show support.