Debian Codegraph @

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

raw
1 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
2 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
3 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
4 PARTITION BY KEY(col1) PARTITIONS 5;
5 CREATE PROCEDURE execute_dml(
6 p_dml_type INT,
7 p_key_min INT,
8 p_key_range INT,
9 p_loop_count INT,
10 p_frequency INT,
11 p_is_rand INT)
12 BEGIN
13 DECLARE v_idx INT DEFAULT 0;
14 DECLARE v_commit INT DEFAULT 0;
15 DECLARE v_key INT DEFAULT 0;
16 /* Loop and INSERT data at random position */
17 WHILE(v_idx < p_loop_count) DO
18 /* Generate key between 1 to p_loop_count */
19 IF p_is_rand = 1 THEN
20 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
21 ELSE
22 SET v_key = p_key_min + (v_idx % p_key_range);
23 END IF;
24 CASE p_dml_type
25 WHEN 0 THEN
26 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
27 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
28 v_key, v_key * 10,
29 @clol3_text, REPEAT('Large Column Data ', 2048))
30 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
31 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
32 v_key, v_key * 10,
33 @clol3_text, REPEAT('Large Column Data ', 2048))
34 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
35 WHEN 1 THEN
36 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
37 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
38 WHEN 2 THEN
39 DELETE FROM t1 WHERE col1 = v_key;
40 DELETE FROM t2 WHERE col1 = v_key;
41 ELSE
42 DELETE FROM t1;
43 DELETE FROM t2;
44 END CASE;
45 SET v_idx = v_idx + 1;
46 /* Commit or rollback work at specified frequency. */
47 IF v_idx % p_frequency = 0 THEN
48 SET v_commit = FLOOR(RAND() * 2);
49 IF v_commit = 0 AND p_is_rand = 1 THEN
50 ROLLBACK;
51 START TRANSACTION;
52 ELSE
53 COMMIT;
54 START TRANSACTION;
55 END IF;
56 END IF;
57 END WHILE;
58 COMMIT;
59 END|
60 call execute_dml(0, 0, 100, 100, 10, 0);
61 SHOW CREATE TABLE t1;
62 Table Create Table
63 t1 CREATE TABLE `t1` (
64 `col1` int NOT NULL,
65 `col2` int DEFAULT NULL,
66 `col3` varchar(64) DEFAULT NULL,
67 `col4` blob,
68 PRIMARY KEY (`col1`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 SELECT count(*) from t1;
71 count(*)
72 100
73 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
74 col1 col2 col3 SUBSTRING(col4, 1000, 32)
75 0 0 Clone Test Row - 0 umn Data Large Column Data Large
76 1 10 Clone Test Row - 1 umn Data Large Column Data Large
77 2 20 Clone Test Row - 2 umn Data Large Column Data Large
78 3 30 Clone Test Row - 3 umn Data Large Column Data Large
79 4 40 Clone Test Row - 4 umn Data Large Column Data Large
80 5 50 Clone Test Row - 5 umn Data Large Column Data Large
81 6 60 Clone Test Row - 6 umn Data Large Column Data Large
82 7 70 Clone Test Row - 7 umn Data Large Column Data Large
83 8 80 Clone Test Row - 8 umn Data Large Column Data Large
84 9 90 Clone Test Row - 9 umn Data Large Column Data Large
85 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
86 col1 col2 col3 SUBSTRING(col4, 1000, 32)
87 99 990 Clone Test Row - 99 umn Data Large Column Data Large
88 98 980 Clone Test Row - 98 umn Data Large Column Data Large
89 97 970 Clone Test Row - 97 umn Data Large Column Data Large
90 96 960 Clone Test Row - 96 umn Data Large Column Data Large
91 95 950 Clone Test Row - 95 umn Data Large Column Data Large
92 94 940 Clone Test Row - 94 umn Data Large Column Data Large
93 93 930 Clone Test Row - 93 umn Data Large Column Data Large
94 92 920 Clone Test Row - 92 umn Data Large Column Data Large
95 91 910 Clone Test Row - 91 umn Data Large Column Data Large
96 90 900 Clone Test Row - 90 umn Data Large Column Data Large
97 SHOW CREATE TABLE t2;
98 Table Create Table
99 t2 CREATE TABLE `t2` (
100 `col1` int NOT NULL,
101 `col2` int DEFAULT NULL,
102 `col3` varchar(64) DEFAULT NULL,
103 `col4` blob,
104 PRIMARY KEY (`col1`)
105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
106 /*!50100 PARTITION BY KEY (col1)
107 PARTITIONS 5 */
108 SELECT count(*) from t2;
109 count(*)
110 100
111 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
112 col1 col2 col3 SUBSTRING(col4, 1000, 32)
113 0 0 Clone Test Row - 0 umn Data Large Column Data Large
114 1 10 Clone Test Row - 1 umn Data Large Column Data Large
115 2 20 Clone Test Row - 2 umn Data Large Column Data Large
116 3 30 Clone Test Row - 3 umn Data Large Column Data Large
117 4 40 Clone Test Row - 4 umn Data Large Column Data Large
118 5 50 Clone Test Row - 5 umn Data Large Column Data Large
119 6 60 Clone Test Row - 6 umn Data Large Column Data Large
120 7 70 Clone Test Row - 7 umn Data Large Column Data Large
121 8 80 Clone Test Row - 8 umn Data Large Column Data Large
122 9 90 Clone Test Row - 9 umn Data Large Column Data Large
123 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
124 col1 col2 col3 SUBSTRING(col4, 1000, 32)
125 99 990 Clone Test Row - 99 umn Data Large Column Data Large
126 98 980 Clone Test Row - 98 umn Data Large Column Data Large
127 97 970 Clone Test Row - 97 umn Data Large Column Data Large
128 96 960 Clone Test Row - 96 umn Data Large Column Data Large
129 95 950 Clone Test Row - 95 umn Data Large Column Data Large
130 94 940 Clone Test Row - 94 umn Data Large Column Data Large
131 93 930 Clone Test Row - 93 umn Data Large Column Data Large
132 92 920 Clone Test Row - 92 umn Data Large Column Data Large
133 91 910 Clone Test Row - 91 umn Data Large Column Data Large
134 90 900 Clone Test Row - 90 umn Data Large Column Data Large
135 # In connection default - Cloning database
136 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
137 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
138 SET GLOBAL clone_autotune_concurrency = OFF;
139 SET GLOBAL clone_max_concurrency = 8;
140 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
141 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
142 # In connection con1 - Running Update Random [0 - 100 Key Range]
143 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
144 START TRANSACTION;
145 CALL execute_dml(1, 0, 100, 500, 50, 1);
146 COMMIT;
147 # Flush all dirty buffers
148 SET GLOBAL innodb_buf_flush_list_now = 1;
149 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
150 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
151 START TRANSACTION;
152 CALL execute_dml(1, 0, 100, 300, 50, 1);
153 COMMIT;
154 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
155 # In connection default - Cloning database
156 # Restart cloned database
157 # restart: --datadir=CLONE_DATADIR
158 SHOW CREATE TABLE t1;
159 Table Create Table
160 t1 CREATE TABLE `t1` (
161 `col1` int NOT NULL,
162 `col2` int DEFAULT NULL,
163 `col3` varchar(64) DEFAULT NULL,
164 `col4` blob,
165 PRIMARY KEY (`col1`)
166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 SELECT count(*) from t1;
168 count(*)
169 100
170 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
171 col1 col3 SUBSTRING(col4, 1000, 32)
172 0 Clone Test Row - 0 umn Data Large Column Data Large
173 1 Clone Test Row - 1 umn Data Large Column Data Large
174 2 Clone Test Row - 2 umn Data Large Column Data Large
175 3 Clone Test Row - 3 umn Data Large Column Data Large
176 4 Clone Test Row - 4 umn Data Large Column Data Large
177 5 Clone Test Row - 5 umn Data Large Column Data Large
178 6 Clone Test Row - 6 umn Data Large Column Data Large
179 7 Clone Test Row - 7 umn Data Large Column Data Large
180 8 Clone Test Row - 8 umn Data Large Column Data Large
181 9 Clone Test Row - 9 umn Data Large Column Data Large
182 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
183 col1 col3 SUBSTRING(col4, 1000, 32)
184 99 Clone Test Row - 99 umn Data Large Column Data Large
185 98 Clone Test Row - 98 umn Data Large Column Data Large
186 97 Clone Test Row - 97 umn Data Large Column Data Large
187 96 Clone Test Row - 96 umn Data Large Column Data Large
188 95 Clone Test Row - 95 umn Data Large Column Data Large
189 94 Clone Test Row - 94 umn Data Large Column Data Large
190 93 Clone Test Row - 93 umn Data Large Column Data Large
191 92 Clone Test Row - 92 umn Data Large Column Data Large
192 91 Clone Test Row - 91 umn Data Large Column Data Large
193 90 Clone Test Row - 90 umn Data Large Column Data Large
194 SHOW CREATE TABLE t2;
195 Table Create Table
196 t2 CREATE TABLE `t2` (
197 `col1` int NOT NULL,
198 `col2` int DEFAULT NULL,
199 `col3` varchar(64) DEFAULT NULL,
200 `col4` blob,
201 PRIMARY KEY (`col1`)
202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
203 /*!50100 PARTITION BY KEY (col1)
204 PARTITIONS 5 */
205 SELECT count(*) from t2;
206 count(*)
207 100
208 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
209 col1 col3 SUBSTRING(col4, 1000, 32)
210 0 Clone Test Row - 0 umn Data Large Column Data Large
211 1 Clone Test Row - 1 umn Data Large Column Data Large
212 2 Clone Test Row - 2 umn Data Large Column Data Large
213 3 Clone Test Row - 3 umn Data Large Column Data Large
214 4 Clone Test Row - 4 umn Data Large Column Data Large
215 5 Clone Test Row - 5 umn Data Large Column Data Large
216 6 Clone Test Row - 6 umn Data Large Column Data Large
217 7 Clone Test Row - 7 umn Data Large Column Data Large
218 8 Clone Test Row - 8 umn Data Large Column Data Large
219 9 Clone Test Row - 9 umn Data Large Column Data Large
220 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
221 col1 col3 SUBSTRING(col4, 1000, 32)
222 99 Clone Test Row - 99 umn Data Large Column Data Large
223 98 Clone Test Row - 98 umn Data Large Column Data Large
224 97 Clone Test Row - 97 umn Data Large Column Data Large
225 96 Clone Test Row - 96 umn Data Large Column Data Large
226 95 Clone Test Row - 95 umn Data Large Column Data Large
227 94 Clone Test Row - 94 umn Data Large Column Data Large
228 93 Clone Test Row - 93 umn Data Large Column Data Large
229 92 Clone Test Row - 92 umn Data Large Column Data Large
230 91 Clone Test Row - 91 umn Data Large Column Data Large
231 90 Clone Test Row - 90 umn Data Large Column Data Large
232 call execute_dml(3, 0, 1, 1, 1, 0);
233 call execute_dml(0, 0, 100, 100, 10, 0);
234 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
235 col1 col2 col3 SUBSTRING(col4, 1000, 32)
236 0 0 Clone Test Row - 0 umn Data Large Column Data Large
237 1 10 Clone Test Row - 1 umn Data Large Column Data Large
238 2 20 Clone Test Row - 2 umn Data Large Column Data Large
239 3 30 Clone Test Row - 3 umn Data Large Column Data Large
240 4 40 Clone Test Row - 4 umn Data Large Column Data Large
241 5 50 Clone Test Row - 5 umn Data Large Column Data Large
242 6 60 Clone Test Row - 6 umn Data Large Column Data Large
243 7 70 Clone Test Row - 7 umn Data Large Column Data Large
244 8 80 Clone Test Row - 8 umn Data Large Column Data Large
245 9 90 Clone Test Row - 9 umn Data Large Column Data Large
246 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
247 col1 col2 col3 SUBSTRING(col4, 1000, 32)
248 99 990 Clone Test Row - 99 umn Data Large Column Data Large
249 98 980 Clone Test Row - 98 umn Data Large Column Data Large
250 97 970 Clone Test Row - 97 umn Data Large Column Data Large
251 96 960 Clone Test Row - 96 umn Data Large Column Data Large
252 95 950 Clone Test Row - 95 umn Data Large Column Data Large
253 94 940 Clone Test Row - 94 umn Data Large Column Data Large
254 93 930 Clone Test Row - 93 umn Data Large Column Data Large
255 92 920 Clone Test Row - 92 umn Data Large Column Data Large
256 91 910 Clone Test Row - 91 umn Data Large Column Data Large
257 90 900 Clone Test Row - 90 umn Data Large Column Data Large
258 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
259 col1 col2 col3 SUBSTRING(col4, 1000, 32)
260 0 0 Clone Test Row - 0 umn Data Large Column Data Large
261 1 10 Clone Test Row - 1 umn Data Large Column Data Large
262 2 20 Clone Test Row - 2 umn Data Large Column Data Large
263 3 30 Clone Test Row - 3 umn Data Large Column Data Large
264 4 40 Clone Test Row - 4 umn Data Large Column Data Large
265 5 50 Clone Test Row - 5 umn Data Large Column Data Large
266 6 60 Clone Test Row - 6 umn Data Large Column Data Large
267 7 70 Clone Test Row - 7 umn Data Large Column Data Large
268 8 80 Clone Test Row - 8 umn Data Large Column Data Large
269 9 90 Clone Test Row - 9 umn Data Large Column Data Large
270 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
271 col1 col2 col3 SUBSTRING(col4, 1000, 32)
272 99 990 Clone Test Row - 99 umn Data Large Column Data Large
273 98 980 Clone Test Row - 98 umn Data Large Column Data Large
274 97 970 Clone Test Row - 97 umn Data Large Column Data Large
275 96 960 Clone Test Row - 96 umn Data Large Column Data Large
276 95 950 Clone Test Row - 95 umn Data Large Column Data Large
277 94 940 Clone Test Row - 94 umn Data Large Column Data Large
278 93 930 Clone Test Row - 93 umn Data Large Column Data Large
279 92 920 Clone Test Row - 92 umn Data Large Column Data Large
280 91 910 Clone Test Row - 91 umn Data Large Column Data Large
281 90 900 Clone Test Row - 90 umn Data Large Column Data Large
282 # restart:
283 DROP TABLE t1;
284 DROP TABLE t2;
285 DROP PROCEDURE execute_dml;
286 UNINSTALL PLUGIN clone;
287 SET DEBUG_SYNC = 'RESET';