设置mysql（MariaDB ）数据库自动清理bin下log日志

admin

show global variables like 'expire_logs_days';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| expire_logs_days | 0     |
修改bin.log日志清理日期：
* e4 |4 D# x% L9 _1 r" y set global expire_logs_days=3;
  M  p; e% o, P/ lmysql>  show global variables like 'expire_logs_days';
- M1 x- a4 s( b: }) H& [/ ^+------------------+-------+
; d4 f! p- `. u( E; W| Variable_name    | Value |
+------------------+-------+
! K! B9 L! A: `9 R) e. u| expire_logs_days | 3     |
+------------------+-------+
1 row in set (0.00 sec)
4 _7 z& [9 Z5 r) v; \  |( }! g+------------------+-------+
1 row in set (0.01 sec)
0 Z! K! P. `8 ~* l
1 u( a: _4 _; K( R2 z4 J" ]$ K
手动清理bin日志
8 q' l+ ~1 x9 T; D" b我们执行flush logs;
mysql> flush logs;
Query OK, 0 rows affected, 64 warnings (0.16 sec
如果binlog非常多，不要轻易设置改参数，有可能导致io争用，这时候可以使用purge命令予以清除:

将bin.000055之前的binlog清掉:
mysql>purge binary logs to 'bin.000055';
将指定时间之前的binlog清掉:

mysql>purge binary logs before '2017-05-01 13:09:51';
+ o0 a. e  {' ]* [

MariaDB [(none)]>  show global variables like 'expire_logs_days';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
# {& E4 i4 q/ x. @5 \7 {& d; q& f| expire_logs_days | 0     |
+------------------+-------+
! b" ^7 M* v8 D( C7 {7 [1 row in set (0.00 sec)
MariaDB [(none)]> set global expire_logs_days=2;
, B% @2 G( t$ w6 qQuery OK, 0 rows affected (0.00 sec)
6 Y2 e7 T" F1 C1 S0 d2 cMariaDB [(none)]>  show global variables like 'expire_logs_days';
0 }' n' U! e4 d+------------------+-------+
| Variable_name    | Value |
. z: a8 {* x; [- h+------------------+-------+
| expire_logs_days | 2     |
7 p% H! ?- l$ X: f# \+------------------+-------+
1 row in set (0.01 sec)
MariaDB [(none)]> set global expire_logs_days=3;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]>  show global variables like 'expire_logs_days';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
+ H/ C6 q( \1 q0 ]| expire_logs_days | 3     |
+------------------+-------+
1 row in set (0.00 sec)
MariaDB [(none)]> flush logs;
5 Q+ w4 V- s! [+ z- E6 g$ w# KQuery OK, 0 rows affected (0.02 sec)
MariaDB [(none)]> purge binary logs before '2021-11-18 17:00:00';
" H, A6 ]4 ?3 Z0 O0 ~Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> purge binary logs before '2021-11-18 19:00:00';
Query OK, 0 rows affected (0.01 sec)

: D6 f0 M* K1 S0 C( c3 C  |

admin

[mysqld]
port = 3306
. N  a3 G4 R8 dsocket=/tmp/mysql.sock
( }- T9 o! N' e; G* x+ L" muser=mysql
; E8 J+ U6 b2 O2 p7 a/ M2 k1 z#log-bin=mysql-bin
7 H2 U4 M" J/ E  S( ?log-bin=log-bin.log   设置binlog日志
5 n& k: d; q, g# k) @#skip-grant-tables
( h) t6 D/ l$ d# _0 Y6 d& Y0 v4 {/ lexpire_logs_days=3   设置清理binlog日志时间
service mysqld restart
) m3 H0 R1 g  n% y+ A" X& YShutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
0 ?/ `) \4 T0 U0 I

admin

mysql> show variables like 'expire_logs_days';
# j1 n$ y0 n9 B) W+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| expire_logs_days | 3     |
+------------------+-------+
1 row in set (0.00 sec)

# n+ Y# b6 g* S% ^) rmysql> flush logs;
Query OK, 0 rows affected (0.01 sec)

mysql> show binary logs;
: d- c  W6 n) x) B/ y+----------------+-----------+
3 X3 P0 [/ ?6 T$ D2 [6 Z- |9 O| Log_name       | File_size |
# W- B- w! x2 d7 x+----------------+-----------+
| log-bin.000001 |     56932 |
3 n" P" O+ y, T% ?4 z7 N& L1 I& A| log-bin.000002 |    116186 |
| log-bin.000003 |      9780 |
+----------------+-----------+
5 P  ^0 |" }- x; g. B# m3 rows in set (0.00 sec)
5 e3 s8 H! N1 |
) ?$ V8 f/ e! P2 ~$ v" x0 rmysql> flush logs;
Query OK, 0 rows affected (0.00 sec)
' F9 O; r- x2 l9 E0 B; _/ @, x$ K: k
mysql> show binary logs;
! b1 F& m  Y$ M2 q. d4 e+----------------+-----------+
| Log_name       | File_size |
; {5 E9 Y  J% I) q2 h+ m" m+----------------+-----------+
| log-bin.000001 |     56932 |
9 N2 p: a( G( L( H* y- P2 k2 z| log-bin.000002 |    116186 |
| log-bin.000003 |     21390 |
| log-bin.000004 |      1406 |
+----------------+-----------+
4 rows in set (0.00 sec)
+ ]: o8 w  B; g+ c) _/ Y
2 \0 \+ }8 D) m) @mysql>