mysql bin日志配置及查看
时间：2021-07-01 10:21:17
帮助过：24人阅读
`aayongche`
/*!*/;
SET TIMESTAMP=1485064811/*!*/;
//开始时间
insert into `users` (`userId`, `userName`) values (‘28396‘, ‘helly‘) //操作sql
/*!*/;
# at 38524047
#170122 14:00:11 server id 1 end_log_pos
38524078 CRC32
0xe8f99830 Xid
= 23583291 //服务器id
COMMIT/*!*/;
# at 38524078
#170122 14:
00:
22 server id
1 end_log_pos
38524167 CRC32
0x64c7f33a Query thread_id
=63112 exec_time
=0 error_code
=0
SET TIMESTAMP=1485064822/*!*/;
BEGIN
/*!*/;
# at 38524167
#170122 14:
00:
22 server id
1 end_log_pos
38524482 CRC32
0x3ff38ff2 Query thread_id
=63112 exec_time
=0 error_code
=0
SET TIMESTAMP=1485064822/*!*/;
users update ``
set `userName`
= ‘heheli‘ where `userId`
= ‘28396‘
/*!*/;
# at 38524482
mysql bin日志配置及查看
标签：update /var 开始时间 设置 var server `` begin int
