**** SHOW BINLOG EVENTS on default ****
|
binlog_name = 'master-bin.000001'
|
SHOW BINLOG EVENTS IN 'master-bin.000001';
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 4 Format_desc 1 256 Server ver: 10.5.6-MariaDB-debug-log, Binlog ver: 4
|
master-bin.000001 256 Gtid_list 1 285 []
|
master-bin.000001 285 Binlog_checkpoint 1 329 master-bin.000001
|
master-bin.000001 329 Gtid 1 371 GTID 0-1-1
|
master-bin.000001 371 Query 1 482 use `test`; create table t1 (c1 int,c2 int)engine=myisam
|
master-bin.000001 482 Gtid 1 524 BEGIN GTID 0-1-2
|
master-bin.000001 524 Query 1 623 use `test`; insert into t1 values(1,1),(2,2)
|
master-bin.000001 623 Query 1 696 COMMIT
|
master-bin.000001 696 Gtid 1 738 BEGIN GTID 0-1-3
|
master-bin.000001 738 Query 1 834 use `test`; update t1 set c1=3 where c2=2
|
master-bin.000001 834 Query 1 907 COMMIT
|
master-bin.000001 907 Gtid 1 951 GTID 0-1-4
|
master-bin.000001 951 Query 1 1041 XA COMMIT X'7861',X'',1
|
|