|
|
mysql> show binary logs;
) |5 G" F% L- R' `8 bERROR 1381 (HY000): You are not using binary logging
+ k; T5 c& I0 }# U9 G8 E9 j% X( r1 T9 @+ c+ w& }* w8 F" i
解决办法：+ f i' q9 i# k7 z: Z7 b
修改my.cnf文件：" L% P9 s; k3 [5 W# D
在[mysqld]中添加
/ G: `4 t5 K. rlog-bin=log-bin.log binlog日志：, r. O* t) W, I5 K& V9 A- n
并设置3天清理一次bin.log日志
7 `/ ^/ R; I7 G% W9 Lexpire_logs_days=3
& o$ a8 V) M; [1 n重启数据：
% C. ?$ l5 i$ _ @service mysqld restart
" V+ x' W2 n' B0 U* kShutting down MySQL. SUCCESS!
" g. l- s# \. x2 TStarting MySQL. SUCCESS!
& d5 w' D1 L8 B! N+ S. Q# x+ B5 W' l' m/ X: s% J. Q9 {
2 K$ E* r2 T. v+ c4 i6 Z3 [
删除binlog日志# \8 h5 J# V$ m2 T% J* y, y) H$ a# r
mysql> show binary logs;
& m9 ^: W% S" N: x7 T( u! I0 K, C+ |+----------------+-----------+7 q0 q5 P( O$ O* N
| Log_name | File_size |! s$ n! l+ k" r* |4 W( E
+----------------+-----------+7 {) M3 \6 d: o5 a
| log-bin.000001 | 56932 |9 B; c. K. A2 o. v; t
| log-bin.000002 | 116186 |
+ \) ?- R# z" y$ D+ ~% q9 O( ]) b| log-bin.000003 | 21390 |$ ?6 \8 G7 D( o* A0 Z$ }, P
| log-bin.000004 | 125912 |
# D% Q3 o( o7 ?% S" X, m+----------------+-----------+4 v" h9 @5 N4 A& o
4 rows in set (0.00 sec) S2 q5 h1 W4 \) n- P) K% y
mysql> purge binary logs to 'log-bin.000001';
$ P6 @# C! w7 ]0 k3 j8 WQuery OK, 0 rows affected (0.00 sec)& n& Z$ L0 K2 j# }
7 A, k4 Z/ W- j- e
# U3 w* \- ]" w* q$ T
|
|
发表于 2020-2-20 15:50:53