Processing Mysql MySql-bin.0000X log file _ MySQL

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.