webmultiple 发表于 2014-08-30 02:24

mysql bin log无法记录写操作

服务器配置了开启binlog，但是实际日志中看到的信息是这样的，不知道是什么原因，看不到update,delete等操作。请各位指点下。
# at 1069
# at 1130
#1408302:09:59 server id 1end_log_pos 1130Table_map: `accesslog`.`accesslog` mapped to number 17
#1408302:09:59 server id 1end_log_pos 1198Write_rows: table id 17 flags: STMT_END_F

BINLOG '
98EAVBMBAAAAPQAAAGoEAAAAABEAAAAAAAEACWFjY2Vzc2xvZwAJYWNjZXNzbG9nAAUDAwcPDwRa
AFoAGg==
98EAVBcBAAAARAAAAK4EAAAAABEAAAAAAAEABf/gM+cAABUAAAD3wQBUEmJvc3NAMTkyLjE2OC45
OS43NAZib3NzQCU=
'/*!*/;
# at 1198
#1408302:09:59 server id 1end_log_pos 1275Query   thread_id=21    exec_time=0   error_code=0
SET TIMESTAMP=1409335799/*!*/;
COMMIT
/*!*/;
# at 1275
#1408302:10:00 server id 1end_log_pos 1351Query   thread_id=22    exec_time=0   error_code=0
SET TIMESTAMP=1409335800/*!*/;
SET @@session.pseudo_thread_id=22/*!*/;
BEGIN
/*!*/;
# at 1351
# at 1412
#1408302:10:00 server id 1end_log_pos 1412Table_map: `accesslog`.`accesslog` mapped to number 17
#1408302:10:00 server id 1end_log_pos 1480Write_rows: table id 17 flags: STMT_END_F

BINLOG '
+MEAVBMBAAAAPQAAAIQFAAAAABEAAAAAAAEACWFjY2Vzc2xvZwAJYWNjZXNzbG9nAAUDAwcPDwRa

webmultiple 发表于 2014-08-30 11:38

有没有人知道什么原因啊

yangward 发表于 2014-11-14 23:30

mysqlbinlog -v -v -v xxx-bin.log > xxx.log

psufnxk2000 发表于 2015-03-11 18:14

mysqlbinlog
页: [1]
查看完整版本: mysql bin log无法记录写操作