My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database transactions are written to the Binlog files.
I am wondering because we do not have massive traffic on our website/WordPress. And having so many and large MySQL binlog files, as well as a lot of database events that are logged in the binlog files per second, could cause by a bot attack or any plugins are heavily using the database for temporal storage.
What I have done so far, I ran
mysql> PURGE BINARY LOGS BEFORE '2021-08-30 22:46:26'. This reduces disk size from 40GB to 10GB which is good.
Since I use a single server and I am not using a replica, can I disable BINARY LOG (
mysql> SET SQL_LOG_BIN =0), if I disable BINARY LOG, will this cause an issue?
What causes binary log files to increase rapidly, could this be malicious traffic? if so how can I stop it?