Debian Codegraph @

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

raw
1 #
2 # Kill OPTIMIZE command prior to table modification
3 #
4 RESET MASTER;
5 CREATE TABLE t1 (f INT) ENGINE=INNODB;
6 CREATE TABLE t2 (f INT) ENGINE=INNODB;
7 connect con1,127.0.0.1,root,,test,$MASTER_MYPORT,;
8 connection con1;
9 SET debug_sync='admin_command_kill_before_modify SIGNAL ready_to_be_killed WAIT_FOR master_cont';
10 OPTIMIZE TABLE t1,t2;
11 connection default;
12 SET debug_sync='now WAIT_FOR ready_to_be_killed';
13 KILL THD_ID;
14 SET debug_sync = 'reset';
15 disconnect con1;
16 include/show_binlog_events.inc
17 Log_name Pos Event_type Server_id End_log_pos Info
18 master-bin.000001 # Gtid # # GTID #-#-#
19 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (f INT) ENGINE=INNODB
20 master-bin.000001 # Gtid # # GTID #-#-#
21 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (f INT) ENGINE=INNODB
22 DROP TABLE t1,t2;
23 RESET MASTER;
24 #
25 # Kill OPTIMIZE command after table modification
26 #
27 CREATE TABLE t1 (f INT) ENGINE=INNODB;
28 CREATE TABLE t2 (f INT) ENGINE=INNODB;
29 connect con1,127.0.0.1,root,,test,$MASTER_MYPORT,;
30 connection con1;
31 SET debug_sync='admin_command_kill_after_modify SIGNAL ready_to_be_killed WAIT_FOR master_cont';
32 OPTIMIZE TABLE t1,t2;
33 connection default;
34 SET debug_sync='now WAIT_FOR ready_to_be_killed';
35 KILL THD_ID;
36 SET debug_sync = 'reset';
37 disconnect con1;
38 DROP TABLE t1,t2;
39 FLUSH LOGS;
40 FOUND 1 /OPTIMIZE TABLE t1,t2/ in mysqlbinlog.out