Debian Codegraph @

mysql-test/suite/binlog/r/binlog_server_id.result

raw
1 set global server_id=1;
2 reset master;
3 drop table if exists t1,t2,t3;
4 create table t1 (a int);
5 select @@server_id;
6 @@server_id
7 1
8 show binlog events from <binlog_start>;
9 Log_name Pos Event_type Server_id End_log_pos Info
10 master-bin.000001 # Gtid_list 1 # []
11 master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001
12 master-bin.000001 # Gtid 1 # GTID #-#-#
13 master-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS `t1`,`t2`,`t3` /* generated by server */
14 master-bin.000001 # Gtid 1 # GTID #-#-#
15 master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
16 set global server_id=2;
17 create table t2 (b int);
18 select @@server_id;
19 @@server_id
20 2
21 show binlog events from <binlog_start>;
22 Log_name Pos Event_type Server_id End_log_pos Info
23 master-bin.000001 # Gtid_list 1 # []
24 master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001
25 master-bin.000001 # Gtid 1 # GTID #-#-#
26 master-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS `t1`,`t2`,`t3` /* generated by server */
27 master-bin.000001 # Gtid 1 # GTID #-#-#
28 master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
29 master-bin.000001 # Gtid 2 # GTID #-#-#
30 master-bin.000001 # Query 2 # use `test`; create table t2 (b int)
31 set global server_id=3;
32 create table t3 (c int);
33 select @@server_id;
34 @@server_id
35 3
36 show binlog events from <binlog_start>;
37 Log_name Pos Event_type Server_id End_log_pos Info
38 master-bin.000001 # Gtid_list 1 # []
39 master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001
40 master-bin.000001 # Gtid 1 # GTID #-#-#
41 master-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS `t1`,`t2`,`t3` /* generated by server */
42 master-bin.000001 # Gtid 1 # GTID #-#-#
43 master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
44 master-bin.000001 # Gtid 2 # GTID #-#-#
45 master-bin.000001 # Query 2 # use `test`; create table t2 (b int)
46 master-bin.000001 # Gtid 3 # GTID #-#-#
47 master-bin.000001 # Query 3 # use `test`; create table t3 (c int)
48 set global server_id=1;
49 drop table t1,t2,t3;