|
|
mysql> show binary logs;
5 U9 c7 V7 k K( o- AERROR 1381 (HY000): You are not using binary logging
1 w; [, l* |+ u: m2 C8 f$ {) R2 x, t/ E3 c0 u
解决办法：% D2 m9 C6 w0 n! a' N( q+ ]
修改my.cnf文件：: v$ G/ Z+ X2 M+ R
在[mysqld]中添加 h4 E1 z- R, @, G! k( r; Y$ S1 \
log-bin=log-bin.log binlog日志：' s/ n+ e( A5 {6 R& C+ f7 }0 \
并设置3天清理一次bin.log日志
: E) Q; P, x. l! Y6 |expire_logs_days=35 ^/ w% I/ g" k! E8 R$ X
重启数据：& w; L7 Y8 G0 Y7 w+ }; x9 G. N& j+ V! d
service mysqld restart
4 P/ H5 G4 F5 J1 N) fShutting down MySQL. SUCCESS!
3 Q" v( b9 U& H3 AStarting MySQL. SUCCESS!
; K) o0 {! x: ?3 `& q0 m. ]6 z& m
: k* S( x0 e) T7 d. p! {) R; A- F0 T0 e
删除binlog日志
$ Z' h# I4 V5 [* l. c8 |mysql> show binary logs;% `8 O' Z; J+ A
+----------------+-----------+
4 t3 S! g7 ]9 H0 k| Log_name | File_size |
) |+ H. {; ~! F- z+----------------+-----------+
# x5 f8 c2 S! [; z1 i| log-bin.000001 | 56932 |
3 _5 N% n! ]8 Z' I) A| log-bin.000002 | 116186 |5 G2 D3 ~0 Q f7 N4 W
| log-bin.000003 | 21390 |
6 Y1 I/ b( @ G+ V5 [! F: S5 U6 _| log-bin.000004 | 125912 |: N6 O2 O( W3 \% w
+----------------+-----------+3 C' e! E# a4 n
4 rows in set (0.00 sec)
) c6 H4 A+ I- K% j. A' rmysql> purge binary logs to 'log-bin.000001';
+ {4 @1 p( ?# oQuery OK, 0 rows affected (0.00 sec)# N* Y, ~+ z G- P8 t( Q
, s/ v, V* s2 `$ `( Z
$ D: N, Z/ _! _/ I |
|
发表于 2020-2-20 15:50:53