Debian Codegraph @

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

raw
1 CREATE TABLE t(id INT PRIMARY KEY, v INT NOT NULL) ENGINE INNODB;
2 INSERT INTO t VALUES(1, 100), (2, 100), (3, 100), (4, 100);
3 SET GLOBAL binlog_group_commit_sync_delay = 8;
4 SET GLOBAL binlog_group_commit_sync_no_delay_count = 2;
5 BEGIN;
6 UPDATE t set v = v + 100 WHERE id = 1;
7 COMMIT;
8 SET GLOBAL binlog_group_commit_sync_delay = 8;
9 SET GLOBAL binlog_group_commit_sync_no_delay_count = 0;
10 BEGIN;
11 UPDATE t set v = v + 100 WHERE id = 3;
12 COMMIT;
13 SET GLOBAL binlog_group_commit_sync_delay=0;
14 DROP TABLE t;