Remove Binlog from MySQL

Recently, using the latest version of MySQL, 8.0.11 found that the default value of MySQL's log_bin parameter changed to ON. At first, the change was not noticed, resulting in the use of a lot of bin logs, which consumed a lot of disk space.

So you need to delete these logs and free up disk space.

1. Use show master logs to view

Mysql> show master logs;
+---------------+--------------+
| Log_name | File_size |
+---------------+--------------+
| binlog.000001 | 222927706 |
| binlog.000002 | 11270499 |
| binlog.000003 | 682550567 |
| binlog.000004 | 5784673228 |
| binlog.000005 | 3832371427 |
| binlog.000006 | 66920730055 |
| binlog.000007 | 126988323278 |
| binlog.000008 | 74493309953 |
| binlog.000009 | 340865 |
| binlog.000010 | 155 |
+---------------+--------------+

2. Delete

Mysql> purge binary logs to ' binlog.000009 ';
Query OK, 0 rows affected (5.98 sec)

Remove Binlog from MySQL