Add to Favourites Add to Favourites    Print this Article Print this Article

I have many mysql-bin files which are using up a lot of space

If your MySQL data directory has many files such as:

mysql-bin.000001
mysql-bin.000002
etc..



that means that the [mysqld] option:

log-bin=mysql-bin

is enabled in your /etc/my.cnf (or in the startup script).

The solution to prevent those files from being created is to comment out the log-bin option from the my.cnf by adding at # character at the start of the line (left side).
The internal default is "OFF", hence removing it will disable it.

You can delete your mysql-bin.0* files after mysqld has been restarted.

Was this answer helpful?

Also Read