查看binlog
MySQL [(none)]> show binary logs;+------------------+------------+
| Log_name | File_size |
+------------------+------------+
| mysql-bin.000246 | 1073742039 |
| mysql-bin.000247 | 1073742006 |
| mysql-bin.000248 | 161823524 |
+------------------+------------+
3 rows in set (0.00 sec)自动删除
MySQL [(none)]> set global expire_logs_days=1;Query OK, 0 rows affected (0.00 sec)手动删除
MySQL [(none)]> purge master logs to 'mysql-bin.000246';Query OK, 0 rows affected (4.53 sec)标签：none,rows,logs,清理,binglog,sec,mysql,MySQL From： https://www.cnblogs.com/wangguishe/p/17168249.html