Debian Codegraph @

mysql-test/suite/innodb_fts/r/tablespace_location.result

raw
1 #
2 # BUG#20527217 - INNODB: PUT FTS AUXILIARY TABLES INTO THE SAME GENERAL
3 # TABLESPACE AS THE PRIMARY
4 #
5 SET DEFAULT_STORAGE_ENGINE=InnoDB;
6 SET GLOBAL innodb_file_per_table = ON;
7 SHOW VARIABLES LIKE 'innodb_file_per_table';
8 Variable_name Value
9 innodb_file_per_table ON
10 # Strict-mode has no affect on CREATE TABLESPACE.
11 # It rejects all invalid input, as if strict mode is always ON.
12 SET SESSION innodb_strict_mode = OFF;
13 SHOW VARIABLES LIKE 'innodb_strict_mode';
14 Variable_name Value
15 innodb_strict_mode OFF
16 CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd';
17 CREATE TABLESPACE s_zip ADD DATAFILE 's_zip.ibd' FILE_BLOCK_SIZE=2k;
18 === information_schema.innodb_tablespaces and innodb_datafiles ===
19 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
20 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
21 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
22 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
23 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
24 s_def General DEFAULT 0 1 1 Any s_def.ibd
25 s_zip General DEFAULT 2048 1 1 Compressed s_zip.ibd
26 === information_schema.files ===
27 Space_Name File_Type Engine Status Tablespace_Name Path
28 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
29 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
30 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
31 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
32 s_def TABLESPACE InnoDB NORMAL s_def MYSQLD_DATADIR/s_def.ibd
33 s_zip TABLESPACE InnoDB NORMAL s_zip MYSQLD_DATADIR/s_zip.ibd
34 #
35 # tablespace=s_def row_format=redundant
36 #
37 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=redundant ;
38 === information_schema.innodb_tables and innodb_tablespaces ===
39 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
40 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
41 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
42 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
43 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
44 test/fts_aux_index_1 s_def 128 8 Redundant 0 General
45 test/fts_aux_index_2 s_def 128 8 Redundant 0 General
46 test/fts_aux_index_3 s_def 128 8 Redundant 0 General
47 test/fts_aux_index_4 s_def 128 8 Redundant 0 General
48 test/fts_aux_index_5 s_def 128 8 Redundant 0 General
49 test/fts_aux_index_6 s_def 128 8 Redundant 0 General
50 test/fts_aux_being_deleted s_def 128 4 Redundant 0 General
51 test/fts_aux_being_deleted_cache s_def 128 4 Redundant 0 General
52 test/fts_aux_config s_def 128 5 Redundant 0 General
53 test/fts_aux_deleted s_def 128 4 Redundant 0 General
54 test/fts_aux_deleted_cache s_def 128 4 Redundant 0 General
55 test/t1 s_def 128 6 Redundant 0 General
56 INSERT INTO t1 (a,b) VALUES
57 ('MySQL Tutorial','DBMS stands for DataBase') ,
58 ('How To Use MySQL Well','After you went through a'),
59 ('Optimizing MySQL','In this tutorial we will show');
60 INSERT INTO t1 (a,b) VALUES
61 ('1001 MySQL Tricks','1. Never run mysqld as root'),
62 ('MySQL vs. YourSQL','In the following database comparison'),
63 ('MySQL Security','When configured properly, MySQL');
64 SELECT * FROM t1 WHERE MATCH (a,b)
65 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
66 a b
67 MySQL Tutorial DBMS stands for DataBase
68 Optimizing MySQL In this tutorial we will show
69 TRUNCATE TABLE t1;
70 === information_schema.innodb_tables and innodb_tablespaces ===
71 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
72 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
73 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
74 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
75 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
76 test/fts_aux_index_1 s_def 128 8 Redundant 0 General
77 test/fts_aux_index_2 s_def 128 8 Redundant 0 General
78 test/fts_aux_index_3 s_def 128 8 Redundant 0 General
79 test/fts_aux_index_4 s_def 128 8 Redundant 0 General
80 test/fts_aux_index_5 s_def 128 8 Redundant 0 General
81 test/fts_aux_index_6 s_def 128 8 Redundant 0 General
82 test/fts_aux_being_deleted s_def 128 4 Redundant 0 General
83 test/fts_aux_being_deleted_cache s_def 128 4 Redundant 0 General
84 test/fts_aux_config s_def 128 5 Redundant 0 General
85 test/fts_aux_deleted s_def 128 4 Redundant 0 General
86 test/fts_aux_deleted_cache s_def 128 4 Redundant 0 General
87 test/t1 s_def 128 6 Redundant 0 General
88 INSERT INTO t1 (a,b) VALUES
89 ('MySQL Tutorial','DBMS stands for DataBase') ,
90 ('How To Use MySQL Well','After you went through a'),
91 ('Optimizing MySQL','In this tutorial we will show');
92 INSERT INTO t1 (a,b) VALUES
93 ('1001 MySQL Tricks','1. Never run mysqld as root'),
94 ('MySQL vs. YourSQL','In the following database comparison'),
95 ('MySQL Security','When configured properly, MySQL');
96 SELECT * FROM t1 WHERE MATCH (a,b)
97 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
98 a b
99 MySQL Tutorial DBMS stands for DataBase
100 Optimizing MySQL In this tutorial we will show
101 DROP TABLE t1;
102 #
103 # tablespace=s_def row_format=compact
104 #
105 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=compact ;
106 === information_schema.innodb_tables and innodb_tablespaces ===
107 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
108 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
109 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
110 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
111 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
112 test/fts_aux_index_1 s_def 129 8 Compact 0 General
113 test/fts_aux_index_2 s_def 129 8 Compact 0 General
114 test/fts_aux_index_3 s_def 129 8 Compact 0 General
115 test/fts_aux_index_4 s_def 129 8 Compact 0 General
116 test/fts_aux_index_5 s_def 129 8 Compact 0 General
117 test/fts_aux_index_6 s_def 129 8 Compact 0 General
118 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
119 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
120 test/fts_aux_config s_def 129 5 Compact 0 General
121 test/fts_aux_deleted s_def 129 4 Compact 0 General
122 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
123 test/t1 s_def 129 6 Compact 0 General
124 INSERT INTO t1 (a,b) VALUES
125 ('MySQL Tutorial','DBMS stands for DataBase') ,
126 ('How To Use MySQL Well','After you went through a'),
127 ('Optimizing MySQL','In this tutorial we will show');
128 INSERT INTO t1 (a,b) VALUES
129 ('1001 MySQL Tricks','1. Never run mysqld as root'),
130 ('MySQL vs. YourSQL','In the following database comparison'),
131 ('MySQL Security','When configured properly, MySQL');
132 SELECT * FROM t1 WHERE MATCH (a,b)
133 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
134 a b
135 MySQL Tutorial DBMS stands for DataBase
136 Optimizing MySQL In this tutorial we will show
137 TRUNCATE TABLE t1;
138 === information_schema.innodb_tables and innodb_tablespaces ===
139 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
140 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
141 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
142 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
143 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
144 test/fts_aux_index_1 s_def 129 8 Compact 0 General
145 test/fts_aux_index_2 s_def 129 8 Compact 0 General
146 test/fts_aux_index_3 s_def 129 8 Compact 0 General
147 test/fts_aux_index_4 s_def 129 8 Compact 0 General
148 test/fts_aux_index_5 s_def 129 8 Compact 0 General
149 test/fts_aux_index_6 s_def 129 8 Compact 0 General
150 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
151 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
152 test/fts_aux_config s_def 129 5 Compact 0 General
153 test/fts_aux_deleted s_def 129 4 Compact 0 General
154 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
155 test/t1 s_def 129 6 Compact 0 General
156 INSERT INTO t1 (a,b) VALUES
157 ('MySQL Tutorial','DBMS stands for DataBase') ,
158 ('How To Use MySQL Well','After you went through a'),
159 ('Optimizing MySQL','In this tutorial we will show');
160 INSERT INTO t1 (a,b) VALUES
161 ('1001 MySQL Tricks','1. Never run mysqld as root'),
162 ('MySQL vs. YourSQL','In the following database comparison'),
163 ('MySQL Security','When configured properly, MySQL');
164 SELECT * FROM t1 WHERE MATCH (a,b)
165 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
166 a b
167 MySQL Tutorial DBMS stands for DataBase
168 Optimizing MySQL In this tutorial we will show
169 DROP TABLE t1;
170 #
171 # tablespace=s_def row_format=dynamic
172 #
173 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def ROW_FORMAT=dynamic ;
174 === information_schema.innodb_tables and innodb_tablespaces ===
175 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
176 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
177 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
178 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
179 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
180 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
181 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
182 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
183 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
184 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
185 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
186 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
187 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
188 test/fts_aux_config s_def 161 5 Dynamic 0 General
189 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
190 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
191 test/t1 s_def 161 6 Dynamic 0 General
192 INSERT INTO t1 (a,b) VALUES
193 ('MySQL Tutorial','DBMS stands for DataBase') ,
194 ('How To Use MySQL Well','After you went through a'),
195 ('Optimizing MySQL','In this tutorial we will show');
196 INSERT INTO t1 (a,b) VALUES
197 ('1001 MySQL Tricks','1. Never run mysqld as root'),
198 ('MySQL vs. YourSQL','In the following database comparison'),
199 ('MySQL Security','When configured properly, MySQL');
200 SELECT * FROM t1 WHERE MATCH (a,b)
201 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
202 a b
203 MySQL Tutorial DBMS stands for DataBase
204 Optimizing MySQL In this tutorial we will show
205 TRUNCATE TABLE t1;
206 === information_schema.innodb_tables and innodb_tablespaces ===
207 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
208 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
209 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
210 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
211 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
212 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
213 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
214 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
215 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
216 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
217 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
218 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
219 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
220 test/fts_aux_config s_def 161 5 Dynamic 0 General
221 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
222 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
223 test/t1 s_def 161 6 Dynamic 0 General
224 INSERT INTO t1 (a,b) VALUES
225 ('MySQL Tutorial','DBMS stands for DataBase') ,
226 ('How To Use MySQL Well','After you went through a'),
227 ('Optimizing MySQL','In this tutorial we will show');
228 INSERT INTO t1 (a,b) VALUES
229 ('1001 MySQL Tricks','1. Never run mysqld as root'),
230 ('MySQL vs. YourSQL','In the following database comparison'),
231 ('MySQL Security','When configured properly, MySQL');
232 SELECT * FROM t1 WHERE MATCH (a,b)
233 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
234 a b
235 MySQL Tutorial DBMS stands for DataBase
236 Optimizing MySQL In this tutorial we will show
237 DROP TABLE t1;
238 #
239 # tablespace=s_zip row_format=compressed KEY_BLOCK_SIZE=2
240 #
241 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_zip ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
242 === information_schema.innodb_tables and innodb_tablespaces ===
243 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
244 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
245 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
246 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
247 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
248 test/fts_aux_index_1 s_zip 165 8 Compressed 2048 General
249 test/fts_aux_index_2 s_zip 165 8 Compressed 2048 General
250 test/fts_aux_index_3 s_zip 165 8 Compressed 2048 General
251 test/fts_aux_index_4 s_zip 165 8 Compressed 2048 General
252 test/fts_aux_index_5 s_zip 165 8 Compressed 2048 General
253 test/fts_aux_index_6 s_zip 165 8 Compressed 2048 General
254 test/fts_aux_being_deleted s_zip 165 4 Compressed 2048 General
255 test/fts_aux_being_deleted_cache s_zip 165 4 Compressed 2048 General
256 test/fts_aux_config s_zip 165 5 Compressed 2048 General
257 test/fts_aux_deleted s_zip 165 4 Compressed 2048 General
258 test/fts_aux_deleted_cache s_zip 165 4 Compressed 2048 General
259 test/t1 s_zip 165 6 Compressed 2048 General
260 INSERT INTO t1 (a,b) VALUES
261 ('MySQL Tutorial','DBMS stands for DataBase') ,
262 ('How To Use MySQL Well','After you went through a'),
263 ('Optimizing MySQL','In this tutorial we will show');
264 INSERT INTO t1 (a,b) VALUES
265 ('1001 MySQL Tricks','1. Never run mysqld as root'),
266 ('MySQL vs. YourSQL','In the following database comparison'),
267 ('MySQL Security','When configured properly, MySQL');
268 SELECT * FROM t1 WHERE MATCH (a,b)
269 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
270 a b
271 MySQL Tutorial DBMS stands for DataBase
272 Optimizing MySQL In this tutorial we will show
273 TRUNCATE TABLE t1;
274 === information_schema.innodb_tables and innodb_tablespaces ===
275 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
276 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
277 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
278 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
279 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
280 test/fts_aux_index_1 s_zip 165 8 Compressed 2048 General
281 test/fts_aux_index_2 s_zip 165 8 Compressed 2048 General
282 test/fts_aux_index_3 s_zip 165 8 Compressed 2048 General
283 test/fts_aux_index_4 s_zip 165 8 Compressed 2048 General
284 test/fts_aux_index_5 s_zip 165 8 Compressed 2048 General
285 test/fts_aux_index_6 s_zip 165 8 Compressed 2048 General
286 test/fts_aux_being_deleted s_zip 165 4 Compressed 2048 General
287 test/fts_aux_being_deleted_cache s_zip 165 4 Compressed 2048 General
288 test/fts_aux_config s_zip 165 5 Compressed 2048 General
289 test/fts_aux_deleted s_zip 165 4 Compressed 2048 General
290 test/fts_aux_deleted_cache s_zip 165 4 Compressed 2048 General
291 test/t1 s_zip 165 6 Compressed 2048 General
292 INSERT INTO t1 (a,b) VALUES
293 ('MySQL Tutorial','DBMS stands for DataBase') ,
294 ('How To Use MySQL Well','After you went through a'),
295 ('Optimizing MySQL','In this tutorial we will show');
296 INSERT INTO t1 (a,b) VALUES
297 ('1001 MySQL Tricks','1. Never run mysqld as root'),
298 ('MySQL vs. YourSQL','In the following database comparison'),
299 ('MySQL Security','When configured properly, MySQL');
300 SELECT * FROM t1 WHERE MATCH (a,b)
301 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
302 a b
303 MySQL Tutorial DBMS stands for DataBase
304 Optimizing MySQL In this tutorial we will show
305 DROP TABLE t1;
306 #
307 # tablespace=innodb_file_per_table row_format=dynamic
308 #
309 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_file_per_table ROW_FORMAT=dynamic ;
310 === information_schema.innodb_tables and innodb_tablespaces ===
311 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
312 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
313 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
314 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
315 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
316 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
317 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
318 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
319 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
320 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
321 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
322 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
323 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
324 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
325 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
326 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
327 test/t1 test/t1 33 6 Dynamic 0 Single
328 INSERT INTO t1 (a,b) VALUES
329 ('MySQL Tutorial','DBMS stands for DataBase') ,
330 ('How To Use MySQL Well','After you went through a'),
331 ('Optimizing MySQL','In this tutorial we will show');
332 INSERT INTO t1 (a,b) VALUES
333 ('1001 MySQL Tricks','1. Never run mysqld as root'),
334 ('MySQL vs. YourSQL','In the following database comparison'),
335 ('MySQL Security','When configured properly, MySQL');
336 SELECT * FROM t1 WHERE MATCH (a,b)
337 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
338 a b
339 MySQL Tutorial DBMS stands for DataBase
340 Optimizing MySQL In this tutorial we will show
341 TRUNCATE TABLE t1;
342 === information_schema.innodb_tables and innodb_tablespaces ===
343 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
344 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
345 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
346 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
347 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
348 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
349 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
350 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
351 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
352 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
353 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
354 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
355 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
356 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
357 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
358 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
359 test/t1 test/t1 33 6 Dynamic 0 Single
360 INSERT INTO t1 (a,b) VALUES
361 ('MySQL Tutorial','DBMS stands for DataBase') ,
362 ('How To Use MySQL Well','After you went through a'),
363 ('Optimizing MySQL','In this tutorial we will show');
364 INSERT INTO t1 (a,b) VALUES
365 ('1001 MySQL Tricks','1. Never run mysqld as root'),
366 ('MySQL vs. YourSQL','In the following database comparison'),
367 ('MySQL Security','When configured properly, MySQL');
368 SELECT * FROM t1 WHERE MATCH (a,b)
369 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
370 a b
371 MySQL Tutorial DBMS stands for DataBase
372 Optimizing MySQL In this tutorial we will show
373 DROP TABLE t1;
374 #
375 # tablespace=innodb_file_per_table row_format=compressed KEY_BLOCK_SIZE=2
376 #
377 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_file_per_table ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
378 === information_schema.innodb_tables and innodb_tablespaces ===
379 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
380 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
381 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
382 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
383 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
384 test/fts_aux_index_1 test/fts_aux_index_1 37 8 Compressed 2048 Single
385 test/fts_aux_index_2 test/fts_aux_index_2 37 8 Compressed 2048 Single
386 test/fts_aux_index_3 test/fts_aux_index_3 37 8 Compressed 2048 Single
387 test/fts_aux_index_4 test/fts_aux_index_4 37 8 Compressed 2048 Single
388 test/fts_aux_index_5 test/fts_aux_index_5 37 8 Compressed 2048 Single
389 test/fts_aux_index_6 test/fts_aux_index_6 37 8 Compressed 2048 Single
390 test/fts_aux_being_deleted test/fts_aux_being_deleted 37 4 Compressed 2048 Single
391 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 37 4 Compressed 2048 Single
392 test/fts_aux_config test/fts_aux_config 37 5 Compressed 2048 Single
393 test/fts_aux_deleted test/fts_aux_deleted 37 4 Compressed 2048 Single
394 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 37 4 Compressed 2048 Single
395 test/t1 test/t1 37 6 Compressed 2048 Single
396 INSERT INTO t1 (a,b) VALUES
397 ('MySQL Tutorial','DBMS stands for DataBase') ,
398 ('How To Use MySQL Well','After you went through a'),
399 ('Optimizing MySQL','In this tutorial we will show');
400 INSERT INTO t1 (a,b) VALUES
401 ('1001 MySQL Tricks','1. Never run mysqld as root'),
402 ('MySQL vs. YourSQL','In the following database comparison'),
403 ('MySQL Security','When configured properly, MySQL');
404 SELECT * FROM t1 WHERE MATCH (a,b)
405 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
406 a b
407 MySQL Tutorial DBMS stands for DataBase
408 Optimizing MySQL In this tutorial we will show
409 TRUNCATE TABLE t1;
410 === information_schema.innodb_tables and innodb_tablespaces ===
411 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
412 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
413 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
414 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
415 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
416 test/fts_aux_index_1 test/fts_aux_index_1 37 8 Compressed 2048 Single
417 test/fts_aux_index_2 test/fts_aux_index_2 37 8 Compressed 2048 Single
418 test/fts_aux_index_3 test/fts_aux_index_3 37 8 Compressed 2048 Single
419 test/fts_aux_index_4 test/fts_aux_index_4 37 8 Compressed 2048 Single
420 test/fts_aux_index_5 test/fts_aux_index_5 37 8 Compressed 2048 Single
421 test/fts_aux_index_6 test/fts_aux_index_6 37 8 Compressed 2048 Single
422 test/fts_aux_being_deleted test/fts_aux_being_deleted 37 4 Compressed 2048 Single
423 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 37 4 Compressed 2048 Single
424 test/fts_aux_config test/fts_aux_config 37 5 Compressed 2048 Single
425 test/fts_aux_deleted test/fts_aux_deleted 37 4 Compressed 2048 Single
426 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 37 4 Compressed 2048 Single
427 test/t1 test/t1 37 6 Compressed 2048 Single
428 INSERT INTO t1 (a,b) VALUES
429 ('MySQL Tutorial','DBMS stands for DataBase') ,
430 ('How To Use MySQL Well','After you went through a'),
431 ('Optimizing MySQL','In this tutorial we will show');
432 INSERT INTO t1 (a,b) VALUES
433 ('1001 MySQL Tricks','1. Never run mysqld as root'),
434 ('MySQL vs. YourSQL','In the following database comparison'),
435 ('MySQL Security','When configured properly, MySQL');
436 SELECT * FROM t1 WHERE MATCH (a,b)
437 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
438 a b
439 MySQL Tutorial DBMS stands for DataBase
440 Optimizing MySQL In this tutorial we will show
441 DROP TABLE t1;
442 #
443 # tablespace=innodb_system row_format=redundant
444 #
445 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=redundant ;
446 === information_schema.innodb_tables and innodb_tablespaces ===
447 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
448 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
449 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
450 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
451 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
452 test/fts_aux_index_1 innodb_system 128 8 Redundant 0 System
453 test/fts_aux_index_2 innodb_system 128 8 Redundant 0 System
454 test/fts_aux_index_3 innodb_system 128 8 Redundant 0 System
455 test/fts_aux_index_4 innodb_system 128 8 Redundant 0 System
456 test/fts_aux_index_5 innodb_system 128 8 Redundant 0 System
457 test/fts_aux_index_6 innodb_system 128 8 Redundant 0 System
458 test/fts_aux_being_deleted innodb_system 128 4 Redundant 0 System
459 test/fts_aux_being_deleted_cache innodb_system 128 4 Redundant 0 System
460 test/fts_aux_config innodb_system 128 5 Redundant 0 System
461 test/fts_aux_deleted innodb_system 128 4 Redundant 0 System
462 test/fts_aux_deleted_cache innodb_system 128 4 Redundant 0 System
463 test/t1 innodb_system 128 6 Redundant 0 System
464 INSERT INTO t1 (a,b) VALUES
465 ('MySQL Tutorial','DBMS stands for DataBase') ,
466 ('How To Use MySQL Well','After you went through a'),
467 ('Optimizing MySQL','In this tutorial we will show');
468 INSERT INTO t1 (a,b) VALUES
469 ('1001 MySQL Tricks','1. Never run mysqld as root'),
470 ('MySQL vs. YourSQL','In the following database comparison'),
471 ('MySQL Security','When configured properly, MySQL');
472 SELECT * FROM t1 WHERE MATCH (a,b)
473 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
474 a b
475 MySQL Tutorial DBMS stands for DataBase
476 Optimizing MySQL In this tutorial we will show
477 TRUNCATE TABLE t1;
478 === information_schema.innodb_tables and innodb_tablespaces ===
479 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
480 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
481 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
482 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
483 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
484 test/fts_aux_index_1 innodb_system 128 8 Redundant 0 System
485 test/fts_aux_index_2 innodb_system 128 8 Redundant 0 System
486 test/fts_aux_index_3 innodb_system 128 8 Redundant 0 System
487 test/fts_aux_index_4 innodb_system 128 8 Redundant 0 System
488 test/fts_aux_index_5 innodb_system 128 8 Redundant 0 System
489 test/fts_aux_index_6 innodb_system 128 8 Redundant 0 System
490 test/fts_aux_being_deleted innodb_system 128 4 Redundant 0 System
491 test/fts_aux_being_deleted_cache innodb_system 128 4 Redundant 0 System
492 test/fts_aux_config innodb_system 128 5 Redundant 0 System
493 test/fts_aux_deleted innodb_system 128 4 Redundant 0 System
494 test/fts_aux_deleted_cache innodb_system 128 4 Redundant 0 System
495 test/t1 innodb_system 128 6 Redundant 0 System
496 INSERT INTO t1 (a,b) VALUES
497 ('MySQL Tutorial','DBMS stands for DataBase') ,
498 ('How To Use MySQL Well','After you went through a'),
499 ('Optimizing MySQL','In this tutorial we will show');
500 INSERT INTO t1 (a,b) VALUES
501 ('1001 MySQL Tricks','1. Never run mysqld as root'),
502 ('MySQL vs. YourSQL','In the following database comparison'),
503 ('MySQL Security','When configured properly, MySQL');
504 SELECT * FROM t1 WHERE MATCH (a,b)
505 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
506 a b
507 MySQL Tutorial DBMS stands for DataBase
508 Optimizing MySQL In this tutorial we will show
509 DROP TABLE t1;
510 #
511 # tablespace=innodb_system row_format=compact
512 #
513 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=compact ;
514 === information_schema.innodb_tables and innodb_tablespaces ===
515 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
516 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
517 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
518 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
519 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
520 test/fts_aux_index_1 innodb_system 129 8 Compact 0 System
521 test/fts_aux_index_2 innodb_system 129 8 Compact 0 System
522 test/fts_aux_index_3 innodb_system 129 8 Compact 0 System
523 test/fts_aux_index_4 innodb_system 129 8 Compact 0 System
524 test/fts_aux_index_5 innodb_system 129 8 Compact 0 System
525 test/fts_aux_index_6 innodb_system 129 8 Compact 0 System
526 test/fts_aux_being_deleted innodb_system 129 4 Compact 0 System
527 test/fts_aux_being_deleted_cache innodb_system 129 4 Compact 0 System
528 test/fts_aux_config innodb_system 129 5 Compact 0 System
529 test/fts_aux_deleted innodb_system 129 4 Compact 0 System
530 test/fts_aux_deleted_cache innodb_system 129 4 Compact 0 System
531 test/t1 innodb_system 129 6 Compact 0 System
532 INSERT INTO t1 (a,b) VALUES
533 ('MySQL Tutorial','DBMS stands for DataBase') ,
534 ('How To Use MySQL Well','After you went through a'),
535 ('Optimizing MySQL','In this tutorial we will show');
536 INSERT INTO t1 (a,b) VALUES
537 ('1001 MySQL Tricks','1. Never run mysqld as root'),
538 ('MySQL vs. YourSQL','In the following database comparison'),
539 ('MySQL Security','When configured properly, MySQL');
540 SELECT * FROM t1 WHERE MATCH (a,b)
541 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
542 a b
543 MySQL Tutorial DBMS stands for DataBase
544 Optimizing MySQL In this tutorial we will show
545 TRUNCATE TABLE t1;
546 === information_schema.innodb_tables and innodb_tablespaces ===
547 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
548 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
549 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
550 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
551 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
552 test/fts_aux_index_1 innodb_system 129 8 Compact 0 System
553 test/fts_aux_index_2 innodb_system 129 8 Compact 0 System
554 test/fts_aux_index_3 innodb_system 129 8 Compact 0 System
555 test/fts_aux_index_4 innodb_system 129 8 Compact 0 System
556 test/fts_aux_index_5 innodb_system 129 8 Compact 0 System
557 test/fts_aux_index_6 innodb_system 129 8 Compact 0 System
558 test/fts_aux_being_deleted innodb_system 129 4 Compact 0 System
559 test/fts_aux_being_deleted_cache innodb_system 129 4 Compact 0 System
560 test/fts_aux_config innodb_system 129 5 Compact 0 System
561 test/fts_aux_deleted innodb_system 129 4 Compact 0 System
562 test/fts_aux_deleted_cache innodb_system 129 4 Compact 0 System
563 test/t1 innodb_system 129 6 Compact 0 System
564 INSERT INTO t1 (a,b) VALUES
565 ('MySQL Tutorial','DBMS stands for DataBase') ,
566 ('How To Use MySQL Well','After you went through a'),
567 ('Optimizing MySQL','In this tutorial we will show');
568 INSERT INTO t1 (a,b) VALUES
569 ('1001 MySQL Tricks','1. Never run mysqld as root'),
570 ('MySQL vs. YourSQL','In the following database comparison'),
571 ('MySQL Security','When configured properly, MySQL');
572 SELECT * FROM t1 WHERE MATCH (a,b)
573 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
574 a b
575 MySQL Tutorial DBMS stands for DataBase
576 Optimizing MySQL In this tutorial we will show
577 DROP TABLE t1;
578 #
579 # tablespace=innodb_system row_format=dynamic
580 #
581 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=innodb_system ROW_FORMAT=dynamic ;
582 === information_schema.innodb_tables and innodb_tablespaces ===
583 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
584 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
585 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
586 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
587 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
588 test/fts_aux_index_1 innodb_system 161 8 Dynamic 0 System
589 test/fts_aux_index_2 innodb_system 161 8 Dynamic 0 System
590 test/fts_aux_index_3 innodb_system 161 8 Dynamic 0 System
591 test/fts_aux_index_4 innodb_system 161 8 Dynamic 0 System
592 test/fts_aux_index_5 innodb_system 161 8 Dynamic 0 System
593 test/fts_aux_index_6 innodb_system 161 8 Dynamic 0 System
594 test/fts_aux_being_deleted innodb_system 161 4 Dynamic 0 System
595 test/fts_aux_being_deleted_cache innodb_system 161 4 Dynamic 0 System
596 test/fts_aux_config innodb_system 161 5 Dynamic 0 System
597 test/fts_aux_deleted innodb_system 161 4 Dynamic 0 System
598 test/fts_aux_deleted_cache innodb_system 161 4 Dynamic 0 System
599 test/t1 innodb_system 161 6 Dynamic 0 System
600 INSERT INTO t1 (a,b) VALUES
601 ('MySQL Tutorial','DBMS stands for DataBase') ,
602 ('How To Use MySQL Well','After you went through a'),
603 ('Optimizing MySQL','In this tutorial we will show');
604 INSERT INTO t1 (a,b) VALUES
605 ('1001 MySQL Tricks','1. Never run mysqld as root'),
606 ('MySQL vs. YourSQL','In the following database comparison'),
607 ('MySQL Security','When configured properly, MySQL');
608 SELECT * FROM t1 WHERE MATCH (a,b)
609 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
610 a b
611 MySQL Tutorial DBMS stands for DataBase
612 Optimizing MySQL In this tutorial we will show
613 TRUNCATE TABLE t1;
614 === information_schema.innodb_tables and innodb_tablespaces ===
615 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
616 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
617 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
618 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
619 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
620 test/fts_aux_index_1 innodb_system 161 8 Dynamic 0 System
621 test/fts_aux_index_2 innodb_system 161 8 Dynamic 0 System
622 test/fts_aux_index_3 innodb_system 161 8 Dynamic 0 System
623 test/fts_aux_index_4 innodb_system 161 8 Dynamic 0 System
624 test/fts_aux_index_5 innodb_system 161 8 Dynamic 0 System
625 test/fts_aux_index_6 innodb_system 161 8 Dynamic 0 System
626 test/fts_aux_being_deleted innodb_system 161 4 Dynamic 0 System
627 test/fts_aux_being_deleted_cache innodb_system 161 4 Dynamic 0 System
628 test/fts_aux_config innodb_system 161 5 Dynamic 0 System
629 test/fts_aux_deleted innodb_system 161 4 Dynamic 0 System
630 test/fts_aux_deleted_cache innodb_system 161 4 Dynamic 0 System
631 test/t1 innodb_system 161 6 Dynamic 0 System
632 INSERT INTO t1 (a,b) VALUES
633 ('MySQL Tutorial','DBMS stands for DataBase') ,
634 ('How To Use MySQL Well','After you went through a'),
635 ('Optimizing MySQL','In this tutorial we will show');
636 INSERT INTO t1 (a,b) VALUES
637 ('1001 MySQL Tricks','1. Never run mysqld as root'),
638 ('MySQL vs. YourSQL','In the following database comparison'),
639 ('MySQL Security','When configured properly, MySQL');
640 SELECT * FROM t1 WHERE MATCH (a,b)
641 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
642 a b
643 MySQL Tutorial DBMS stands for DataBase
644 Optimizing MySQL In this tutorial we will show
645 DROP TABLE t1;
646 #
647 # Without TABLESPACE=, innodb_file_per_table=ON(default);
648 #
649 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));;
650 === information_schema.innodb_tables and innodb_tablespaces ===
651 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
652 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
653 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
654 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
655 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
656 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
657 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
658 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
659 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
660 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
661 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
662 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
663 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
664 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
665 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
666 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
667 test/t1 test/t1 33 6 Dynamic 0 Single
668 DROP TABLE t1;
669 #
670 # Without TABLESPACE=, innodb_file_per_table=OFF
671 #
672 SET GLOBAL innodb_file_per_table=OFF;
673 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));;
674 === information_schema.innodb_tables and innodb_tablespaces ===
675 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
676 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
677 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
678 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
679 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
680 test/fts_aux_index_1 innodb_system 33 8 Dynamic 0 System
681 test/fts_aux_index_2 innodb_system 33 8 Dynamic 0 System
682 test/fts_aux_index_3 innodb_system 33 8 Dynamic 0 System
683 test/fts_aux_index_4 innodb_system 33 8 Dynamic 0 System
684 test/fts_aux_index_5 innodb_system 33 8 Dynamic 0 System
685 test/fts_aux_index_6 innodb_system 33 8 Dynamic 0 System
686 test/fts_aux_being_deleted innodb_system 33 4 Dynamic 0 System
687 test/fts_aux_being_deleted_cache innodb_system 33 4 Dynamic 0 System
688 test/fts_aux_config innodb_system 33 5 Dynamic 0 System
689 test/fts_aux_deleted innodb_system 33 4 Dynamic 0 System
690 test/fts_aux_deleted_cache innodb_system 33 4 Dynamic 0 System
691 test/t1 innodb_system 33 6 Dynamic 0 System
692 DROP TABLE t1;
693 SET GLOBAL innodb_file_per_table=default;
694 CREATE TEMPORARY TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT(a,b))
695 TABLESPACE=innodb_temporary ROW_FORMAT=compact;
696 ERROR HY000: Cannot create FULLTEXT index on temporary InnoDB table
697 # Test with FTS TABLES in remote DATA DIRECTORY
698 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) DATA DIRECTORY 'REMOTE_DIR';
699 === information_schema.innodb_tables and innodb_tablespaces ===
700 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
701 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
702 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
703 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
704 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
705 test/fts_aux_index_1 test/fts_aux_index_1 97 8 Dynamic 0 Single
706 test/fts_aux_index_2 test/fts_aux_index_2 97 8 Dynamic 0 Single
707 test/fts_aux_index_3 test/fts_aux_index_3 97 8 Dynamic 0 Single
708 test/fts_aux_index_4 test/fts_aux_index_4 97 8 Dynamic 0 Single
709 test/fts_aux_index_5 test/fts_aux_index_5 97 8 Dynamic 0 Single
710 test/fts_aux_index_6 test/fts_aux_index_6 97 8 Dynamic 0 Single
711 test/fts_aux_being_deleted test/fts_aux_being_deleted 97 4 Dynamic 0 Single
712 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 97 4 Dynamic 0 Single
713 test/fts_aux_config test/fts_aux_config 97 5 Dynamic 0 Single
714 test/fts_aux_deleted test/fts_aux_deleted 97 4 Dynamic 0 Single
715 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 97 4 Dynamic 0 Single
716 test/t1 test/t1 97 6 Dynamic 0 Single
717 # list files in REMOTE_DIR
718 fts_aux_index_1.ibd
719 fts_aux_index_2.ibd
720 fts_aux_index_3.ibd
721 fts_aux_index_4.ibd
722 fts_aux_index_5.ibd
723 fts_aux_index_6.ibd
724 fts_aux_being_deleted.ibd
725 fts_aux_being_deleted_cache.ibd
726 fts_aux_config.ibd
727 fts_aux_deleted.ibd
728 fts_aux_deleted_cache.ibd
729 t1.ibd
730 TRUNCATE TABLE t1;
731 # restart
732 TRUNCATE TABLE t1;
733 # list files in REMOTE_DIR after TRUNCATE
734 fts_aux_index_1.ibd
735 fts_aux_index_2.ibd
736 fts_aux_index_3.ibd
737 fts_aux_index_4.ibd
738 fts_aux_index_5.ibd
739 fts_aux_index_6.ibd
740 fts_aux_being_deleted.ibd
741 fts_aux_being_deleted_cache.ibd
742 fts_aux_config.ibd
743 fts_aux_deleted.ibd
744 fts_aux_deleted_cache.ibd
745 t1.ibd
746 DROP TABLE t1;
747 # list files after DROP TABLE. Should be empty
748 # Test with FTS , IMPORT & EXPORT tablespace
749 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=s_def;
750 FLUSH TABLES t1 FOR EXPORT;
751 Warnings:
752 Warning 1235 InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES FOR EXPORT on table `test`.`t1` in a general tablespace.'
753 UNLOCK TABLES;
754 DROP TABLE t1;
755 # Test with ALTER. Add a FTS Index and also move the current
756 # table to general tablespace
757 CREATE TABLE t1 (
758 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
759 title VARCHAR(200)
760 ) ENGINE=InnoDB;
761 === information_schema.innodb_tables and innodb_tablespaces ===
762 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
763 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
764 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
765 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
766 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
767 test/t1 test/t1 33 5 Dynamic 0 Single
768 ALTER TABLE t1 ADD FULLTEXT INDEX (title), TABLESPACE=s_def;
769 Warnings:
770 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
771 === information_schema.innodb_tables and innodb_tablespaces ===
772 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
773 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
774 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
775 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
776 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
777 test/fts_aux_index_1 s_def 161 8 Dynamic 0 General
778 test/fts_aux_index_2 s_def 161 8 Dynamic 0 General
779 test/fts_aux_index_3 s_def 161 8 Dynamic 0 General
780 test/fts_aux_index_4 s_def 161 8 Dynamic 0 General
781 test/fts_aux_index_5 s_def 161 8 Dynamic 0 General
782 test/fts_aux_index_6 s_def 161 8 Dynamic 0 General
783 test/fts_aux_being_deleted s_def 161 4 Dynamic 0 General
784 test/fts_aux_being_deleted_cache s_def 161 4 Dynamic 0 General
785 test/fts_aux_config s_def 161 5 Dynamic 0 General
786 test/fts_aux_deleted s_def 161 4 Dynamic 0 General
787 test/fts_aux_deleted_cache s_def 161 4 Dynamic 0 General
788 test/t1 s_def 161 6 Dynamic 0 General
789 DROP TABLE t1;
790 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) TABLESPACE=s_def ROW_FORMAT=compact;
791 === information_schema.innodb_tables and innodb_tablespaces ===
792 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
793 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
794 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
795 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
796 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
797 test/fts_aux_index_1 s_def 129 8 Compact 0 General
798 test/fts_aux_index_2 s_def 129 8 Compact 0 General
799 test/fts_aux_index_3 s_def 129 8 Compact 0 General
800 test/fts_aux_index_4 s_def 129 8 Compact 0 General
801 test/fts_aux_index_5 s_def 129 8 Compact 0 General
802 test/fts_aux_index_6 s_def 129 8 Compact 0 General
803 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
804 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
805 test/fts_aux_config s_def 129 5 Compact 0 General
806 test/fts_aux_deleted s_def 129 4 Compact 0 General
807 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
808 test/t1 s_def 129 7 Compact 0 General
809 INSERT INTO t1 VALUES
810 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
811 ('How To Use MySQL Well','After you went through a', 2),
812 ('Optimizing MySQL','In this tutorial we will show', 3);
813 INSERT INTO t1 VALUES
814 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
815 ('MySQL vs. YourSQL','In the following database comparison', 5),
816 ('MySQL Security','When configured properly, MySQL', 6);
817 SELECT c FROM t1 WHERE MATCH (a,b)
818 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
819 c
820 1
821 3
822 ALTER TABLE t1 ADD UNIQUE INDEX idx1(b(20)), ALGORITHM=INPLACE;
823 === information_schema.innodb_tables and innodb_tablespaces ===
824 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
825 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
826 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
827 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
828 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
829 test/fts_aux_index_1 s_def 129 8 Compact 0 General
830 test/fts_aux_index_2 s_def 129 8 Compact 0 General
831 test/fts_aux_index_3 s_def 129 8 Compact 0 General
832 test/fts_aux_index_4 s_def 129 8 Compact 0 General
833 test/fts_aux_index_5 s_def 129 8 Compact 0 General
834 test/fts_aux_index_6 s_def 129 8 Compact 0 General
835 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
836 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
837 test/fts_aux_config s_def 129 5 Compact 0 General
838 test/fts_aux_deleted s_def 129 4 Compact 0 General
839 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
840 test/t1 s_def 129 7 Compact 0 General
841 SELECT c FROM t1 WHERE MATCH (a,b)
842 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
843 c
844 1
845 3
846 # Test with ALGORITHM=COPY and with FTS Index
847 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
848 === information_schema.innodb_tables and innodb_tablespaces ===
849 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
850 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
851 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
852 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
853 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
854 test/fts_aux_index_1 s_def 129 8 Compact 0 General
855 test/fts_aux_index_2 s_def 129 8 Compact 0 General
856 test/fts_aux_index_3 s_def 129 8 Compact 0 General
857 test/fts_aux_index_4 s_def 129 8 Compact 0 General
858 test/fts_aux_index_5 s_def 129 8 Compact 0 General
859 test/fts_aux_index_6 s_def 129 8 Compact 0 General
860 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
861 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
862 test/fts_aux_config s_def 129 5 Compact 0 General
863 test/fts_aux_deleted s_def 129 4 Compact 0 General
864 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
865 test/t1 s_def 129 8 Compact 0 General
866 SELECT pk FROM t1 WHERE MATCH (a,b)
867 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
868 pk
869 1
870 3
871 # Before drop FTS index
872 === information_schema.innodb_tables and innodb_tablespaces ===
873 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
874 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
875 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
876 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
877 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
878 test/fts_aux_index_1 s_def 129 8 Compact 0 General
879 test/fts_aux_index_2 s_def 129 8 Compact 0 General
880 test/fts_aux_index_3 s_def 129 8 Compact 0 General
881 test/fts_aux_index_4 s_def 129 8 Compact 0 General
882 test/fts_aux_index_5 s_def 129 8 Compact 0 General
883 test/fts_aux_index_6 s_def 129 8 Compact 0 General
884 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
885 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
886 test/fts_aux_config s_def 129 5 Compact 0 General
887 test/fts_aux_deleted s_def 129 4 Compact 0 General
888 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
889 test/t1 s_def 129 8 Compact 0 General
890 # Test with DROP FTS Index & ADD FTS Index
891 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
892 === information_schema.innodb_tables and innodb_tablespaces ===
893 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
894 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
895 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
896 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
897 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
898 test/fts_aux_index_1 s_def 129 8 Compact 0 General
899 test/fts_aux_index_2 s_def 129 8 Compact 0 General
900 test/fts_aux_index_3 s_def 129 8 Compact 0 General
901 test/fts_aux_index_4 s_def 129 8 Compact 0 General
902 test/fts_aux_index_5 s_def 129 8 Compact 0 General
903 test/fts_aux_index_6 s_def 129 8 Compact 0 General
904 test/fts_aux_being_deleted s_def 129 4 Compact 0 General
905 test/fts_aux_being_deleted_cache s_def 129 4 Compact 0 General
906 test/fts_aux_config s_def 129 5 Compact 0 General
907 test/fts_aux_deleted s_def 129 4 Compact 0 General
908 test/fts_aux_deleted_cache s_def 129 4 Compact 0 General
909 test/t1 s_def 129 8 Compact 0 General
910 SELECT pk FROM t1 WHERE MATCH (a,b)
911 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
912 pk
913 1
914 3
915 DROP TABLE t1;
916 # Test with file-per-table tablespace
917 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) ;
918 === information_schema.innodb_tables and innodb_tablespaces ===
919 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
920 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
921 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
922 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
923 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
924 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
925 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
926 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
927 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
928 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
929 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
930 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
931 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
932 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
933 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
934 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
935 test/t1 test/t1 33 7 Dynamic 0 Single
936 INSERT INTO t1 VALUES
937 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
938 ('How To Use MySQL Well','After you went through a', 2),
939 ('Optimizing MySQL','In this tutorial we will show', 3);
940 INSERT INTO t1 VALUES
941 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
942 ('MySQL vs. YourSQL','In the following database comparison', 5),
943 ('MySQL Security','When configured properly, MySQL', 6);
944 SELECT c FROM t1 WHERE MATCH (a,b)
945 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
946 c
947 1
948 3
949 ALTER TABLE t1 ADD UNIQUE INDEX idx1(b(20)), ALGORITHM=INPLACE;
950 === information_schema.innodb_tables and innodb_tablespaces ===
951 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
952 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
953 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
954 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
955 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
956 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
957 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
958 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
959 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
960 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
961 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
962 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
963 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
964 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
965 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
966 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
967 test/t1 test/t1 33 7 Dynamic 0 Single
968 SELECT c FROM t1 WHERE MATCH (a,b)
969 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
970 c
971 1
972 3
973 # Test with ALGORITHM=COPY and with FTS Index
974 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
975 === information_schema.innodb_tables and innodb_tablespaces ===
976 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
977 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
978 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
979 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
980 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
981 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
982 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
983 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
984 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
985 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
986 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
987 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
988 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
989 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
990 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
991 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
992 test/t1 test/t1 33 8 Dynamic 0 Single
993 SELECT pk FROM t1 WHERE MATCH (a,b)
994 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
995 pk
996 1
997 3
998 # Before drop FTS index
999 === information_schema.innodb_tables and innodb_tablespaces ===
1000 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
1001 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
1002 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
1003 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
1004 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
1005 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
1006 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
1007 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
1008 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
1009 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
1010 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
1011 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
1012 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
1013 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
1014 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
1015 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
1016 test/t1 test/t1 33 8 Dynamic 0 Single
1017 # Test with DROP FTS Index & ADD FTS Index
1018 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
1019 === information_schema.innodb_tables and innodb_tablespaces ===
1020 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
1021 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
1022 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
1023 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
1024 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
1025 test/fts_aux_index_1 test/fts_aux_index_1 33 8 Dynamic 0 Single
1026 test/fts_aux_index_2 test/fts_aux_index_2 33 8 Dynamic 0 Single
1027 test/fts_aux_index_3 test/fts_aux_index_3 33 8 Dynamic 0 Single
1028 test/fts_aux_index_4 test/fts_aux_index_4 33 8 Dynamic 0 Single
1029 test/fts_aux_index_5 test/fts_aux_index_5 33 8 Dynamic 0 Single
1030 test/fts_aux_index_6 test/fts_aux_index_6 33 8 Dynamic 0 Single
1031 test/fts_aux_being_deleted test/fts_aux_being_deleted 33 4 Dynamic 0 Single
1032 test/fts_aux_being_deleted_cache test/fts_aux_being_deleted_cache 33 4 Dynamic 0 Single
1033 test/fts_aux_config test/fts_aux_config 33 5 Dynamic 0 Single
1034 test/fts_aux_deleted test/fts_aux_deleted 33 4 Dynamic 0 Single
1035 test/fts_aux_deleted_cache test/fts_aux_deleted_cache 33 4 Dynamic 0 Single
1036 test/t1 test/t1 33 8 Dynamic 0 Single
1037 SELECT pk FROM t1 WHERE MATCH (a,b)
1038 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
1039 pk
1040 1
1041 3
1042 DROP TABLE t1;
1043 DROP TABLESPACE s_def;
1044 DROP TABLESPACE s_zip;
1045 SET GLOBAL innodb_file_per_table = default;