Debian Codegraph @

mysql-test/suite/clone/r/local_insert.result

raw
1 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
2 CREATE PROCEDURE prepare_data(IN val INT)
3 BEGIN
4 DECLARE i INT DEFAULT 1;
5 WHILE i <= val DO
6 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
7 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
8 SET i = i + 1;
9 END WHILE;
10 END|
11 # Case 1 - Normal page archiving process using clone client.
12 CREATE TABLE t1 (a INT AUTO_INCREMENT, b LONGBLOB, c LONGBLOB, key k1(a));
13 CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
14 SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page';
15 SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo';
16 SET DEBUG_SYNC = 'clone_donor_after_saving_dynamic_metadata SIGNAL meta_signal WAIT_FOR go_meta';
17 SET GLOBAL clone_autotune_concurrency = OFF;
18 SET GLOBAL clone_max_concurrency = 8;
19 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
20 SET DEBUG_SYNC = 'now WAIT_FOR page_signal';
21 CALL prepare_data(50);
22 SET DEBUG_SYNC = 'now SIGNAL go_page';
23 SET DEBUG_SYNC = 'now WAIT_FOR redo_signal';
24 CALL prepare_data(10);
25 SET DEBUG_SYNC = 'now SIGNAL go_redo';
26 SET DEBUG_SYNC = 'now WAIT_FOR meta_signal';
27 SET GLOBAL debug="+d,periodical_checkpoint_disabled";
28 CALL prepare_data(10);
29 UPDATE t1 SET a = 100 where a = 1;
30 UPDATE t2 SET a = 200 where a = 1;
31 SET DEBUG_SYNC = 'now SIGNAL go_meta';
32 select count(*) from t1;
33 count(*)
34 70
35 select count(*) from t2;
36 count(*)
37 70
38 # restart: --datadir=CLONE_DATADIR
39 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
40 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
41 select count(*), max(a) from t1;
42 count(*) max(a)
43 71 101
44 select count(*), max(a) from t2;
45 count(*) max(a)
46 71 201
47 # restart:
48 DROP TABLE t1;
49 DROP TABLE t2;
50 SET DEBUG_SYNC = 'RESET';
51 DROP PROCEDURE prepare_data;
52 UNINSTALL PLUGIN clone;