Debian Codegraph @

mysql-test/suite/clone/r/remote_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 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
149 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
150 select ID, STATE, ERROR_NO from performance_schema.clone_status;
151 ID STATE ERROR_NO
152 1 Completed 0
153 select ID, STAGE, STATE from performance_schema.clone_progress;
154 ID STAGE STATE
155 1 DROP DATA Completed
156 1 FILE COPY Completed
157 1 PAGE COPY Completed
158 1 REDO COPY Completed
159 1 FILE SYNC Completed
160 1 RESTART Not Started
161 1 RECOVERY Not Started
162 # Restart cloned database
163 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
164 SHOW CREATE TABLE t1;
165 Table Create Table
166 t1 CREATE TABLE `t1` (
167 `col1` int NOT NULL,
168 `col2` int DEFAULT NULL,
169 `col3` varchar(64) DEFAULT NULL,
170 `col4` blob,
171 PRIMARY KEY (`col1`)
172 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' ENCRYPTION='Y'
173 SELECT count(*) from t1;
174 count(*)
175 200
176 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
177 col1 col3 SUBSTRING(col4, 1000, 32)
178 0 Clone Test Row - 0 umn Data Large Column Data Large
179 1 Clone Test Row - 1 umn Data Large Column Data Large
180 2 Clone Test Row - 2 umn Data Large Column Data Large
181 3 Clone Test Row - 3 umn Data Large Column Data Large
182 4 Clone Test Row - 4 umn Data Large Column Data Large
183 5 Clone Test Row - 5 umn Data Large Column Data Large
184 6 Clone Test Row - 6 umn Data Large Column Data Large
185 7 Clone Test Row - 7 umn Data Large Column Data Large
186 8 Clone Test Row - 8 umn Data Large Column Data Large
187 9 Clone Test Row - 9 umn Data Large Column Data Large
188 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
189 col1 col3 SUBSTRING(col4, 1000, 32)
190 199 Clone Test Row - 199 umn Data Large Column Data Large
191 198 Clone Test Row - 198 umn Data Large Column Data Large
192 197 Clone Test Row - 197 umn Data Large Column Data Large
193 196 Clone Test Row - 196 umn Data Large Column Data Large
194 195 Clone Test Row - 195 umn Data Large Column Data Large
195 194 Clone Test Row - 194 umn Data Large Column Data Large
196 193 Clone Test Row - 193 umn Data Large Column Data Large
197 192 Clone Test Row - 192 umn Data Large Column Data Large
198 191 Clone Test Row - 191 umn Data Large Column Data Large
199 190 Clone Test Row - 190 umn Data Large Column Data Large
200 SHOW CREATE TABLE t2;
201 Table Create Table
202 t2 CREATE TABLE `t2` (
203 `col1` int NOT NULL,
204 `col2` int DEFAULT NULL,
205 `col3` varchar(64) DEFAULT NULL,
206 `col4` blob,
207 PRIMARY KEY (`col1`)
208 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'
209 SELECT count(*) from t2;
210 count(*)
211 200
212 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
213 col1 col3 SUBSTRING(col4, 1000, 32)
214 0 Clone Test Row - 0 umn Data Large Column Data Large
215 1 Clone Test Row - 1 umn Data Large Column Data Large
216 2 Clone Test Row - 2 umn Data Large Column Data Large
217 3 Clone Test Row - 3 umn Data Large Column Data Large
218 4 Clone Test Row - 4 umn Data Large Column Data Large
219 5 Clone Test Row - 5 umn Data Large Column Data Large
220 6 Clone Test Row - 6 umn Data Large Column Data Large
221 7 Clone Test Row - 7 umn Data Large Column Data Large
222 8 Clone Test Row - 8 umn Data Large Column Data Large
223 9 Clone Test Row - 9 umn Data Large Column Data Large
224 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
225 col1 col3 SUBSTRING(col4, 1000, 32)
226 199 Clone Test Row - 199 umn Data Large Column Data Large
227 198 Clone Test Row - 198 umn Data Large Column Data Large
228 197 Clone Test Row - 197 umn Data Large Column Data Large
229 196 Clone Test Row - 196 umn Data Large Column Data Large
230 195 Clone Test Row - 195 umn Data Large Column Data Large
231 194 Clone Test Row - 194 umn Data Large Column Data Large
232 193 Clone Test Row - 193 umn Data Large Column Data Large
233 192 Clone Test Row - 192 umn Data Large Column Data Large
234 191 Clone Test Row - 191 umn Data Large Column Data Large
235 190 Clone Test Row - 190 umn Data Large Column Data Large
236 call execute_dml(3, 0, 1, 1, 1, 0);
237 call execute_dml(0, 0, 200, 200, 100, 0);
238 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
239 col1 col2 col3 SUBSTRING(col4, 1000, 32)
240 0 0 Clone Test Row - 0 umn Data Large Column Data Large
241 1 10 Clone Test Row - 1 umn Data Large Column Data Large
242 2 20 Clone Test Row - 2 umn Data Large Column Data Large
243 3 30 Clone Test Row - 3 umn Data Large Column Data Large
244 4 40 Clone Test Row - 4 umn Data Large Column Data Large
245 5 50 Clone Test Row - 5 umn Data Large Column Data Large
246 6 60 Clone Test Row - 6 umn Data Large Column Data Large
247 7 70 Clone Test Row - 7 umn Data Large Column Data Large
248 8 80 Clone Test Row - 8 umn Data Large Column Data Large
249 9 90 Clone Test Row - 9 umn Data Large Column Data Large
250 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
251 col1 col2 col3 SUBSTRING(col4, 1000, 32)
252 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
253 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
254 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
255 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
256 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
257 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
258 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
259 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
260 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
261 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
262 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
263 col1 col2 col3 SUBSTRING(col4, 1000, 32)
264 0 0 Clone Test Row - 0 umn Data Large Column Data Large
265 1 10 Clone Test Row - 1 umn Data Large Column Data Large
266 2 20 Clone Test Row - 2 umn Data Large Column Data Large
267 3 30 Clone Test Row - 3 umn Data Large Column Data Large
268 4 40 Clone Test Row - 4 umn Data Large Column Data Large
269 5 50 Clone Test Row - 5 umn Data Large Column Data Large
270 6 60 Clone Test Row - 6 umn Data Large Column Data Large
271 7 70 Clone Test Row - 7 umn Data Large Column Data Large
272 8 80 Clone Test Row - 8 umn Data Large Column Data Large
273 9 90 Clone Test Row - 9 umn Data Large Column Data Large
274 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
275 SET GLOBAL innodb_redo_log_encrypt = ON;
276 SET GLOBAL innodb_undo_log_encrypt = ON;
277 # In connection default - Cloning database
278 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
279 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
280 SET GLOBAL clone_autotune_concurrency = OFF;
281 SET GLOBAL clone_max_concurrency = 8;
282 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
283 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
284 # In connection con1 - Running Update Random [0 - 200 Key Range]
285 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
286 START TRANSACTION;
287 CALL execute_dml(1, 0, 200, 500, 100, 1);
288 COMMIT;
289 # Flush all dirty buffers
290 SET GLOBAL innodb_buf_flush_list_now = 1;
291 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
292 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
293 START TRANSACTION;
294 CALL execute_dml(1, 0, 200, 500, 100, 1);
295 COMMIT;
296 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
297 # In connection default - Cloning database
298 # Restart cloned database
299 # restart: --datadir=CLONE_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
300 SHOW CREATE TABLE t1;
301 Table Create Table
302 t1 CREATE TABLE `t1` (
303 `col1` int NOT NULL,
304 `col2` int DEFAULT NULL,
305 `col3` varchar(64) DEFAULT NULL,
306 `col4` blob,
307 PRIMARY KEY (`col1`)
308 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='LZ4' ENCRYPTION='Y'
309 SELECT count(*) from t1;
310 count(*)
311 200
312 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
313 col1 col3 SUBSTRING(col4, 1000, 32)
314 0 Clone Test Row - 0 umn Data Large Column Data Large
315 1 Clone Test Row - 1 umn Data Large Column Data Large
316 2 Clone Test Row - 2 umn Data Large Column Data Large
317 3 Clone Test Row - 3 umn Data Large Column Data Large
318 4 Clone Test Row - 4 umn Data Large Column Data Large
319 5 Clone Test Row - 5 umn Data Large Column Data Large
320 6 Clone Test Row - 6 umn Data Large Column Data Large
321 7 Clone Test Row - 7 umn Data Large Column Data Large
322 8 Clone Test Row - 8 umn Data Large Column Data Large
323 9 Clone Test Row - 9 umn Data Large Column Data Large
324 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
325 col1 col3 SUBSTRING(col4, 1000, 32)
326 199 Clone Test Row - 199 umn Data Large Column Data Large
327 198 Clone Test Row - 198 umn Data Large Column Data Large
328 197 Clone Test Row - 197 umn Data Large Column Data Large
329 196 Clone Test Row - 196 umn Data Large Column Data Large
330 195 Clone Test Row - 195 umn Data Large Column Data Large
331 194 Clone Test Row - 194 umn Data Large Column Data Large
332 193 Clone Test Row - 193 umn Data Large Column Data Large
333 192 Clone Test Row - 192 umn Data Large Column Data Large
334 191 Clone Test Row - 191 umn Data Large Column Data Large
335 190 Clone Test Row - 190 umn Data Large Column Data Large
336 SHOW CREATE TABLE t2;
337 Table Create Table
338 t2 CREATE TABLE `t2` (
339 `col1` int NOT NULL,
340 `col2` int DEFAULT NULL,
341 `col3` varchar(64) DEFAULT NULL,
342 `col4` blob,
343 PRIMARY KEY (`col1`)
344 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMPRESSION='ZLIB'
345 SELECT count(*) from t2;
346 count(*)
347 200
348 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
349 col1 col3 SUBSTRING(col4, 1000, 32)
350 0 Clone Test Row - 0 umn Data Large Column Data Large
351 1 Clone Test Row - 1 umn Data Large Column Data Large
352 2 Clone Test Row - 2 umn Data Large Column Data Large
353 3 Clone Test Row - 3 umn Data Large Column Data Large
354 4 Clone Test Row - 4 umn Data Large Column Data Large
355 5 Clone Test Row - 5 umn Data Large Column Data Large
356 6 Clone Test Row - 6 umn Data Large Column Data Large
357 7 Clone Test Row - 7 umn Data Large Column Data Large
358 8 Clone Test Row - 8 umn Data Large Column Data Large
359 9 Clone Test Row - 9 umn Data Large Column Data Large
360 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
361 col1 col3 SUBSTRING(col4, 1000, 32)
362 199 Clone Test Row - 199 umn Data Large Column Data Large
363 198 Clone Test Row - 198 umn Data Large Column Data Large
364 197 Clone Test Row - 197 umn Data Large Column Data Large
365 196 Clone Test Row - 196 umn Data Large Column Data Large
366 195 Clone Test Row - 195 umn Data Large Column Data Large
367 194 Clone Test Row - 194 umn Data Large Column Data Large
368 193 Clone Test Row - 193 umn Data Large Column Data Large
369 192 Clone Test Row - 192 umn Data Large Column Data Large
370 191 Clone Test Row - 191 umn Data Large Column Data Large
371 190 Clone Test Row - 190 umn Data Large Column Data Large
372 call execute_dml(3, 0, 1, 1, 1, 0);
373 call execute_dml(0, 0, 200, 200, 100, 0);
374 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
375 col1 col2 col3 SUBSTRING(col4, 1000, 32)
376 0 0 Clone Test Row - 0 umn Data Large Column Data Large
377 1 10 Clone Test Row - 1 umn Data Large Column Data Large
378 2 20 Clone Test Row - 2 umn Data Large Column Data Large
379 3 30 Clone Test Row - 3 umn Data Large Column Data Large
380 4 40 Clone Test Row - 4 umn Data Large Column Data Large
381 5 50 Clone Test Row - 5 umn Data Large Column Data Large
382 6 60 Clone Test Row - 6 umn Data Large Column Data Large
383 7 70 Clone Test Row - 7 umn Data Large Column Data Large
384 8 80 Clone Test Row - 8 umn Data Large Column Data Large
385 9 90 Clone Test Row - 9 umn Data Large Column Data Large
386 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
387 col1 col2 col3 SUBSTRING(col4, 1000, 32)
388 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
389 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
390 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
391 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
392 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
393 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
394 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
395 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
396 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
397 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
398 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
399 col1 col2 col3 SUBSTRING(col4, 1000, 32)
400 0 0 Clone Test Row - 0 umn Data Large Column Data Large
401 1 10 Clone Test Row - 1 umn Data Large Column Data Large
402 2 20 Clone Test Row - 2 umn Data Large Column Data Large
403 3 30 Clone Test Row - 3 umn Data Large Column Data Large
404 4 40 Clone Test Row - 4 umn Data Large Column Data Large
405 5 50 Clone Test Row - 5 umn Data Large Column Data Large
406 6 60 Clone Test Row - 6 umn Data Large Column Data Large
407 7 70 Clone Test Row - 7 umn Data Large Column Data Large
408 8 80 Clone Test Row - 8 umn Data Large Column Data Large
409 9 90 Clone Test Row - 9 umn Data Large Column Data Large
410 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
411 col1 col2 col3 SUBSTRING(col4, 1000, 32)
412 199 1990 Clone Test Row - 199 umn Data Large Column Data Large
413 198 1980 Clone Test Row - 198 umn Data Large Column Data Large
414 197 1970 Clone Test Row - 197 umn Data Large Column Data Large
415 196 1960 Clone Test Row - 196 umn Data Large Column Data Large
416 195 1950 Clone Test Row - 195 umn Data Large Column Data Large
417 194 1940 Clone Test Row - 194 umn Data Large Column Data Large
418 193 1930 Clone Test Row - 193 umn Data Large Column Data Large
419 192 1920 Clone Test Row - 192 umn Data Large Column Data Large
420 191 1910 Clone Test Row - 191 umn Data Large Column Data Large
421 190 1900 Clone Test Row - 190 umn Data Large Column Data Large
422 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
423 DROP TABLE t1;
424 DROP TABLE t2;
425 DROP PROCEDURE execute_dml;
426 DROP TABLESPACE tbs1;
427 UNINSTALL PLUGIN clone;
428 UNINSTALL PLUGIN keyring_file;
429 SET DEBUG_SYNC = 'RESET';
430 # Restart server and remove encrypted data directory
431 # restart: