Avoid too large MySQL logs

You can quickly have your hard drive flooded with files mysql-bin.xxxxxx (mysql-bin.000001...). These files are MySQL logs which trace all the modifications to the database.It is best to disable them by modifying the my.ini file and adding this in the mysqldd section:

By restarting the MySQL server, the log files will be automatically deleted.

Binlog files on MySQL 8

On MySQL 8, binlog.xxxxxx files can take up a lot of space. Here's how to purge them.

First, run the following query to indicate if the binary logs are active and display the files already present:

Then run the purge of these files in MySQL:

To avoid creating new ones, modify your configuration file:

Then add the following part:

Then restart the MySQL server to take this change into account.