Debian Codegraph @

mysql-test/suite/clone/r/local_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 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
141 # In connection con1 - Running Update Random [0 - 100 Key Range]
142 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
143 START TRANSACTION;
144 CALL execute_dml(1, 0, 100, 500, 50, 1);
145 COMMIT;
146 # Flush all dirty buffers
147 SET GLOBAL innodb_buf_flush_list_now = 1;
148 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
149 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
150 START TRANSACTION;
151 CALL execute_dml(1, 0, 100, 300, 50, 1);
152 COMMIT;
153 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
154 # In connection default - Cloning database
155 # Restart cloned database
156 # restart: --datadir=CLONE_DATADIR
157 SHOW CREATE TABLE t1;
158 Table Create Table
159 t1 CREATE TABLE `t1` (
160 `col1` int NOT NULL,
161 `col2` int DEFAULT NULL,
162 `col3` varchar(64) DEFAULT NULL,
163 `col4` blob,
164 PRIMARY KEY (`col1`)
165 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
166 SELECT count(*) from t1;
167 count(*)
168 100
169 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
170 col1 col3 SUBSTRING(col4, 1000, 32)
171 0 Clone Test Row - 0 umn Data Large Column Data Large
172 1 Clone Test Row - 1 umn Data Large Column Data Large
173 2 Clone Test Row - 2 umn Data Large Column Data Large
174 3 Clone Test Row - 3 umn Data Large Column Data Large
175 4 Clone Test Row - 4 umn Data Large Column Data Large
176 5 Clone Test Row - 5 umn Data Large Column Data Large
177 6 Clone Test Row - 6 umn Data Large Column Data Large
178 7 Clone Test Row - 7 umn Data Large Column Data Large
179 8 Clone Test Row - 8 umn Data Large Column Data Large
180 9 Clone Test Row - 9 umn Data Large Column Data Large
181 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
182 col1 col3 SUBSTRING(col4, 1000, 32)
183 99 Clone Test Row - 99 umn Data Large Column Data Large
184 98 Clone Test Row - 98 umn Data Large Column Data Large
185 97 Clone Test Row - 97 umn Data Large Column Data Large
186 96 Clone Test Row - 96 umn Data Large Column Data Large
187 95 Clone Test Row - 95 umn Data Large Column Data Large
188 94 Clone Test Row - 94 umn Data Large Column Data Large
189 93 Clone Test Row - 93 umn Data Large Column Data Large
190 92 Clone Test Row - 92 umn Data Large Column Data Large
191 91 Clone Test Row - 91 umn Data Large Column Data Large
192 90 Clone Test Row - 90 umn Data Large Column Data Large
193 SHOW CREATE TABLE t2;
194 Table Create Table
195 t2 CREATE TABLE `t2` (
196 `col1` int NOT NULL,
197 `col2` int DEFAULT NULL,
198 `col3` varchar(64) DEFAULT NULL,
199 `col4` blob,
200 PRIMARY KEY (`col1`)
201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
202 /*!50100 PARTITION BY KEY (col1)
203 PARTITIONS 5 */
204 SELECT count(*) from t2;
205 count(*)
206 100
207 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
208 col1 col3 SUBSTRING(col4, 1000, 32)
209 0 Clone Test Row - 0 umn Data Large Column Data Large
210 1 Clone Test Row - 1 umn Data Large Column Data Large
211 2 Clone Test Row - 2 umn Data Large Column Data Large
212 3 Clone Test Row - 3 umn Data Large Column Data Large
213 4 Clone Test Row - 4 umn Data Large Column Data Large
214 5 Clone Test Row - 5 umn Data Large Column Data Large
215 6 Clone Test Row - 6 umn Data Large Column Data Large
216 7 Clone Test Row - 7 umn Data Large Column Data Large
217 8 Clone Test Row - 8 umn Data Large Column Data Large
218 9 Clone Test Row - 9 umn Data Large Column Data Large
219 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
220 col1 col3 SUBSTRING(col4, 1000, 32)
221 99 Clone Test Row - 99 umn Data Large Column Data Large
222 98 Clone Test Row - 98 umn Data Large Column Data Large
223 97 Clone Test Row - 97 umn Data Large Column Data Large
224 96 Clone Test Row - 96 umn Data Large Column Data Large
225 95 Clone Test Row - 95 umn Data Large Column Data Large
226 94 Clone Test Row - 94 umn Data Large Column Data Large
227 93 Clone Test Row - 93 umn Data Large Column Data Large
228 92 Clone Test Row - 92 umn Data Large Column Data Large
229 91 Clone Test Row - 91 umn Data Large Column Data Large
230 90 Clone Test Row - 90 umn Data Large Column Data Large
231 call execute_dml(3, 0, 1, 1, 1, 0);
232 call execute_dml(0, 0, 100, 100, 10, 0);
233 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
234 col1 col2 col3 SUBSTRING(col4, 1000, 32)
235 0 0 Clone Test Row - 0 umn Data Large Column Data Large
236 1 10 Clone Test Row - 1 umn Data Large Column Data Large
237 2 20 Clone Test Row - 2 umn Data Large Column Data Large
238 3 30 Clone Test Row - 3 umn Data Large Column Data Large
239 4 40 Clone Test Row - 4 umn Data Large Column Data Large
240 5 50 Clone Test Row - 5 umn Data Large Column Data Large
241 6 60 Clone Test Row - 6 umn Data Large Column Data Large
242 7 70 Clone Test Row - 7 umn Data Large Column Data Large
243 8 80 Clone Test Row - 8 umn Data Large Column Data Large
244 9 90 Clone Test Row - 9 umn Data Large Column Data Large
245 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
246 col1 col2 col3 SUBSTRING(col4, 1000, 32)
247 99 990 Clone Test Row - 99 umn Data Large Column Data Large
248 98 980 Clone Test Row - 98 umn Data Large Column Data Large
249 97 970 Clone Test Row - 97 umn Data Large Column Data Large
250 96 960 Clone Test Row - 96 umn Data Large Column Data Large
251 95 950 Clone Test Row - 95 umn Data Large Column Data Large
252 94 940 Clone Test Row - 94 umn Data Large Column Data Large
253 93 930 Clone Test Row - 93 umn Data Large Column Data Large
254 92 920 Clone Test Row - 92 umn Data Large Column Data Large
255 91 910 Clone Test Row - 91 umn Data Large Column Data Large
256 90 900 Clone Test Row - 90 umn Data Large Column Data Large
257 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
258 col1 col2 col3 SUBSTRING(col4, 1000, 32)
259 0 0 Clone Test Row - 0 umn Data Large Column Data Large
260 1 10 Clone Test Row - 1 umn Data Large Column Data Large
261 2 20 Clone Test Row - 2 umn Data Large Column Data Large
262 3 30 Clone Test Row - 3 umn Data Large Column Data Large
263 4 40 Clone Test Row - 4 umn Data Large Column Data Large
264 5 50 Clone Test Row - 5 umn Data Large Column Data Large
265 6 60 Clone Test Row - 6 umn Data Large Column Data Large
266 7 70 Clone Test Row - 7 umn Data Large Column Data Large
267 8 80 Clone Test Row - 8 umn Data Large Column Data Large
268 9 90 Clone Test Row - 9 umn Data Large Column Data Large
269 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
270 col1 col2 col3 SUBSTRING(col4, 1000, 32)
271 99 990 Clone Test Row - 99 umn Data Large Column Data Large
272 98 980 Clone Test Row - 98 umn Data Large Column Data Large
273 97 970 Clone Test Row - 97 umn Data Large Column Data Large
274 96 960 Clone Test Row - 96 umn Data Large Column Data Large
275 95 950 Clone Test Row - 95 umn Data Large Column Data Large
276 94 940 Clone Test Row - 94 umn Data Large Column Data Large
277 93 930 Clone Test Row - 93 umn Data Large Column Data Large
278 92 920 Clone Test Row - 92 umn Data Large Column Data Large
279 91 910 Clone Test Row - 91 umn Data Large Column Data Large
280 90 900 Clone Test Row - 90 umn Data Large Column Data Large
281 # restart:
282 DROP TABLE t1;
283 DROP TABLE t2;
284 DROP PROCEDURE execute_dml;
285 UNINSTALL PLUGIN clone;
286 SET DEBUG_SYNC = 'RESET';