- 论坛徽章:
- 0
|
服务器配置了开启binlog,但是实际日志中看到的信息是这样的,不知道是什么原因,看不到update,delete等操作。请各位指点下。
# at 1069
# at 1130
#140830 2:09:59 server id 1 end_log_pos 1130 Table_map: `accesslog`.`accesslog` mapped to number 17
#140830 2:09:59 server id 1 end_log_pos 1198 Write_rows: table id 17 flags: STMT_END_F
BINLOG '
98EAVBMBAAAAPQAAAGoEAAAAABEAAAAAAAEACWFjY2Vzc2xvZwAJYWNjZXNzbG9nAAUDAwcPDwRa
AFoAGg==
98EAVBcBAAAARAAAAK4EAAAAABEAAAAAAAEABf/gM+cAABUAAAD3wQBUEmJvc3NAMTkyLjE2OC45
OS43NAZib3NzQCU=
'/*!*/;
# at 1198
#140830 2:09:59 server id 1 end_log_pos 1275 Query thread_id=21 exec_time=0 error_code=0
SET TIMESTAMP=1409335799/*!*/;
COMMIT
/*!*/;
# at 1275
#140830 2:10:00 server id 1 end_log_pos 1351 Query thread_id=22 exec_time=0 error_code=0
SET TIMESTAMP=1409335800/*!*/;
SET @@session.pseudo_thread_id=22/*!*/;
BEGIN
/*!*/;
# at 1351
# at 1412
#140830 2:10:00 server id 1 end_log_pos 1412 Table_map: `accesslog`.`accesslog` mapped to number 17
#140830 2:10:00 server id 1 end_log_pos 1480 Write_rows: table id 17 flags: STMT_END_F
BINLOG '
+MEAVBMBAAAAPQAAAIQFAAAAABEAAAAAAAEACWFjY2Vzc2xvZwAJYWNjZXNzbG9nAAUDAwcPDwRa |
|