Shulou(Shulou.com)05/31 Report--

This article shows you what to pay attention to when cleaning up Binlog, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

In the process of using the MySQL database, when the disk space is full, we usually use the drop, delete or truncate commands to clean up the data files to free up space. However, when the disk space is full, it is not necessarily because the data file reaches the storage bottleneck, partly because the log file is too large.

There are many log files in MySQL, among which Error log, General log, Binlog, and Redo log are the most frequently used logs. General log and Binlog are most likely to be generated in large quantities in the short term. However, the usage scenario of General log is not as frequent as Binlog, and General log will not be enabled in general business systems for a long time, because this will affect performance.

But Binlog is an essential log file for users of stand-alone, master-slave, and cluster versions. Improper cleaning of Binlog often causes serious problems, causing MySQL to fail to start completely.

The above is what you need to pay attention to when cleaning up binlog. have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.