Debian Codegraph @

mysql-test/suite/innodb_zip/r/restart.result

raw
1 SET default_storage_engine=InnoDB;
2 #
3 # A series of tests to make sure tables are opened after restart.
4 # Bug#13357607 Compressed file-per-table tablespaces fail to open
5 #
6 #
7 # Restart with innodb-directories set to MYSQL_TMP_DIR/alt_dir.
8 #
9 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
10 CREATE DATABASE move_test;
11 USE move_test;
12 set global innodb_file_per_table=on;
13 #
14 # Create and insert records into a REDUNDANT row formatted table.
15 #
16 CREATE TABLE t1_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
17 ROW_FORMAT=REDUNDANT ENGINE=InnoDB;
18 Warnings:
19 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
20 INSERT INTO t1_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
21 INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
22 INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
23 INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
24 INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
25 SHOW CREATE TABLE t1_restart;
26 Table Create Table
27 t1_restart CREATE TABLE `t1_restart` (
28 `c1` double NOT NULL AUTO_INCREMENT,
29 `c2` char(10) DEFAULT NULL,
30 `c3` varchar(100) DEFAULT NULL,
31 `c4` date DEFAULT NULL,
32 `c5` text,
33 PRIMARY KEY (`c1`)
34 ) ENGINE=InnoDB AUTO_INCREMENT=1000000027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
35 SELECT count(*) FROM t1_restart;
36 count(*)
37 16
38 #
39 # Create and insert records into a COMPACT row formatted table.
40 #
41 CREATE TABLE t2_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
42 ROW_FORMAT=COMPACT ENGINE=InnoDB;
43 Warnings:
44 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
45 INSERT INTO t2_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
46 INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
47 INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
48 INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
49 INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
50 SHOW CREATE TABLE t2_restart;
51 Table Create Table
52 t2_restart CREATE TABLE `t2_restart` (
53 `c1` double NOT NULL AUTO_INCREMENT,
54 `c2` char(10) DEFAULT NULL,
55 `c3` varchar(100) DEFAULT NULL,
56 `c4` date DEFAULT NULL,
57 `c5` text,
58 PRIMARY KEY (`c1`)
59 ) ENGINE=InnoDB AUTO_INCREMENT=1000000027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
60 SELECT count(*) FROM t2_restart;
61 count(*)
62 16
63 #
64 # Create and insert records into a COMPRESSED row formatted table.
65 #
66 CREATE TABLE t3_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
67 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 ENGINE=InnoDB;
68 Warnings:
69 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
70 INSERT INTO t3_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
71 INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
72 INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
73 INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
74 INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
75 SHOW CREATE TABLE t3_restart;
76 Table Create Table
77 t3_restart CREATE TABLE `t3_restart` (
78 `c1` double NOT NULL AUTO_INCREMENT,
79 `c2` char(10) DEFAULT NULL,
80 `c3` varchar(100) DEFAULT NULL,
81 `c4` date DEFAULT NULL,
82 `c5` text,
83 PRIMARY KEY (`c1`)
84 ) ENGINE=InnoDB AUTO_INCREMENT=1000000027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
85 SELECT count(*) FROM t3_restart;
86 count(*)
87 16
88 #
89 # Create and insert records into a DYNAMIC row formatted table.
90 #
91 CREATE TABLE t4_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
92 ROW_FORMAT=DYNAMIC ENGINE=InnoDB;
93 Warnings:
94 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
95 INSERT INTO t4_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
96 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
97 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
98 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
99 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
100 SHOW CREATE TABLE t4_restart;
101 Table Create Table
102 t4_restart CREATE TABLE `t4_restart` (
103 `c1` double NOT NULL AUTO_INCREMENT,
104 `c2` char(10) DEFAULT NULL,
105 `c3` varchar(100) DEFAULT NULL,
106 `c4` date DEFAULT NULL,
107 `c5` text,
108 PRIMARY KEY (`c1`)
109 ) ENGINE=InnoDB AUTO_INCREMENT=1000000027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
110 SELECT count(*) FROM t4_restart;
111 count(*)
112 16
113 #
114 # Create and insert records into a table that uses a remote DATA DIRECTORY.
115 #
116 #
117 CREATE TABLE t5_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
118 ROW_FORMAT=DYNAMIC ENGINE=InnoDB DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
119 Warnings:
120 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
121 INSERT INTO t5_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
122 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
123 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
124 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
125 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
126 SHOW CREATE TABLE t5_restart;
127 Table Create Table
128 t5_restart CREATE TABLE `t5_restart` (
129 `c1` double NOT NULL AUTO_INCREMENT,
130 `c2` char(10) DEFAULT NULL,
131 `c3` varchar(100) DEFAULT NULL,
132 `c4` date DEFAULT NULL,
133 `c5` text,
134 PRIMARY KEY (`c1`)
135 ) ENGINE=InnoDB AUTO_INCREMENT=1000000027 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
136 SELECT count(*) FROM t5_restart;
137 count(*)
138 16
139 #
140 # Create and insert records into a partitioned table that uses
141 # a remote DATA DIRECTORY for each partition.
142 CREATE TABLE t6_restart(
143 c1 INT AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
144 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 ENGINE=InnoDB
145 PARTITION BY HASH(c1) (
146 PARTITION p0 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir',
147 PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir',
148 PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir');
149 INSERT INTO t6_restart VALUES (0, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
150 INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
151 INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
152 INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
153 INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
154 SHOW CREATE TABLE t6_restart;
155 Table Create Table
156 t6_restart CREATE TABLE `t6_restart` (
157 `c1` int NOT NULL AUTO_INCREMENT,
158 `c2` char(10) DEFAULT NULL,
159 `c3` varchar(100) DEFAULT NULL,
160 `c4` date DEFAULT NULL,
161 `c5` text,
162 PRIMARY KEY (`c1`)
163 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
164 /*!50100 PARTITION BY HASH (`c1`)
165 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB,
166 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB,
167 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB) */
168 SELECT count(*) FROM t6_restart;
169 count(*)
170 16
171 #
172 # Create and insert records into a subpartitioned table that uses
173 # a remote DATA DIRECTORY for each subpartition.
174 #
175 CREATE TABLE t7_restart(
176 c1 INT AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
177 ROW_FORMAT=DYNAMIC ENGINE=InnoDB
178 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c1) (
179 PARTITION p0 VALUES LESS THAN (10) (
180 SUBPARTITION s0 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir',
181 SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir'),
182 PARTITION p1 VALUES LESS THAN MAXVALUE (
183 SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir',
184 SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir'));
185 INSERT INTO t7_restart VALUES (0, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
186 INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
187 INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
188 INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
189 INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
190 SHOW CREATE TABLE t7_restart;
191 Table Create Table
192 t7_restart CREATE TABLE `t7_restart` (
193 `c1` int NOT NULL AUTO_INCREMENT,
194 `c2` char(10) DEFAULT NULL,
195 `c3` varchar(100) DEFAULT NULL,
196 `c4` date DEFAULT NULL,
197 `c5` text,
198 PRIMARY KEY (`c1`)
199 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
200 /*!50100 PARTITION BY RANGE (`c1`)
201 SUBPARTITION BY HASH (`c1`)
202 (PARTITION p0 VALUES LESS THAN (10)
203 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB,
204 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB),
205 PARTITION p1 VALUES LESS THAN MAXVALUE
206 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB,
207 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir/' ENGINE = InnoDB)) */
208 SELECT count(*) FROM t7_restart;
209 count(*)
210 16
211 #
212 # Create and insert records into a table that uses a general tablespace.
213 #
214 CREATE TABLESPACE s1_restart ADD DATAFILE 's1_restart.ibd';
215 CREATE TABLE t8_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
216 ROW_FORMAT=COMPACT ENGINE=InnoDB TABLESPACE=s1_restart;
217 Warnings:
218 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
219 INSERT INTO t8_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
220 INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
221 INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
222 INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
223 INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
224 SHOW CREATE TABLE t8_restart;
225 Table Create Table
226 t8_restart CREATE TABLE `t8_restart` (
227 `c1` double NOT NULL AUTO_INCREMENT,
228 `c2` char(10) DEFAULT NULL,
229 `c3` varchar(100) DEFAULT NULL,
230 `c4` date DEFAULT NULL,
231 `c5` text,
232 PRIMARY KEY (`c1`)
233 ) /*!50100 TABLESPACE `s1_restart` */ ENGINE=InnoDB AUTO_INCREMENT=1000000125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
234 SELECT count(*) FROM t8_restart;
235 count(*)
236 65
237 CREATE TABLE t9_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
238 ROW_FORMAT=DYNAMIC ENGINE=InnoDB TABLESPACE=s1_restart;
239 Warnings:
240 Warning 3856 AUTO_INCREMENT support for FLOAT/DOUBLE columns is deprecated and will be removed in a future release. Consider removing AUTO_INCREMENT from column 'c1'.
241 INSERT INTO t9_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
242 INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
243 INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
244 INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
245 INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
246 SHOW CREATE TABLE t9_restart;
247 Table Create Table
248 t9_restart CREATE TABLE `t9_restart` (
249 `c1` double NOT NULL AUTO_INCREMENT,
250 `c2` char(10) DEFAULT NULL,
251 `c3` varchar(100) DEFAULT NULL,
252 `c4` date DEFAULT NULL,
253 `c5` text,
254 PRIMARY KEY (`c1`)
255 ) /*!50100 TABLESPACE `s1_restart` */ ENGINE=InnoDB AUTO_INCREMENT=1000000125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
256 SELECT count(*) FROM t9_restart;
257 count(*)
258 65
259 #
260 # Show these tables in information_schema.
261 #
262 === information_schema.innodb_tables and innodb_tablespaces ===
263 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
264 move_test/t1_restart move_test/t1_restart 0 8 Redundant 0 Single
265 move_test/t2_restart move_test/t2_restart 1 8 Compact 0 Single
266 move_test/t3_restart move_test/t3_restart 37 8 Compressed 2048 Single
267 move_test/t4_restart move_test/t4_restart 33 8 Dynamic 0 Single
268 move_test/t5_restart move_test/t5_restart 97 8 Dynamic 0 Single
269 move_test/t6_restart#p#p0 move_test/t6_restart#p#p0 101 8 Compressed 2048 Single
270 move_test/t6_restart#p#p1 move_test/t6_restart#p#p1 101 8 Compressed 2048 Single
271 move_test/t6_restart#p#p2 move_test/t6_restart#p#p2 101 8 Compressed 2048 Single
272 move_test/t7_restart#p#p0#sp#s0 move_test/t7_restart#p#p0#sp#s0 97 8 Dynamic 0 Single
273 move_test/t7_restart#p#p0#sp#s1 move_test/t7_restart#p#p0#sp#s1 97 8 Dynamic 0 Single
274 move_test/t7_restart#p#p1#sp#s2 move_test/t7_restart#p#p1#sp#s2 97 8 Dynamic 0 Single
275 move_test/t7_restart#p#p1#sp#s3 move_test/t7_restart#p#p1#sp#s3 97 8 Dynamic 0 Single
276 move_test/t8_restart s1_restart 129 8 Compact 0 General
277 move_test/t9_restart s1_restart 161 8 Dynamic 0 General
278 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
279 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
280 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
281 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
282 === information_schema.innodb_tablespaces and innodb_datafiles ===
283 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
284 move_test/t1_restart Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/move_test/t1_restart.ibd
285 move_test/t2_restart Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/move_test/t2_restart.ibd
286 move_test/t3_restart Single DEFAULT 2048 1 1 Compressed MYSQLD_DATADIR/move_test/t3_restart.ibd
287 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
288 move_test/t5_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
289 move_test/t6_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
290 move_test/t6_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
291 move_test/t6_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
292 move_test/t7_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
293 move_test/t7_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
294 move_test/t7_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
295 move_test/t7_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
296 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
297 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
298 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
299 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
300 s1_restart General DEFAULT 0 1 1 Any s1_restart.ibd
301 === information_schema.files ===
302 Space_Name File_Type Engine Status Tablespace_Name Path
303 move_test/t1_restart TABLESPACE InnoDB NORMAL move_test/t1_restart MYSQLD_DATADIR/move_test/t1_restart.ibd
304 move_test/t2_restart TABLESPACE InnoDB NORMAL move_test/t2_restart MYSQLD_DATADIR/move_test/t2_restart.ibd
305 move_test/t3_restart TABLESPACE InnoDB NORMAL move_test/t3_restart MYSQLD_DATADIR/move_test/t3_restart.ibd
306 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
307 move_test/t5_restart TABLESPACE InnoDB NORMAL move_test/t5_restart MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
308 move_test/t6_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
309 move_test/t6_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
310 move_test/t6_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
311 move_test/t7_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
312 move_test/t7_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
313 move_test/t7_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
314 move_test/t7_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
315 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
316 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
317 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
318 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
319 s1_restart TABLESPACE InnoDB NORMAL s1_restart MYSQLD_DATADIR/s1_restart.ibd
320 #
321 # Shutdown the server and list the tablespace OS files
322 #
323 ---- MYSQL_DATA_DIR/move_test
324 t1_restart.ibd
325 t2_restart.ibd
326 t3_restart.ibd
327 t4_restart.ibd
328 ---- ALT_DIR
329 move_test
330 ---- ALT_DIR/move_test
331 t5_restart.ibd
332 t6_restart#p#p0.ibd
333 t6_restart#p#p1.ibd
334 t6_restart#p#p2.ibd
335 t7_restart#p#p0#sp#s0.ibd
336 t7_restart#p#p0#sp#s1.ibd
337 t7_restart#p#p1#sp#s2.ibd
338 t7_restart#p#p1#sp#s3.ibd
339 #
340 # Start the server and show that tables are still visible and accessible.
341 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
342 SHOW VARIABLES LIKE 'innodb_file_per_table';
343 Variable_name Value
344 innodb_file_per_table ON
345 SHOW CREATE TABLE t1_restart;
346 Table Create Table
347 t1_restart CREATE TABLE `t1_restart` (
348 `c1` double NOT NULL AUTO_INCREMENT,
349 `c2` char(10) DEFAULT NULL,
350 `c3` varchar(100) DEFAULT NULL,
351 `c4` date DEFAULT NULL,
352 `c5` text,
353 PRIMARY KEY (`c1`)
354 ) ENGINE=InnoDB AUTO_INCREMENT=1000000020 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
355 SHOW CREATE TABLE t2_restart;
356 Table Create Table
357 t2_restart CREATE TABLE `t2_restart` (
358 `c1` double NOT NULL AUTO_INCREMENT,
359 `c2` char(10) DEFAULT NULL,
360 `c3` varchar(100) DEFAULT NULL,
361 `c4` date DEFAULT NULL,
362 `c5` text,
363 PRIMARY KEY (`c1`)
364 ) ENGINE=InnoDB AUTO_INCREMENT=1000000020 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
365 SHOW CREATE TABLE t3_restart;
366 Table Create Table
367 t3_restart CREATE TABLE `t3_restart` (
368 `c1` double NOT NULL AUTO_INCREMENT,
369 `c2` char(10) DEFAULT NULL,
370 `c3` varchar(100) DEFAULT NULL,
371 `c4` date DEFAULT NULL,
372 `c5` text,
373 PRIMARY KEY (`c1`)
374 ) ENGINE=InnoDB AUTO_INCREMENT=1000000020 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
375 SHOW CREATE TABLE t4_restart;
376 Table Create Table
377 t4_restart CREATE TABLE `t4_restart` (
378 `c1` double NOT NULL AUTO_INCREMENT,
379 `c2` char(10) DEFAULT NULL,
380 `c3` varchar(100) DEFAULT NULL,
381 `c4` date DEFAULT NULL,
382 `c5` text,
383 PRIMARY KEY (`c1`)
384 ) ENGINE=InnoDB AUTO_INCREMENT=1000000020 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
385 SHOW CREATE TABLE t5_restart;
386 Table Create Table
387 t5_restart CREATE TABLE `t5_restart` (
388 `c1` double NOT NULL AUTO_INCREMENT,
389 `c2` char(10) DEFAULT NULL,
390 `c3` varchar(100) DEFAULT NULL,
391 `c4` date DEFAULT NULL,
392 `c5` text,
393 PRIMARY KEY (`c1`)
394 ) ENGINE=InnoDB AUTO_INCREMENT=1000000020 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
395 SHOW CREATE TABLE t6_restart;
396 Table Create Table
397 t6_restart CREATE TABLE `t6_restart` (
398 `c1` int NOT NULL AUTO_INCREMENT,
399 `c2` char(10) DEFAULT NULL,
400 `c3` varchar(100) DEFAULT NULL,
401 `c4` date DEFAULT NULL,
402 `c5` text,
403 PRIMARY KEY (`c1`)
404 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
405 /*!50100 PARTITION BY HASH (`c1`)
406 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
407 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
408 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
409 SHOW CREATE TABLE t7_restart;
410 Table Create Table
411 t7_restart CREATE TABLE `t7_restart` (
412 `c1` int NOT NULL AUTO_INCREMENT,
413 `c2` char(10) DEFAULT NULL,
414 `c3` varchar(100) DEFAULT NULL,
415 `c4` date DEFAULT NULL,
416 `c5` text,
417 PRIMARY KEY (`c1`)
418 ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
419 /*!50100 PARTITION BY RANGE (`c1`)
420 SUBPARTITION BY HASH (`c1`)
421 (PARTITION p0 VALUES LESS THAN (10)
422 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
423 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
424 PARTITION p1 VALUES LESS THAN MAXVALUE
425 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
426 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
427 SHOW CREATE TABLE t8_restart;
428 Table Create Table
429 t8_restart CREATE TABLE `t8_restart` (
430 `c1` double NOT NULL AUTO_INCREMENT,
431 `c2` char(10) DEFAULT NULL,
432 `c3` varchar(100) DEFAULT NULL,
433 `c4` date DEFAULT NULL,
434 `c5` text,
435 PRIMARY KEY (`c1`)
436 ) /*!50100 TABLESPACE `s1_restart` */ ENGINE=InnoDB AUTO_INCREMENT=1000000110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
437 SHOW CREATE TABLE t9_restart;
438 Table Create Table
439 t9_restart CREATE TABLE `t9_restart` (
440 `c1` double NOT NULL AUTO_INCREMENT,
441 `c2` char(10) DEFAULT NULL,
442 `c3` varchar(100) DEFAULT NULL,
443 `c4` date DEFAULT NULL,
444 `c5` text,
445 PRIMARY KEY (`c1`)
446 ) /*!50100 TABLESPACE `s1_restart` */ ENGINE=InnoDB AUTO_INCREMENT=1000000110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
447 INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
448 INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
449 INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
450 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
451 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
452 INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
453 INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
454 INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t8_restart);
455 INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t9_restart);
456 SELECT count(*) FROM t1_restart;
457 count(*)
458 32
459 SELECT count(*) FROM t2_restart;
460 count(*)
461 32
462 SELECT count(*) FROM t3_restart;
463 count(*)
464 32
465 SELECT count(*) FROM t4_restart;
466 count(*)
467 32
468 SELECT count(*) FROM t5_restart;
469 count(*)
470 32
471 SELECT count(*) FROM t6_restart;
472 count(*)
473 32
474 SELECT count(*) FROM t7_restart;
475 count(*)
476 32
477 SELECT count(*) FROM t8_restart;
478 count(*)
479 130
480 SELECT count(*) FROM t9_restart;
481 count(*)
482 130
483 #
484 # Show these tables in information_schema.
485 #
486 === information_schema.innodb_tables and innodb_tablespaces ===
487 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
488 move_test/t1_restart move_test/t1_restart 0 8 Redundant 0 Single
489 move_test/t2_restart move_test/t2_restart 1 8 Compact 0 Single
490 move_test/t3_restart move_test/t3_restart 37 8 Compressed 2048 Single
491 move_test/t4_restart move_test/t4_restart 33 8 Dynamic 0 Single
492 move_test/t5_restart move_test/t5_restart 97 8 Dynamic 0 Single
493 move_test/t6_restart#p#p0 move_test/t6_restart#p#p0 101 8 Compressed 2048 Single
494 move_test/t6_restart#p#p1 move_test/t6_restart#p#p1 101 8 Compressed 2048 Single
495 move_test/t6_restart#p#p2 move_test/t6_restart#p#p2 101 8 Compressed 2048 Single
496 move_test/t7_restart#p#p0#sp#s0 move_test/t7_restart#p#p0#sp#s0 97 8 Dynamic 0 Single
497 move_test/t7_restart#p#p0#sp#s1 move_test/t7_restart#p#p0#sp#s1 97 8 Dynamic 0 Single
498 move_test/t7_restart#p#p1#sp#s2 move_test/t7_restart#p#p1#sp#s2 97 8 Dynamic 0 Single
499 move_test/t7_restart#p#p1#sp#s3 move_test/t7_restart#p#p1#sp#s3 97 8 Dynamic 0 Single
500 move_test/t8_restart s1_restart 129 8 Compact 0 General
501 move_test/t9_restart s1_restart 161 8 Dynamic 0 General
502 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
503 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
504 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
505 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
506 === information_schema.innodb_tablespaces and innodb_datafiles ===
507 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
508 move_test/t1_restart Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/move_test/t1_restart.ibd
509 move_test/t2_restart Single DEFAULT 0 1 1 Compact or Redundant MYSQLD_DATADIR/move_test/t2_restart.ibd
510 move_test/t3_restart Single DEFAULT 2048 1 1 Compressed MYSQLD_DATADIR/move_test/t3_restart.ibd
511 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
512 move_test/t5_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
513 move_test/t6_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
514 move_test/t6_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
515 move_test/t6_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
516 move_test/t7_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
517 move_test/t7_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
518 move_test/t7_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
519 move_test/t7_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
520 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
521 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
522 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
523 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
524 s1_restart General DEFAULT 0 1 1 Any s1_restart.ibd
525 === information_schema.files ===
526 Space_Name File_Type Engine Status Tablespace_Name Path
527 move_test/t1_restart TABLESPACE InnoDB NORMAL move_test/t1_restart MYSQLD_DATADIR/move_test/t1_restart.ibd
528 move_test/t2_restart TABLESPACE InnoDB NORMAL move_test/t2_restart MYSQLD_DATADIR/move_test/t2_restart.ibd
529 move_test/t3_restart TABLESPACE InnoDB NORMAL move_test/t3_restart MYSQLD_DATADIR/move_test/t3_restart.ibd
530 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
531 move_test/t5_restart TABLESPACE InnoDB NORMAL move_test/t5_restart MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
532 move_test/t6_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
533 move_test/t6_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
534 move_test/t6_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
535 move_test/t7_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
536 move_test/t7_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
537 move_test/t7_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
538 move_test/t7_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
539 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
540 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
541 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
542 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
543 s1_restart TABLESPACE InnoDB NORMAL s1_restart MYSQLD_DATADIR/s1_restart.ibd
544 DROP TABLE t1_restart;
545 DROP TABLE t2_restart;
546 DROP TABLE t3_restart;
547 DROP TABLE t8_restart;
548 DROP TABLE t9_restart;
549 DROP TABLESPACE s1_restart;
550 #
551 # Truncate the remote tablespaces.
552 #
553 TRUNCATE TABLE t5_restart;
554 ALTER TABLE t6_restart TRUNCATE PARTITION p2;
555 ALTER TABLE t7_restart TRUNCATE PARTITION p1;
556 === information_schema.innodb_tablespaces and innodb_datafiles ===
557 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
558 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
559 move_test/t5_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
560 move_test/t6_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
561 move_test/t6_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
562 move_test/t6_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
563 move_test/t7_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
564 move_test/t7_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
565 move_test/t7_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
566 move_test/t7_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
567 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
568 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
569 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
570 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
571 === information_schema.files ===
572 Space_Name File_Type Engine Status Tablespace_Name Path
573 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
574 move_test/t5_restart TABLESPACE InnoDB NORMAL move_test/t5_restart MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
575 move_test/t6_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
576 move_test/t6_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
577 move_test/t6_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
578 move_test/t7_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
579 move_test/t7_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
580 move_test/t7_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
581 move_test/t7_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
582 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
583 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
584 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
585 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
586 INSERT INTO t5_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
587 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
588 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
589 INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
590 SELECT count(*) FROM t5_restart;
591 count(*)
592 8
593 SHOW CREATE TABLE t5_restart;
594 Table Create Table
595 t5_restart CREATE TABLE `t5_restart` (
596 `c1` double NOT NULL AUTO_INCREMENT,
597 `c2` char(10) DEFAULT NULL,
598 `c3` varchar(100) DEFAULT NULL,
599 `c4` date DEFAULT NULL,
600 `c5` text,
601 PRIMARY KEY (`c1`)
602 ) ENGINE=InnoDB AUTO_INCREMENT=1000000012 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
603 SELECT count(*) FROM t6_restart;
604 count(*)
605 21
606 SHOW CREATE TABLE t6_restart;
607 Table Create Table
608 t6_restart CREATE TABLE `t6_restart` (
609 `c1` int NOT NULL AUTO_INCREMENT,
610 `c2` char(10) DEFAULT NULL,
611 `c3` varchar(100) DEFAULT NULL,
612 `c4` date DEFAULT NULL,
613 `c5` text,
614 PRIMARY KEY (`c1`)
615 ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
616 /*!50100 PARTITION BY HASH (`c1`)
617 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
618 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
619 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
620 SELECT count(*) FROM t7_restart;
621 count(*)
622 9
623 SHOW CREATE TABLE t7_restart;
624 Table Create Table
625 t7_restart CREATE TABLE `t7_restart` (
626 `c1` int NOT NULL AUTO_INCREMENT,
627 `c2` char(10) DEFAULT NULL,
628 `c3` varchar(100) DEFAULT NULL,
629 `c4` date DEFAULT NULL,
630 `c5` text,
631 PRIMARY KEY (`c1`)
632 ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
633 /*!50100 PARTITION BY RANGE (`c1`)
634 SUBPARTITION BY HASH (`c1`)
635 (PARTITION p0 VALUES LESS THAN (10)
636 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
637 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
638 PARTITION p1 VALUES LESS THAN MAXVALUE
639 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
640 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
641 #
642 # Shutdown the server and make a backup of a tablespace
643 #
644 ---- MYSQL_DATA_DIR/move_test
645 t4_restart.ibd
646 ---- ALT_DIR/move_test
647 t5_restart.ibd
648 t5_restart.ibd.bak
649 t6_restart#p#p0.ibd
650 t6_restart#p#p1.ibd
651 t6_restart#p#p2.ibd
652 t7_restart#p#p0#sp#s0.ibd
653 t7_restart#p#p0#sp#s1.ibd
654 t7_restart#p#p1#sp#s2.ibd
655 t7_restart#p#p1#sp#s3.ibd
656 #
657 # Start the server and show the tablespaces.
658 #
659 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
660 SHOW VARIABLES LIKE 'innodb_file_per_table';
661 Variable_name Value
662 innodb_file_per_table ON
663 === information_schema.innodb_tablespaces and innodb_datafiles ===
664 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
665 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
666 move_test/t5_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
667 move_test/t6_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
668 move_test/t6_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
669 move_test/t6_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
670 move_test/t7_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
671 move_test/t7_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
672 move_test/t7_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
673 move_test/t7_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
674 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
675 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
676 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
677 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
678 === information_schema.files ===
679 Space_Name File_Type Engine Status Tablespace_Name Path
680 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
681 move_test/t5_restart TABLESPACE InnoDB NORMAL move_test/t5_restart MYSQL_TMP_DIR/alt_dir/move_test/t5_restart.ibd
682 move_test/t6_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p0.ibd
683 move_test/t6_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p1.ibd
684 move_test/t6_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t6_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t6_restart#p#p2.ibd
685 move_test/t7_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s0.ibd
686 move_test/t7_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p0#sp#s1.ibd
687 move_test/t7_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s2.ibd
688 move_test/t7_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t7_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t7_restart#p#p1#sp#s3.ibd
689 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
690 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
691 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
692 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
693 SELECT count(*) FROM t5_restart;
694 count(*)
695 8
696 SHOW CREATE TABLE t5_restart;
697 Table Create Table
698 t5_restart CREATE TABLE `t5_restart` (
699 `c1` double NOT NULL AUTO_INCREMENT,
700 `c2` char(10) DEFAULT NULL,
701 `c3` varchar(100) DEFAULT NULL,
702 `c4` date DEFAULT NULL,
703 `c5` text,
704 PRIMARY KEY (`c1`)
705 ) ENGINE=InnoDB AUTO_INCREMENT=1000000009 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
706 SELECT count(*) FROM t6_restart;
707 count(*)
708 21
709 SHOW CREATE TABLE t6_restart;
710 Table Create Table
711 t6_restart CREATE TABLE `t6_restart` (
712 `c1` int NOT NULL AUTO_INCREMENT,
713 `c2` char(10) DEFAULT NULL,
714 `c3` varchar(100) DEFAULT NULL,
715 `c4` date DEFAULT NULL,
716 `c5` text,
717 PRIMARY KEY (`c1`)
718 ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
719 /*!50100 PARTITION BY HASH (`c1`)
720 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
721 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
722 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
723 SELECT count(*) FROM t7_restart;
724 count(*)
725 9
726 SHOW CREATE TABLE t7_restart;
727 Table Create Table
728 t7_restart CREATE TABLE `t7_restart` (
729 `c1` int NOT NULL AUTO_INCREMENT,
730 `c2` char(10) DEFAULT NULL,
731 `c3` varchar(100) DEFAULT NULL,
732 `c4` date DEFAULT NULL,
733 `c5` text,
734 PRIMARY KEY (`c1`)
735 ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
736 /*!50100 PARTITION BY RANGE (`c1`)
737 SUBPARTITION BY HASH (`c1`)
738 (PARTITION p0 VALUES LESS THAN (10)
739 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
740 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
741 PARTITION p1 VALUES LESS THAN MAXVALUE
742 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
743 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
744 #
745 # Try to rename a tablespace to a file that already exists
746 #
747 ---- MYSQL_DATA_DIR/move_test
748 t4_restart.ibd
749 ---- ALT_DIR/move_test
750 t5_restart.ibd
751 t6_restart#p#p0.ibd
752 t6_restart#p#p1.ibd
753 t6_restart#p#p2.ibd
754 t7_restart#p#p0#sp#s0.ibd
755 t7_restart#p#p0#sp#s1.ibd
756 t7_restart#p#p1#sp#s2.ibd
757 t7_restart#p#p1#sp#s3.ibd
758 #
759 # Rename file table and tablespace
760 #
761 RENAME TABLE t5_restart TO t55_restart;
762 RENAME TABLE t6_restart TO t66_restart;
763 RENAME TABLE t7_restart TO t77_restart;
764 === information_schema.innodb_tablespaces and innodb_datafiles ===
765 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
766 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
767 move_test/t55_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
768 move_test/t66_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
769 move_test/t66_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
770 move_test/t66_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
771 move_test/t77_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
772 move_test/t77_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
773 move_test/t77_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
774 move_test/t77_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
775 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
776 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
777 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
778 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
779 === information_schema.files ===
780 Space_Name File_Type Engine Status Tablespace_Name Path
781 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
782 move_test/t55_restart TABLESPACE InnoDB NORMAL move_test/t55_restart MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
783 move_test/t66_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
784 move_test/t66_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
785 move_test/t66_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
786 move_test/t77_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
787 move_test/t77_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
788 move_test/t77_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
789 move_test/t77_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
790 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
791 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
792 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
793 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
794 INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
795 SELECT count(*) FROM t55_restart;
796 count(*)
797 16
798 SHOW CREATE TABLE t55_restart;
799 Table Create Table
800 t55_restart CREATE TABLE `t55_restart` (
801 `c1` double NOT NULL AUTO_INCREMENT,
802 `c2` char(10) DEFAULT NULL,
803 `c3` varchar(100) DEFAULT NULL,
804 `c4` date DEFAULT NULL,
805 `c5` text,
806 PRIMARY KEY (`c1`)
807 ) ENGINE=InnoDB AUTO_INCREMENT=1000000024 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
808 INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
809 SELECT count(*) FROM t66_restart;
810 count(*)
811 42
812 SHOW CREATE TABLE t66_restart;
813 Table Create Table
814 t66_restart CREATE TABLE `t66_restart` (
815 `c1` int NOT NULL AUTO_INCREMENT,
816 `c2` char(10) DEFAULT NULL,
817 `c3` varchar(100) DEFAULT NULL,
818 `c4` date DEFAULT NULL,
819 `c5` text,
820 PRIMARY KEY (`c1`)
821 ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
822 /*!50100 PARTITION BY HASH (`c1`)
823 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
824 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
825 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
826 INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
827 SELECT count(*) FROM t77_restart;
828 count(*)
829 18
830 SHOW CREATE TABLE t77_restart;
831 Table Create Table
832 t77_restart CREATE TABLE `t77_restart` (
833 `c1` int NOT NULL AUTO_INCREMENT,
834 `c2` char(10) DEFAULT NULL,
835 `c3` varchar(100) DEFAULT NULL,
836 `c4` date DEFAULT NULL,
837 `c5` text,
838 PRIMARY KEY (`c1`)
839 ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
840 /*!50100 PARTITION BY RANGE (`c1`)
841 SUBPARTITION BY HASH (`c1`)
842 (PARTITION p0 VALUES LESS THAN (10)
843 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
844 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
845 PARTITION p1 VALUES LESS THAN MAXVALUE
846 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
847 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
848 ---- MYSQL_DATA_DIR/move_test
849 t4_restart.ibd
850 ---- ALT_DIR/move_test
851 t55_restart.ibd
852 t66_restart#p#p0.ibd
853 t66_restart#p#p1.ibd
854 t66_restart#p#p2.ibd
855 t77_restart#p#p0#sp#s0.ibd
856 t77_restart#p#p0#sp#s1.ibd
857 t77_restart#p#p1#sp#s2.ibd
858 t77_restart#p#p1#sp#s3.ibd
859 #
860 # Restart the server
861 #
862 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
863 SHOW VARIABLES LIKE 'innodb_file_per_table';
864 Variable_name Value
865 innodb_file_per_table ON
866 === information_schema.innodb_tablespaces and innodb_datafiles ===
867 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
868 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
869 move_test/t55_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
870 move_test/t66_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
871 move_test/t66_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
872 move_test/t66_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
873 move_test/t77_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
874 move_test/t77_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
875 move_test/t77_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
876 move_test/t77_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
877 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
878 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
879 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
880 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
881 === information_schema.files ===
882 Space_Name File_Type Engine Status Tablespace_Name Path
883 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
884 move_test/t55_restart TABLESPACE InnoDB NORMAL move_test/t55_restart MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
885 move_test/t66_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
886 move_test/t66_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
887 move_test/t66_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
888 move_test/t77_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
889 move_test/t77_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
890 move_test/t77_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
891 move_test/t77_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
892 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
893 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
894 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
895 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
896 INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
897 SELECT count(*) FROM t55_restart;
898 count(*)
899 32
900 SHOW CREATE TABLE t55_restart;
901 Table Create Table
902 t55_restart CREATE TABLE `t55_restart` (
903 `c1` double NOT NULL AUTO_INCREMENT,
904 `c2` char(10) DEFAULT NULL,
905 `c3` varchar(100) DEFAULT NULL,
906 `c4` date DEFAULT NULL,
907 `c5` text,
908 PRIMARY KEY (`c1`)
909 ) ENGINE=InnoDB AUTO_INCREMENT=1000000048 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
910 INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
911 SELECT count(*) FROM t66_restart;
912 count(*)
913 84
914 SHOW CREATE TABLE t66_restart;
915 Table Create Table
916 t66_restart CREATE TABLE `t66_restart` (
917 `c1` int NOT NULL AUTO_INCREMENT,
918 `c2` char(10) DEFAULT NULL,
919 `c3` varchar(100) DEFAULT NULL,
920 `c4` date DEFAULT NULL,
921 `c5` text,
922 PRIMARY KEY (`c1`)
923 ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
924 /*!50100 PARTITION BY HASH (`c1`)
925 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
926 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
927 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
928 INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
929 SELECT count(*) FROM t77_restart;
930 count(*)
931 36
932 SHOW CREATE TABLE t77_restart;
933 Table Create Table
934 t77_restart CREATE TABLE `t77_restart` (
935 `c1` int NOT NULL AUTO_INCREMENT,
936 `c2` char(10) DEFAULT NULL,
937 `c3` varchar(100) DEFAULT NULL,
938 `c4` date DEFAULT NULL,
939 `c5` text,
940 PRIMARY KEY (`c1`)
941 ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
942 /*!50100 PARTITION BY RANGE (`c1`)
943 SUBPARTITION BY HASH (`c1`)
944 (PARTITION p0 VALUES LESS THAN (10)
945 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
946 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
947 PARTITION p1 VALUES LESS THAN MAXVALUE
948 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
949 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
950 #
951 # Shutdown the server
952 #
953 ---- MYSQL_DATA_DIR/move_test
954 t4_restart.ibd
955 ---- ALT_DIR/move_test
956 t55_restart.ibd
957 t66_restart#p#p0.ibd
958 t66_restart#p#p1.ibd
959 t66_restart#p#p2.ibd
960 t77_restart#p#p0#sp#s0.ibd
961 t77_restart#p#p0#sp#s1.ibd
962 t77_restart#p#p1#sp#s2.ibd
963 t77_restart#p#p1#sp#s3.ibd
964 #
965 # Start the server and check tablespaces.
966 #
967 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
968 === information_schema.innodb_tablespaces and innodb_datafiles ===
969 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
970 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
971 move_test/t55_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
972 move_test/t66_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
973 move_test/t66_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
974 move_test/t66_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
975 move_test/t77_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
976 move_test/t77_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
977 move_test/t77_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
978 move_test/t77_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
979 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
980 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
981 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
982 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
983 === information_schema.files ===
984 Space_Name File_Type Engine Status Tablespace_Name Path
985 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
986 move_test/t55_restart TABLESPACE InnoDB NORMAL move_test/t55_restart MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
987 move_test/t66_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
988 move_test/t66_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
989 move_test/t66_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
990 move_test/t77_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
991 move_test/t77_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
992 move_test/t77_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
993 move_test/t77_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
994 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
995 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
996 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
997 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
998 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
999 SELECT count(*) FROM t4_restart;
1000 count(*)
1001 64
1002 SHOW CREATE TABLE t4_restart;
1003 Table Create Table
1004 t4_restart CREATE TABLE `t4_restart` (
1005 `c1` double NOT NULL AUTO_INCREMENT,
1006 `c2` char(10) DEFAULT NULL,
1007 `c3` varchar(100) DEFAULT NULL,
1008 `c4` date DEFAULT NULL,
1009 `c5` text,
1010 PRIMARY KEY (`c1`)
1011 ) ENGINE=InnoDB AUTO_INCREMENT=1000000099 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1012 INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
1013 SELECT count(*) FROM t55_restart;
1014 count(*)
1015 64
1016 SHOW CREATE TABLE t55_restart;
1017 Table Create Table
1018 t55_restart CREATE TABLE `t55_restart` (
1019 `c1` double NOT NULL AUTO_INCREMENT,
1020 `c2` char(10) DEFAULT NULL,
1021 `c3` varchar(100) DEFAULT NULL,
1022 `c4` date DEFAULT NULL,
1023 `c5` text,
1024 PRIMARY KEY (`c1`)
1025 ) ENGINE=InnoDB AUTO_INCREMENT=1000000096 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
1026 INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
1027 SELECT count(*) FROM t66_restart;
1028 count(*)
1029 168
1030 SHOW CREATE TABLE t66_restart;
1031 Table Create Table
1032 t66_restart CREATE TABLE `t66_restart` (
1033 `c1` int NOT NULL AUTO_INCREMENT,
1034 `c2` char(10) DEFAULT NULL,
1035 `c3` varchar(100) DEFAULT NULL,
1036 `c4` date DEFAULT NULL,
1037 `c5` text,
1038 PRIMARY KEY (`c1`)
1039 ) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
1040 /*!50100 PARTITION BY HASH (`c1`)
1041 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1042 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1043 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
1044 INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
1045 SELECT count(*) FROM t77_restart;
1046 count(*)
1047 72
1048 SHOW CREATE TABLE t77_restart;
1049 Table Create Table
1050 t77_restart CREATE TABLE `t77_restart` (
1051 `c1` int NOT NULL AUTO_INCREMENT,
1052 `c2` char(10) DEFAULT NULL,
1053 `c3` varchar(100) DEFAULT NULL,
1054 `c4` date DEFAULT NULL,
1055 `c5` text,
1056 PRIMARY KEY (`c1`)
1057 ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1058 /*!50100 PARTITION BY RANGE (`c1`)
1059 SUBPARTITION BY HASH (`c1`)
1060 (PARTITION p0 VALUES LESS THAN (10)
1061 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1062 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
1063 PARTITION p1 VALUES LESS THAN MAXVALUE
1064 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1065 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
1066 #
1067 # Shutdown the server
1068 #
1069 #
1070 # Start the server and check tablespaces.
1071 #
1072 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir
1073 === information_schema.innodb_tablespaces and innodb_datafiles ===
1074 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
1075 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
1076 move_test/t55_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
1077 move_test/t66_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
1078 move_test/t66_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
1079 move_test/t66_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
1080 move_test/t77_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
1081 move_test/t77_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
1082 move_test/t77_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
1083 move_test/t77_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
1084 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1085 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
1086 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1087 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
1088 === information_schema.files ===
1089 Space_Name File_Type Engine Status Tablespace_Name Path
1090 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
1091 move_test/t55_restart TABLESPACE InnoDB NORMAL move_test/t55_restart MYSQL_TMP_DIR/alt_dir/move_test/t55_restart.ibd
1092 move_test/t66_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p0 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p0.ibd
1093 move_test/t66_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p1 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p1.ibd
1094 move_test/t66_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p2 MYSQL_TMP_DIR/alt_dir/move_test/t66_restart#p#p2.ibd
1095 move_test/t77_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s0.ibd
1096 move_test/t77_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p0#sp#s1.ibd
1097 move_test/t77_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s2.ibd
1098 move_test/t77_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir/move_test/t77_restart#p#p1#sp#s3.ibd
1099 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1100 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
1101 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1102 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
1103 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
1104 SELECT count(*) FROM t4_restart;
1105 count(*)
1106 128
1107 SHOW CREATE TABLE t4_restart;
1108 Table Create Table
1109 t4_restart CREATE TABLE `t4_restart` (
1110 `c1` double NOT NULL AUTO_INCREMENT,
1111 `c2` char(10) DEFAULT NULL,
1112 `c3` varchar(100) DEFAULT NULL,
1113 `c4` date DEFAULT NULL,
1114 `c5` text,
1115 PRIMARY KEY (`c1`)
1116 ) ENGINE=InnoDB AUTO_INCREMENT=1000000195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1117 INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
1118 SELECT count(*) FROM t55_restart;
1119 count(*)
1120 128
1121 SHOW CREATE TABLE t55_restart;
1122 Table Create Table
1123 t55_restart CREATE TABLE `t55_restart` (
1124 `c1` double NOT NULL AUTO_INCREMENT,
1125 `c2` char(10) DEFAULT NULL,
1126 `c3` varchar(100) DEFAULT NULL,
1127 `c4` date DEFAULT NULL,
1128 `c5` text,
1129 PRIMARY KEY (`c1`)
1130 ) ENGINE=InnoDB AUTO_INCREMENT=1000000192 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir/'
1131 INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
1132 SELECT count(*) FROM t66_restart;
1133 count(*)
1134 336
1135 SHOW CREATE TABLE t66_restart;
1136 Table Create Table
1137 t66_restart CREATE TABLE `t66_restart` (
1138 `c1` int NOT NULL AUTO_INCREMENT,
1139 `c2` char(10) DEFAULT NULL,
1140 `c3` varchar(100) DEFAULT NULL,
1141 `c4` date DEFAULT NULL,
1142 `c5` text,
1143 PRIMARY KEY (`c1`)
1144 ) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
1145 /*!50100 PARTITION BY HASH (`c1`)
1146 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1147 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1148 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB) */
1149 INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
1150 SELECT count(*) FROM t77_restart;
1151 count(*)
1152 144
1153 SHOW CREATE TABLE t77_restart;
1154 Table Create Table
1155 t77_restart CREATE TABLE `t77_restart` (
1156 `c1` int NOT NULL AUTO_INCREMENT,
1157 `c2` char(10) DEFAULT NULL,
1158 `c3` varchar(100) DEFAULT NULL,
1159 `c4` date DEFAULT NULL,
1160 `c5` text,
1161 PRIMARY KEY (`c1`)
1162 ) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1163 /*!50100 PARTITION BY RANGE (`c1`)
1164 SUBPARTITION BY HASH (`c1`)
1165 (PARTITION p0 VALUES LESS THAN (10)
1166 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1167 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB),
1168 PARTITION p1 VALUES LESS THAN MAXVALUE
1169 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB,
1170 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir' ENGINE = InnoDB)) */
1171 #
1172 # Shutdown the server
1173 # Move all the files form ALT_DIR to ALT_DIR_MOVED
1174 #
1175 # Moving files
1176 t55_restart.ibd
1177 t66_restart#p#p0.ibd
1178 t66_restart#p#p1.ibd
1179 t66_restart#p#p2.ibd
1180 t77_restart#p#p0#sp#s0.ibd
1181 t77_restart#p#p0#sp#s1.ibd
1182 t77_restart#p#p1#sp#s2.ibd
1183 t77_restart#p#p1#sp#s3.ibd
1184 #
1185 # Start the server and check tablespaces.
1186 #
1187 # restart:--innodb-directories=MYSQL_TMP_DIR/alt_dir_moved
1188 INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
1189 SELECT count(*) FROM t4_restart;
1190 count(*)
1191 256
1192 SHOW CREATE TABLE t4_restart;
1193 Table Create Table
1194 t4_restart CREATE TABLE `t4_restart` (
1195 `c1` double NOT NULL AUTO_INCREMENT,
1196 `c2` char(10) DEFAULT NULL,
1197 `c3` varchar(100) DEFAULT NULL,
1198 `c4` date DEFAULT NULL,
1199 `c5` text,
1200 PRIMARY KEY (`c1`)
1201 ) ENGINE=InnoDB AUTO_INCREMENT=1000000387 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1202 INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
1203 SELECT count(*) FROM t55_restart;
1204 count(*)
1205 256
1206 SHOW CREATE TABLE t55_restart;
1207 Table Create Table
1208 t55_restart CREATE TABLE `t55_restart` (
1209 `c1` double NOT NULL AUTO_INCREMENT,
1210 `c2` char(10) DEFAULT NULL,
1211 `c3` varchar(100) DEFAULT NULL,
1212 `c4` date DEFAULT NULL,
1213 `c5` text,
1214 PRIMARY KEY (`c1`)
1215 ) ENGINE=InnoDB AUTO_INCREMENT=1000000384 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir_moved/'
1216 INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
1217 SELECT count(*) FROM t66_restart;
1218 count(*)
1219 672
1220 SHOW CREATE TABLE t66_restart;
1221 Table Create Table
1222 t66_restart CREATE TABLE `t66_restart` (
1223 `c1` int NOT NULL AUTO_INCREMENT,
1224 `c2` char(10) DEFAULT NULL,
1225 `c3` varchar(100) DEFAULT NULL,
1226 `c4` date DEFAULT NULL,
1227 `c5` text,
1228 PRIMARY KEY (`c1`)
1229 ) ENGINE=InnoDB AUTO_INCREMENT=684 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2
1230 /*!50100 PARTITION BY HASH (`c1`)
1231 (PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB,
1232 PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB,
1233 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB) */
1234 INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
1235 SELECT count(*) FROM t77_restart;
1236 count(*)
1237 288
1238 SHOW CREATE TABLE t77_restart;
1239 Table Create Table
1240 t77_restart CREATE TABLE `t77_restart` (
1241 `c1` int NOT NULL AUTO_INCREMENT,
1242 `c2` char(10) DEFAULT NULL,
1243 `c3` varchar(100) DEFAULT NULL,
1244 `c4` date DEFAULT NULL,
1245 `c5` text,
1246 PRIMARY KEY (`c1`)
1247 ) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1248 /*!50100 PARTITION BY RANGE (`c1`)
1249 SUBPARTITION BY HASH (`c1`)
1250 (PARTITION p0 VALUES LESS THAN (10)
1251 (SUBPARTITION s0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB,
1252 SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB),
1253 PARTITION p1 VALUES LESS THAN MAXVALUE
1254 (SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB,
1255 SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/alt_dir_moved' ENGINE = InnoDB)) */
1256 #
1257 # Show these tables in information_schema with the updated path
1258 #
1259 === information_schema.innodb_tables and innodb_tablespaces ===
1260 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
1261 move_test/t4_restart move_test/t4_restart 33 8 Dynamic 0 Single
1262 move_test/t55_restart move_test/t55_restart 97 8 Dynamic 0 Single
1263 move_test/t66_restart#p#p0 move_test/t66_restart#p#p0 101 8 Compressed 2048 Single
1264 move_test/t66_restart#p#p1 move_test/t66_restart#p#p1 101 8 Compressed 2048 Single
1265 move_test/t66_restart#p#p2 move_test/t66_restart#p#p2 101 8 Compressed 2048 Single
1266 move_test/t77_restart#p#p0#sp#s0 move_test/t77_restart#p#p0#sp#s0 97 8 Dynamic 0 Single
1267 move_test/t77_restart#p#p0#sp#s1 move_test/t77_restart#p#p0#sp#s1 97 8 Dynamic 0 Single
1268 move_test/t77_restart#p#p1#sp#s2 move_test/t77_restart#p#p1#sp#s2 97 8 Dynamic 0 Single
1269 move_test/t77_restart#p#p1#sp#s3 move_test/t77_restart#p#p1#sp#s3 97 8 Dynamic 0 Single
1270 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
1271 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
1272 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
1273 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
1274 === information_schema.innodb_tablespaces and innodb_datafiles ===
1275 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
1276 move_test/t4_restart Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/move_test/t4_restart.ibd
1277 move_test/t55_restart Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_moved/move_test/t55_restart.ibd
1278 move_test/t66_restart#p#p0 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p0.ibd
1279 move_test/t66_restart#p#p1 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p1.ibd
1280 move_test/t66_restart#p#p2 Single DEFAULT 2048 1 1 Compressed MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p2.ibd
1281 move_test/t77_restart#p#p0#sp#s0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p0#sp#s0.ibd
1282 move_test/t77_restart#p#p0#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p0#sp#s1.ibd
1283 move_test/t77_restart#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p1#sp#s2.ibd
1284 move_test/t77_restart#p#p1#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p1#sp#s3.ibd
1285 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1286 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
1287 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1288 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
1289 === information_schema.files ===
1290 Space_Name File_Type Engine Status Tablespace_Name Path
1291 move_test/t4_restart TABLESPACE InnoDB NORMAL move_test/t4_restart MYSQLD_DATADIR/move_test/t4_restart.ibd
1292 move_test/t55_restart TABLESPACE InnoDB NORMAL move_test/t55_restart MYSQL_TMP_DIR/alt_dir_moved/move_test/t55_restart.ibd
1293 move_test/t66_restart#p#p0 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p0 MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p0.ibd
1294 move_test/t66_restart#p#p1 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p1 MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p1.ibd
1295 move_test/t66_restart#p#p2 TABLESPACE InnoDB NORMAL move_test/t66_restart#p#p2 MYSQL_TMP_DIR/alt_dir_moved/move_test/t66_restart#p#p2.ibd
1296 move_test/t77_restart#p#p0#sp#s0 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s0 MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p0#sp#s0.ibd
1297 move_test/t77_restart#p#p0#sp#s1 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p0#sp#s1 MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p0#sp#s1.ibd
1298 move_test/t77_restart#p#p1#sp#s2 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s2 MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p1#sp#s2.ibd
1299 move_test/t77_restart#p#p1#sp#s3 TABLESPACE InnoDB NORMAL move_test/t77_restart#p#p1#sp#s3 MYSQL_TMP_DIR/alt_dir_moved/move_test/t77_restart#p#p1#sp#s3.ibd
1300 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
1301 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
1302 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
1303 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
1304 #
1305 # Cleanup
1306 #
1307 DROP DATABASE move_test;
1308 # restart
1309 set global innodb_file_per_table=1;