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


Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"


Top Level » MySQL / MariaDB

I have many mysql-bin files which are using up a lot of spaceLast Modified: Mar 12, 2012, 4:43 pm
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.

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST