Clear the bin.00000mysql log file in MySQL

Today on the server df next, a look, var directory has been 98%, clear some log files and backup files found that mysql below a lot of similar mysql-bin.000001

Today on the server df next, a look, var directory has been 98%, clear some log files and backup files found that mysql below a lot of similar mysql-bin.000001

Today on the server df next, a look, var directory has been 98%, clear some log files and backup files found that mysql below a lot of files similar to mysql-bin.000001, if Google says it's a log, it's useless.

Database operation logs

Mysql-bin.000001

Mysql-bin.000002

Mysql-bin.000003

A lot of log files are over 10 Gb. My total mysql database is less than 1 GB.

These can be cleared.

Enter mysql-u root-p and then Password

Enter reset master after successful entry; remember this; ah!

Mysql> reset master;

Query OK, 0 rows affected, 1 warning (0.20 sec)

Mysql logs can be cleared, and the world is refreshing...

If you do not want mysql to record logs, disable them in my. ini.

Find my. ini, open it, find log-bin = mysql-bin, and comment it out.

# Log-bin = mysql-bin

,