Processing the MySql-bin.0000X log file bitsCN.com for Mysql
After mysql was running for a while, there was a pile of mysql-bin.000 like *** in the mysql directory, which was arranged from the mysql-bin.000001 and took up a lot of hard disk space, up to dozens of GB. what should we do for these files with large space usage?
First let's analyze the mysql database folder in the mysql-bin.00001 is what file?
Mysql-bin.000001, mysql-bin.20.02 and other files are Database operation logs, such as UPDATE a table, or DELETE some data, even if the statement does not match the data, this command will also be stored in the log file, and the execution time of each statement will also be recorded.
What about any processing?
/Usr/local/mysql/bin/mysql-u root-p
Enter the password to log on to mysql and run the following command:
Reset master;
(End)
BitsCN.com