Debian Codegraph @

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

raw
1 # Prepare for creating Encrypted Table
2 # create bootstrap file
3 # Create and start mysqld with keyring plugin.
4 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
5 ## Install plugin
6 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
7 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
8 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
9 PARTITION BY KEY(col1) PARTITIONS 5;
10 CREATE PROCEDURE execute_dml(
11 p_dml_type INT,
12 p_key_min INT,
13 p_key_range INT,
14 p_loop_count INT,
15 p_frequency INT,
16 p_is_rand INT)
17 BEGIN
18 DECLARE v_idx INT DEFAULT 0;
19 DECLARE v_commit INT DEFAULT 0;
20 DECLARE v_key INT DEFAULT 0;
21 /* Loop and INSERT data at random position */
22 WHILE(v_idx < p_loop_count) DO
23 /* Generate key between 1 to p_loop_count */
24 IF p_is_rand = 1 THEN
25 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
26 ELSE
27 SET v_key = p_key_min + (v_idx % p_key_range);
28 END IF;
29 CASE p_dml_type
30 WHEN 0 THEN
31 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
32 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
33 v_key, v_key * 10,
34 @clol3_text, REPEAT('Large Column Data ', 2048))
35 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
36 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
37 v_key, v_key * 10,
38 @clol3_text, REPEAT('Large Column Data ', 2048))
39 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
40 WHEN 1 THEN
41 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
42 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
43 WHEN 2 THEN
44 DELETE FROM t1 WHERE col1 = v_key;
45 DELETE FROM t2 WHERE col1 = v_key;
46 ELSE
47 DELETE FROM t1;
48 DELETE FROM t2;
49 END CASE;
50 SET v_idx = v_idx + 1;
51 /* Commit or rollback work at specified frequency. */
52 IF v_idx % p_frequency = 0 THEN
53 SET v_commit = FLOOR(RAND() * 2);
54 IF v_commit = 0 AND p_is_rand = 1 THEN
55 ROLLBACK;
56 START TRANSACTION;
57 ELSE
58 COMMIT;
59 START TRANSACTION;
60 END IF;
61 END IF;
62 END WHILE;
63 COMMIT;
64 END|
65 DROP TABLE t1;
66 DROP TABLE t2;
67 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
68 COMPRESSION = "LZ4" ENCRYPTION = "Y";
69 CREATE TABLESPACE tbs1 ADD DATAFILE 'tbs1_data1.ibd' ENCRYPTION="Y";
70 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
71 COMPRESSION = "ZLIB";
72 call execute_dml(0, 0, 200, 200, 100, 0);
73 SHOW CREATE TABLE t1;
74 Table Create Table
75 t1 CREATE TABLE `t1` (
76 `col1` int NOT NULL,
77 `col2` int DEFAULT NULL,
78 `col3` varchar(64) DEFAULT NULL,
79 `col4` blob,
80 PRIMARY KEY (`col1`)
81 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' ENCRYPTION='Y'
82 SELECT count(*) from t1;
83 count(*)
84 200
85 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
86 col1 col2 col3 SUBSTRING(col4, 1000, 32)
87 0 0 Clone Test Row - 0 umn Data Large Column Data Large
88 1 10 Clone Test Row - 1 umn Data Large Column Data Large
89 2 20 Clone Test Row - 2 umn Data Large Column Data Large
90 3 30 Clone Test Row - 3 umn Data Large Column Data Large
91 4 40 Clone Test Row - 4 umn Data Large Column Data Large
92 5 50 Clone Test Row - 5 umn Data Large Column Data Large
93 6 60 Clone Test Row - 6 umn Data Large Column Data Large
94 7 70 Clone Test Row - 7 umn Data Large Column Data Large
95 8 80 Clone Test Row - 8 umn Data Large Column Data Large
96 9 90 Clone Test Row - 9 umn Data Large Column Data Large
97 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
98 col1 col2 col3 SUBSTRING(col4, 1000, 32)
99 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
100 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
101 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
102 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
103 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
104 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
105 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
106 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
107 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
108 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
109 SHOW CREATE TABLE t2;
110 Table Create Table
111 t2 CREATE TABLE `t2` (
112 `col1` int NOT NULL,
113 `col2` int DEFAULT NULL,
114 `col3` varchar(64) DEFAULT NULL,
115 `col4` blob,
116 PRIMARY KEY (`col1`)
117 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'
118 SELECT count(*) from t2;
119 count(*)
120 200
121 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
122 col1 col2 col3 SUBSTRING(col4, 1000, 32)
123 0 0 Clone Test Row - 0 umn Data Large Column Data Large
124 1 10 Clone Test Row - 1 umn Data Large Column Data Large
125 2 20 Clone Test Row - 2 umn Data Large Column Data Large
126 3 30 Clone Test Row - 3 umn Data Large Column Data Large
127 4 40 Clone Test Row - 4 umn Data Large Column Data Large
128 5 50 Clone Test Row - 5 umn Data Large Column Data Large
129 6 60 Clone Test Row - 6 umn Data Large Column Data Large
130 7 70 Clone Test Row - 7 umn Data Large Column Data Large
131 8 80 Clone Test Row - 8 umn Data Large Column Data Large
132 9 90 Clone Test Row - 9 umn Data Large Column Data Large
133 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
134 col1 col2 col3 SUBSTRING(col4, 1000, 32)
135 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
136 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
137 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
138 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
139 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
140 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
141 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
142 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
143 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
144 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
145 SET GLOBAL innodb_buf_flush_list_now = 1;
146 SET GLOBAL clone_autotune_concurrency = OFF;
147 SET GLOBAL clone_max_concurrency = 8;
148 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
149 select ID, STATE, ERROR_NO from performance_schema.clone_status;
150 ID STATE ERROR_NO
151 1 Completed 0
152 select ID, STAGE, STATE from performance_schema.clone_progress;
153 ID STAGE STATE
154 1 DROP DATA Completed
155 1 FILE COPY Completed
156 1 PAGE COPY Completed
157 1 REDO COPY Completed
158 1 FILE SYNC Completed
159 1 RESTART Not Started
160 1 RECOVERY Not Started
161 # Restart cloned database
162 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
163 SHOW CREATE TABLE t1;
164 Table Create Table
165 t1 CREATE TABLE `t1` (
166 `col1` int NOT NULL,
167 `col2` int DEFAULT NULL,
168 `col3` varchar(64) DEFAULT NULL,
169 `col4` blob,
170 PRIMARY KEY (`col1`)
171 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' ENCRYPTION='Y'
172 SELECT count(*) from t1;
173 count(*)
174 200
175 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
176 col1 col3 SUBSTRING(col4, 1000, 32)
177 0 Clone Test Row - 0 umn Data Large Column Data Large
178 1 Clone Test Row - 1 umn Data Large Column Data Large
179 2 Clone Test Row - 2 umn Data Large Column Data Large
180 3 Clone Test Row - 3 umn Data Large Column Data Large
181 4 Clone Test Row - 4 umn Data Large Column Data Large
182 5 Clone Test Row - 5 umn Data Large Column Data Large
183 6 Clone Test Row - 6 umn Data Large Column Data Large
184 7 Clone Test Row - 7 umn Data Large Column Data Large
185 8 Clone Test Row - 8 umn Data Large Column Data Large
186 9 Clone Test Row - 9 umn Data Large Column Data Large
187 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
188 col1 col3 SUBSTRING(col4, 1000, 32)
189 199 Clone Test Row - 199 umn Data Large Column Data Large
190 198 Clone Test Row - 198 umn Data Large Column Data Large
191 197 Clone Test Row - 197 umn Data Large Column Data Large
192 196 Clone Test Row - 196 umn Data Large Column Data Large
193 195 Clone Test Row - 195 umn Data Large Column Data Large
194 194 Clone Test Row - 194 umn Data Large Column Data Large
195 193 Clone Test Row - 193 umn Data Large Column Data Large
196 192 Clone Test Row - 192 umn Data Large Column Data Large
197 191 Clone Test Row - 191 umn Data Large Column Data Large
198 190 Clone Test Row - 190 umn Data Large Column Data Large
199 SHOW CREATE TABLE t2;
200 Table Create Table
201 t2 CREATE TABLE `t2` (
202 `col1` int NOT NULL,
203 `col2` int DEFAULT NULL,
204 `col3` varchar(64) DEFAULT NULL,
205 `col4` blob,
206 PRIMARY KEY (`col1`)
207 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'
208 SELECT count(*) from t2;
209 count(*)
210 200
211 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
212 col1 col3 SUBSTRING(col4, 1000, 32)
213 0 Clone Test Row - 0 umn Data Large Column Data Large
214 1 Clone Test Row - 1 umn Data Large Column Data Large
215 2 Clone Test Row - 2 umn Data Large Column Data Large
216 3 Clone Test Row - 3 umn Data Large Column Data Large
217 4 Clone Test Row - 4 umn Data Large Column Data Large
218 5 Clone Test Row - 5 umn Data Large Column Data Large
219 6 Clone Test Row - 6 umn Data Large Column Data Large
220 7 Clone Test Row - 7 umn Data Large Column Data Large
221 8 Clone Test Row - 8 umn Data Large Column Data Large
222 9 Clone Test Row - 9 umn Data Large Column Data Large
223 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
224 col1 col3 SUBSTRING(col4, 1000, 32)
225 199 Clone Test Row - 199 umn Data Large Column Data Large
226 198 Clone Test Row - 198 umn Data Large Column Data Large
227 197 Clone Test Row - 197 umn Data Large Column Data Large
228 196 Clone Test Row - 196 umn Data Large Column Data Large
229 195 Clone Test Row - 195 umn Data Large Column Data Large
230 194 Clone Test Row - 194 umn Data Large Column Data Large
231 193 Clone Test Row - 193 umn Data Large Column Data Large
232 192 Clone Test Row - 192 umn Data Large Column Data Large
233 191 Clone Test Row - 191 umn Data Large Column Data Large
234 190 Clone Test Row - 190 umn Data Large Column Data Large
235 call execute_dml(3, 0, 1, 1, 1, 0);
236 call execute_dml(0, 0, 200, 200, 100, 0);
237 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
238 col1 col2 col3 SUBSTRING(col4, 1000, 32)
239 0 0 Clone Test Row - 0 umn Data Large Column Data Large
240 1 10 Clone Test Row - 1 umn Data Large Column Data Large
241 2 20 Clone Test Row - 2 umn Data Large Column Data Large
242 3 30 Clone Test Row - 3 umn Data Large Column Data Large
243 4 40 Clone Test Row - 4 umn Data Large Column Data Large
244 5 50 Clone Test Row - 5 umn Data Large Column Data Large
245 6 60 Clone Test Row - 6 umn Data Large Column Data Large
246 7 70 Clone Test Row - 7 umn Data Large Column Data Large
247 8 80 Clone Test Row - 8 umn Data Large Column Data Large
248 9 90 Clone Test Row - 9 umn Data Large Column Data Large
249 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
250 col1 col2 col3 SUBSTRING(col4, 1000, 32)
251 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
252 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
253 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
254 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
255 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
256 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
257 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
258 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
259 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
260 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
261 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
262 col1 col2 col3 SUBSTRING(col4, 1000, 32)
263 0 0 Clone Test Row - 0 umn Data Large Column Data Large
264 1 10 Clone Test Row - 1 umn Data Large Column Data Large
265 2 20 Clone Test Row - 2 umn Data Large Column Data Large
266 3 30 Clone Test Row - 3 umn Data Large Column Data Large
267 4 40 Clone Test Row - 4 umn Data Large Column Data Large
268 5 50 Clone Test Row - 5 umn Data Large Column Data Large
269 6 60 Clone Test Row - 6 umn Data Large Column Data Large
270 7 70 Clone Test Row - 7 umn Data Large Column Data Large
271 8 80 Clone Test Row - 8 umn Data Large Column Data Large
272 9 90 Clone Test Row - 9 umn Data Large Column Data Large
273 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
274 SET GLOBAL innodb_redo_log_encrypt = ON;
275 SET GLOBAL innodb_undo_log_encrypt = ON;
276 # In connection default - Cloning database
277 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
278 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
279 SET GLOBAL clone_autotune_concurrency = OFF;
280 SET GLOBAL clone_max_concurrency = 8;
281 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
282 # In connection con1 - Running Update Random [0 - 200 Key Range]
283 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
284 START TRANSACTION;
285 CALL execute_dml(1, 0, 200, 500, 100, 1);
286 COMMIT;
287 # Flush all dirty buffers
288 SET GLOBAL innodb_buf_flush_list_now = 1;
289 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
290 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
291 START TRANSACTION;
292 CALL execute_dml(1, 0, 200, 500, 100, 1);
293 COMMIT;
294 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
295 # In connection default - Cloning database
296 # Restart cloned database
297 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
298 SHOW CREATE TABLE t1;
299 Table Create Table
300 t1 CREATE TABLE `t1` (
301 `col1` int NOT NULL,
302 `col2` int DEFAULT NULL,
303 `col3` varchar(64) DEFAULT NULL,
304 `col4` blob,
305 PRIMARY KEY (`col1`)
306 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' ENCRYPTION='Y'
307 SELECT count(*) from t1;
308 count(*)
309 200
310 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
311 col1 col3 SUBSTRING(col4, 1000, 32)
312 0 Clone Test Row - 0 umn Data Large Column Data Large
313 1 Clone Test Row - 1 umn Data Large Column Data Large
314 2 Clone Test Row - 2 umn Data Large Column Data Large
315 3 Clone Test Row - 3 umn Data Large Column Data Large
316 4 Clone Test Row - 4 umn Data Large Column Data Large
317 5 Clone Test Row - 5 umn Data Large Column Data Large
318 6 Clone Test Row - 6 umn Data Large Column Data Large
319 7 Clone Test Row - 7 umn Data Large Column Data Large
320 8 Clone Test Row - 8 umn Data Large Column Data Large
321 9 Clone Test Row - 9 umn Data Large Column Data Large
322 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
323 col1 col3 SUBSTRING(col4, 1000, 32)
324 199 Clone Test Row - 199 umn Data Large Column Data Large
325 198 Clone Test Row - 198 umn Data Large Column Data Large
326 197 Clone Test Row - 197 umn Data Large Column Data Large
327 196 Clone Test Row - 196 umn Data Large Column Data Large
328 195 Clone Test Row - 195 umn Data Large Column Data Large
329 194 Clone Test Row - 194 umn Data Large Column Data Large
330 193 Clone Test Row - 193 umn Data Large Column Data Large
331 192 Clone Test Row - 192 umn Data Large Column Data Large
332 191 Clone Test Row - 191 umn Data Large Column Data Large
333 190 Clone Test Row - 190 umn Data Large Column Data Large
334 SHOW CREATE TABLE t2;
335 Table Create Table
336 t2 CREATE TABLE `t2` (
337 `col1` int NOT NULL,
338 `col2` int DEFAULT NULL,
339 `col3` varchar(64) DEFAULT NULL,
340 `col4` blob,
341 PRIMARY KEY (`col1`)
342 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'
343 SELECT count(*) from t2;
344 count(*)
345 200
346 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
347 col1 col3 SUBSTRING(col4, 1000, 32)
348 0 Clone Test Row - 0 umn Data Large Column Data Large
349 1 Clone Test Row - 1 umn Data Large Column Data Large
350 2 Clone Test Row - 2 umn Data Large Column Data Large
351 3 Clone Test Row - 3 umn Data Large Column Data Large
352 4 Clone Test Row - 4 umn Data Large Column Data Large
353 5 Clone Test Row - 5 umn Data Large Column Data Large
354 6 Clone Test Row - 6 umn Data Large Column Data Large
355 7 Clone Test Row - 7 umn Data Large Column Data Large
356 8 Clone Test Row - 8 umn Data Large Column Data Large
357 9 Clone Test Row - 9 umn Data Large Column Data Large
358 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
359 col1 col3 SUBSTRING(col4, 1000, 32)
360 199 Clone Test Row - 199 umn Data Large Column Data Large
361 198 Clone Test Row - 198 umn Data Large Column Data Large
362 197 Clone Test Row - 197 umn Data Large Column Data Large
363 196 Clone Test Row - 196 umn Data Large Column Data Large
364 195 Clone Test Row - 195 umn Data Large Column Data Large
365 194 Clone Test Row - 194 umn Data Large Column Data Large
366 193 Clone Test Row - 193 umn Data Large Column Data Large
367 192 Clone Test Row - 192 umn Data Large Column Data Large
368 191 Clone Test Row - 191 umn Data Large Column Data Large
369 190 Clone Test Row - 190 umn Data Large Column Data Large
370 call execute_dml(3, 0, 1, 1, 1, 0);
371 call execute_dml(0, 0, 200, 200, 100, 0);
372 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
373 col1 col2 col3 SUBSTRING(col4, 1000, 32)
374 0 0 Clone Test Row - 0 umn Data Large Column Data Large
375 1 10 Clone Test Row - 1 umn Data Large Column Data Large
376 2 20 Clone Test Row - 2 umn Data Large Column Data Large
377 3 30 Clone Test Row - 3 umn Data Large Column Data Large
378 4 40 Clone Test Row - 4 umn Data Large Column Data Large
379 5 50 Clone Test Row - 5 umn Data Large Column Data Large
380 6 60 Clone Test Row - 6 umn Data Large Column Data Large
381 7 70 Clone Test Row - 7 umn Data Large Column Data Large
382 8 80 Clone Test Row - 8 umn Data Large Column Data Large
383 9 90 Clone Test Row - 9 umn Data Large Column Data Large
384 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
385 col1 col2 col3 SUBSTRING(col4, 1000, 32)
386 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
387 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
388 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
389 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
390 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
391 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
392 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
393 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
394 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
395 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
396 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
397 col1 col2 col3 SUBSTRING(col4, 1000, 32)
398 0 0 Clone Test Row - 0 umn Data Large Column Data Large
399 1 10 Clone Test Row - 1 umn Data Large Column Data Large
400 2 20 Clone Test Row - 2 umn Data Large Column Data Large
401 3 30 Clone Test Row - 3 umn Data Large Column Data Large
402 4 40 Clone Test Row - 4 umn Data Large Column Data Large
403 5 50 Clone Test Row - 5 umn Data Large Column Data Large
404 6 60 Clone Test Row - 6 umn Data Large Column Data Large
405 7 70 Clone Test Row - 7 umn Data Large Column Data Large
406 8 80 Clone Test Row - 8 umn Data Large Column Data Large
407 9 90 Clone Test Row - 9 umn Data Large Column Data Large
408 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
409 col1 col2 col3 SUBSTRING(col4, 1000, 32)
410 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
411 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
412 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
413 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
414 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
415 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
416 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
417 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
418 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
419 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
420 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
421 DROP TABLE t1;
422 DROP TABLE t2;
423 DROP PROCEDURE execute_dml;
424 DROP TABLESPACE tbs1;
425 UNINSTALL PLUGIN clone;
426 UNINSTALL PLUGIN keyring_file;
427 SET DEBUG_SYNC = 'RESET';
428 # Restart server and remove encrypted data directory
429 # restart: