Shulou(Shulou.com)06/01 Report--

This article mainly explains "how to delete the MySql-bin.0000X log file of Mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to delete the MySql-bin.0000X log file of Mysql.

My database adds up to about 100m.. However, the / usr/local/mysql/var directory actually has 548m memory MySqllybin.0000 files accounting for about 400m, which is a waste of space.

So what is the mysql-bin.00001 file in the mysql database folder?

Mysql-bin.000001, mysql- bin.000002 and other files are database operation logs, such as UPDATE a table, or DELETE some data, even if the statement does not have matching data, this command will be stored in the log file, including the time of each statement execution, will also be recorded.

So how should these files be deleted and banned?

Prohibited method: vi / etc/my.cnf put the inside

# log-bin=mysql-bin

# binlog_format=mixed

Comment out and restart the mysql service.

Delete method:

Enter the command:

/ usr/local/mysql/bin/mysql-u root-p

After entering the password to log in to mysql, run the command:

Reset master

(including; number)

Empty the log file. Then look at the size of the Mysql file, it is much smaller.

-bash-3.2# du-h-max-depth=1 / usr/local/mysql/var

Du: cannot access `250Cmaxconsumer depthreading 1: No such file or directory

142M / usr/local/mysql/var

At this point, I believe you have a deeper understanding of "how to delete the MySql-bin.0000X log file of Mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.