Clear and disable Binary logs of MySQL

The Binary logs of MySQL is cleared and disabled. Recently, MySQL has been flushed. Binary Log eats more than 800 MiB of hard disk space, which interferes with the normal operation of the system. There are many solutions, including directly deleting files and clearing logs one by one using SQL statements. However, I still prefer to use standard operations. Disable/etc/mysql/my. cnf, locate the log-bin option, and comment it out. If expire_logs_days expire_cnf exists, comment it out.

...# log-bin# expire_logs_days = 10...

 

To clear existing logs, first use mysql-u root-p to log on to the server.

SHOW BINARY LOGS;

 

First, let's take a look at how many logs we have and how much space we have. There are so many.

+-------------------+-----------+| Log_name          | File_size |+-------------------+-----------+| mysqld-bin.000001 |       264 || mysqld-bin.000002 |      1546 || mysqld-bin.000003 |     11728 || mysqld-bin.000004 | 122291346 || mysqld-bin.000005 |       264 || mysqld-bin.000006 |       958 || mysqld-bin.000007 |     85263 || mysqld-bin.000008 |    467392 || mysqld-bin.000009 |    271736 || mysqld-bin.000010 |       264 || mysqld-bin.000011 |      2670 || mysqld-bin.000012 |   5258576 || mysqld-bin.000013 |     25406 || mysqld-bin.000014 |    430000 || mysqld-bin.000015 |    560172 || mysqld-bin.000016 |  45971600 || mysqld-bin.000017 |  62227475 || mysqld-bin.000018 | 223992121 || mysqld-bin.000019 |  91294894 || mysqld-bin.000020 |   4796916 |+-------------------+-----------+FLUSH LOGS;RESET MASTER;

 

So far, Binary Logs has been permanently disabled.