Debian Codegraph @

mysql-test/suite/innodb/r/group_commit.result

raw
1 CREATE TABLE t1 (a VARCHAR(10) PRIMARY KEY) ENGINE=innodb;
2 INSERT INTO t1 VALUES(100);
3 SELECT variable_value INTO @commits FROM information_schema.global_status
4 WHERE variable_name = 'binlog_commits';
5 SELECT variable_value INTO @group_commits FROM information_schema.global_status
6 WHERE variable_name = 'binlog_group_commits';
7 connect con1,localhost,root,,;
8 connect con2,localhost,root,,;
9 connect con3,localhost,root,,;
10 connect con4,localhost,root,,;
11 connect con5,localhost,root,,;
12 connect con6,localhost,root,,;
13 connection con1;
14 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL group1_running WAIT_FOR group2_queued";
15 INSERT INTO t1 VALUES ("con1");
16 connection con2;
17 set DEBUG_SYNC= "now WAIT_FOR group1_running";
18 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL group2_con2";
19 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL group2_running";
20 SET DEBUG_SYNC= "commit_after_release_LOCK_log WAIT_FOR group3_committed";
21 SET DEBUG_SYNC= "commit_after_group_run_commit_ordered SIGNAL group2_visible WAIT_FOR group2_checked";
22 INSERT INTO t1 VALUES ("con2");
23 connection con3;
24 SET DEBUG_SYNC= "now WAIT_FOR group2_con2";
25 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL group2_con3";
26 INSERT INTO t1 VALUES ("con3");
27 connection con4;
28 SET DEBUG_SYNC= "now WAIT_FOR group2_con3";
29 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL group2_con4";
30 INSERT INTO t1 VALUES ("con4");
31 connection default;
32 SET DEBUG_SYNC= "now WAIT_FOR group2_con4";
33 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
34 SELECT * FROM t1 ORDER BY a;
35 a
36 100
37 SET DEBUG_SYNC= "now SIGNAL group2_queued";
38 connection con1;
39 connection default;
40 SELECT * FROM t1 ORDER BY a;
41 a
42 100
43 con1
44 connection con5;
45 SET DEBUG_SYNC= "commit_before_get_LOCK_after_binlog_sync SIGNAL group3_con5";
46 SET DEBUG_SYNC= "commit_after_get_LOCK_log SIGNAL con5_leader WAIT_FOR con6_queued";
47 set DEBUG_SYNC= "now WAIT_FOR group2_running";
48 INSERT INTO t1 VALUES ("con5");
49 connection con6;
50 SET DEBUG_SYNC= "now WAIT_FOR con5_leader";
51 SET DEBUG_SYNC= "commit_after_prepare_ordered SIGNAL con6_queued";
52 INSERT INTO t1 VALUES ("con6");
53 connection default;
54 SET DEBUG_SYNC= "now WAIT_FOR group3_con5";
55 SELECT * FROM t1 ORDER BY a;
56 a
57 100
58 con1
59 SET DEBUG_SYNC= "now SIGNAL group3_committed";
60 SET DEBUG_SYNC= "now WAIT_FOR group2_visible";
61 SELECT * FROM t1 ORDER BY a;
62 a
63 100
64 con1
65 con2
66 con3
67 con4
68 SET DEBUG_SYNC= "now SIGNAL group2_checked";
69 connection con2;
70 connection con3;
71 connection con4;
72 connection con5;
73 connection con6;
74 connection default;
75 SELECT * FROM t1 ORDER BY a;
76 a
77 100
78 con1
79 con2
80 con3
81 con4
82 con5
83 con6
84 SELECT variable_value - @commits FROM information_schema.global_status
85 WHERE variable_name = 'binlog_commits';
86 variable_value - @commits
87 6
88 SELECT variable_value - @group_commits FROM information_schema.global_status
89 WHERE variable_name = 'binlog_group_commits';
90 variable_value - @group_commits
91 3
92 SET DEBUG_SYNC= 'RESET';
93 DROP TABLE t1;