Debian Codegraph @

mysql-test/suite/innodb/r/upgrade_orphan.result

raw
1 #
2 # Bug#26997500 - UPGRADE FAILS DUE TO ORPHAN .FRM AND CANNOT BE RESUMED
3 #
4 # Set different paths for --datadir
5 # Copy the remote tablespace & DB zip files from suite location to working location.
6 # Check that the file exists in the working folder.
7 # Unzip the zip file.
8 # These files are added to test error scenario, delete from for upgrade testing.
9 # Remove myisam partitioned tables. There are used for negative testing.
10 # Create an orphan .frm
11 # start server and we expect failure because of orphan .frm(sakila/zzz.frm)
12 # Remove orphan .frm
13 # Retry upgrade on the failed datadir
14 # Sanity Testing after Server start
15 CREATE SCHEMA test123;
16 CREATE TABLE test123.t1(a int);
17 INSERT INTO test123.t1 values(1);
18 SELECT * FROM test123.t1;
19 a
20 1
21 DROP SCHEMA test123;
22 SHOW DATABASES;
23 Database
24 aview
25 events
26 foreign_keys
27 information_schema
28 mysql
29 performance_schema
30 sakila
31 sp
32 sys
33 tablespace
34 test
35 test_mismatch
36 triggers
37 view_with_column_names
38 # Check table structures
39 SHOW CREATE TABLE mysql.user;
40 Table Create Table
41 user CREATE TABLE `user` (
42 `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
43 `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
44 `Select_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
45 `Insert_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
46 `Update_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
47 `Delete_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
48 `Create_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
49 `Drop_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
50 `Reload_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
51 `Shutdown_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
52 `Process_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
53 `File_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
54 `Grant_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
55 `References_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
56 `Index_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
57 `Alter_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
58 `Show_db_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
59 `Super_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
60 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
61 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
62 `Execute_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
63 `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
64 `Repl_client_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
65 `Create_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
66 `Show_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
67 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
68 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
69 `Create_user_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
70 `Event_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
71 `Trigger_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
72 `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
73 `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
74 `ssl_cipher` blob NOT NULL,
75 `x509_issuer` blob NOT NULL,
76 `x509_subject` blob NOT NULL,
77 `max_questions` int unsigned NOT NULL DEFAULT '0',
78 `max_updates` int unsigned NOT NULL DEFAULT '0',
79 `max_connections` int unsigned NOT NULL DEFAULT '0',
80 `max_user_connections` int unsigned NOT NULL DEFAULT '0',
81 `plugin` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT 'caching_sha2_password',
82 `authentication_string` text COLLATE utf8mb3_bin,
83 `password_expired` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
84 `password_last_changed` timestamp NULL DEFAULT NULL,
85 `password_lifetime` smallint unsigned DEFAULT NULL,
86 `account_locked` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
87 `Create_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
88 `Drop_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
89 `Password_reuse_history` smallint unsigned DEFAULT NULL,
90 `Password_reuse_time` smallint unsigned DEFAULT NULL,
91 `Password_require_current` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
92 `User_attributes` json DEFAULT NULL,
93 PRIMARY KEY (`Host`,`User`)
94 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Users and global privileges'
95 SHOW CREATE TABLE mysql.innodb_table_stats;
96 Table Create Table
97 innodb_table_stats CREATE TABLE `innodb_table_stats` (
98 `database_name` varchar(64) COLLATE utf8mb3_bin NOT NULL,
99 `table_name` varchar(199) COLLATE utf8mb3_bin NOT NULL,
100 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
101 `n_rows` bigint unsigned NOT NULL,
102 `clustered_index_size` bigint unsigned NOT NULL,
103 `sum_of_other_index_sizes` bigint unsigned NOT NULL,
104 PRIMARY KEY (`database_name`,`table_name`)
105 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC
106 SHOW CREATE TABLE mysql.innodb_index_stats;
107 Table Create Table
108 innodb_index_stats CREATE TABLE `innodb_index_stats` (
109 `database_name` varchar(64) COLLATE utf8mb3_bin NOT NULL,
110 `table_name` varchar(199) COLLATE utf8mb3_bin NOT NULL,
111 `index_name` varchar(64) COLLATE utf8mb3_bin NOT NULL,
112 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
113 `stat_name` varchar(64) COLLATE utf8mb3_bin NOT NULL,
114 `stat_value` bigint unsigned NOT NULL,
115 `sample_size` bigint unsigned DEFAULT NULL,
116 `stat_description` varchar(1024) COLLATE utf8mb3_bin NOT NULL,
117 PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
118 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC
119 SELECT COLUMN_NAME,CHARACTER_MAXIMUM_LENGTH
120 FROM INFORMATION_SCHEMA.COLUMNS col
121 JOIN INFORMATION_SCHEMA.TABLES tab ON col.table_name=tab.table_name
122 WHERE col.TABLE_NAME LIKE '%innodb_%_stats'
123 AND col.COLUMN_NAME LIKE 'table_name';
124 COLUMN_NAME CHARACTER_MAXIMUM_LENGTH
125 table_name 199
126 table_name 199
127 SHOW CREATE TABLE test.t_compressed;
128 Table Create Table
129 t_compressed CREATE TABLE `t_compressed` (
130 `c1` int NOT NULL,
131 `c2` varchar(20) DEFAULT NULL,
132 PRIMARY KEY (`c1`)
133 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
134 SHOW CREATE TABLE test.t_compressed2;
135 Table Create Table
136 t_compressed2 CREATE TABLE `t_compressed2` (
137 `c1` int NOT NULL,
138 `c2` varchar(20) DEFAULT NULL,
139 PRIMARY KEY (`c1`)
140 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
141 SHOW CREATE TABLE test.t_compressed3;
142 Table Create Table
143 t_compressed3 CREATE TABLE `t_compressed3` (
144 `a` int DEFAULT NULL
145 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
146 SHOW CREATE TABLE test.t_dynamic;
147 Table Create Table
148 t_dynamic CREATE TABLE `t_dynamic` (
149 `c1` int NOT NULL,
150 `c2` varchar(20) DEFAULT NULL,
151 PRIMARY KEY (`c1`)
152 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
153 SHOW CREATE TABLE test.t_index;
154 Table Create Table
155 t_index CREATE TABLE `t_index` (
156 `c1` int NOT NULL,
157 `c2` int NOT NULL,
158 PRIMARY KEY (`c1`),
159 KEY `c2` (`c2`) USING BTREE
160 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
161 SHOW CREATE TABLE test.vt2;
162 Table Create Table
163 vt2 CREATE TABLE `vt2` (
164 `c1` text NOT NULL,
165 `c2` text GENERATED ALWAYS AS (substr(`c1`,1,2)) VIRTUAL,
166 PRIMARY KEY (`c1`(20)),
167 UNIQUE KEY `c2` (`c2`(2))
168 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
169 SELECT * FROM test.vt2;
170 c1 c2
171 abcd ab
172 SHOW CREATE TABLE test.t_gen_stored;
173 Table Create Table
174 t_gen_stored CREATE TABLE `t_gen_stored` (
175 `a` varchar(50) DEFAULT NULL,
176 `b` varchar(10) GENERATED ALWAYS AS (substr(`a`,5)) STORED
177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
178 SHOW CREATE TABLE test.jemp;
179 Table Create Table
180 jemp CREATE TABLE `jemp` (
181 `c` json DEFAULT NULL,
182 `g` int GENERATED ALWAYS AS (json_extract(`c`,_utf8mb4'$.id')) VIRTUAL,
183 KEY `i` (`g`)
184 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
185 SHOW CREATE TABLE test.t_gen_stored_myisam;
186 Table Create Table
187 t_gen_stored_myisam CREATE TABLE `t_gen_stored_myisam` (
188 `a` varchar(50) DEFAULT NULL,
189 `b` varchar(10) GENERATED ALWAYS AS (substr(`a`,5)) STORED
190 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
191 SHOW CREATE TABLE test.t_gen_stored_myisam2;
192 Table Create Table
193 t_gen_stored_myisam2 CREATE TABLE `t_gen_stored_myisam2` (
194 `a` varchar(50) DEFAULT NULL,
195 `b` varchar(10) GENERATED ALWAYS AS (substr(`a`,5)) STORED,
196 KEY `a` (`a`,`b`)
197 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
198 SHOW CREATE TABLE test.jemp_myisam;
199 Table Create Table
200 jemp_myisam CREATE TABLE `jemp_myisam` (
201 `c` json DEFAULT NULL,
202 `g` int GENERATED ALWAYS AS (json_extract(`c`,_utf8mb4'$.id')) VIRTUAL
203 ) ENGINE=MyISAM DEFAULT CHARSET=latin1
204 SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE, VERSION, ROW_FORMAT
205 FROM INFORMATION_SCHEMA.tables WHERE table_schema='test';
206 TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT
207 test child BASE TABLE InnoDB 10 Dynamic
208 test geom BASE TABLE InnoDB 10 Dynamic
209 test jemp BASE TABLE InnoDB 10 Dynamic
210 test jemp_myisam BASE TABLE MyISAM 10 Dynamic
211 test opening_lines BASE TABLE InnoDB 10 Dynamic
212 test parent BASE TABLE InnoDB 10 Dynamic
213 test t_blackhole BASE TABLE BLACKHOLE 10 Fixed
214 test t_blob BASE TABLE InnoDB 10 Dynamic
215 test t_blob_myisam BASE TABLE InnoDB 10 Dynamic
216 test t_compressed BASE TABLE InnoDB 10 Compressed
217 test t_compressed2 BASE TABLE InnoDB 10 Compressed
218 test t_compressed3 BASE TABLE InnoDB 10 Compressed
219 test t_dynamic BASE TABLE InnoDB 10 Dynamic
220 test t_gen_stored BASE TABLE InnoDB 10 Dynamic
221 test t_gen_stored_myisam BASE TABLE MyISAM 10 Dynamic
222 test t_gen_stored_myisam2 BASE TABLE MyISAM 10 Dynamic
223 test t_index BASE TABLE MyISAM 10 Fixed
224 test t_json BASE TABLE InnoDB 10 Dynamic
225 test t_myisam_compressed BASE TABLE MyISAM 10 Dynamic
226 test t_myisam_compressed2 BASE TABLE MyISAM 10 Compressed
227 test t_myisam_compressed3 BASE TABLE MyISAM 10 Compressed
228 test t_sc~!@#$%^&*( BASE TABLE InnoDB 10 Dynamic
229 test vt2 BASE TABLE InnoDB 10 Dynamic
230 # Check for views
231 # Invalid view
232 SHOW CREATE VIEW aview.view_invalid;
233 View Create View character_set_client collation_connection
234 view_invalid CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`view_invalid` AS select `aview`.`t`.`a` AS `column1`,`aview`.`t`.`b` AS `column2` from `aview`.`t` utf8mb3 utf8mb3_general_ci
235 Warnings:
236 Warning 1356 View 'aview.view_invalid' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
237 # Valid views
238 SHOW CREATE VIEW aview.view_2;
239 View Create View character_set_client collation_connection
240 view_2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`view_2` AS select `aview`.`t1`.`a` AS `column1`,`aview`.`t1`.`b` AS `column2`,`aview`.`t1`.`c` AS `column3`,`aview`.`t2`.`a` AS `column4` from (`aview`.`t1` join `aview`.`t2`) utf8mb3 utf8mb3_general_ci
241 SHOW CREATE VIEW aview.second_view;
242 View Create View character_set_client collation_connection
243 second_view CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`second_view` AS select `aview`.`view_2`.`column1` AS `column1`,`aview`.`view_2`.`column2` AS `column2`,`aview`.`view_2`.`column3` AS `column3`,`aview`.`view_2`.`column4` AS `column4` from `aview`.`view_2` utf8mb3 utf8mb3_general_ci
244 SELECT * FROM aview.view_2;
245 column1 column2 column3 column4
246 50 ABCD EFGH 100
247 SELECT * FROM aview.second_view;
248 column1 column2 column3 column4
249 50 ABCD EFGH 100
250 SHOW CREATE VIEW aview.mixed_view;
251 View Create View character_set_client collation_connection
252 mixed_view CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `aview`.`mixed_view` AS select `aview`.`second_view`.`column3` AS `column3`,`aview`.`second_view`.`column4` AS `column4`,`hello`('FUNC') AS `hello('FUNC')` from `aview`.`second_view` WITH CASCADED CHECK OPTION utf8mb3 utf8mb3_general_ci
253 SHOW CREATE VIEW aview.mixed_view2;
254 View Create View character_set_client collation_connection
255 mixed_view2 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`mixed_view2` AS select `aview`.`second_view`.`column3` AS `column3`,`aview`.`second_view`.`column4` AS `column4`,`hello`('FUNC') AS `hello('FUNC')` from `aview`.`second_view` WITH LOCAL CHECK OPTION utf8mb3 utf8mb3_general_ci
256 SELECT * FROM aview.mixed_view2;
257 column3 column4 hello('FUNC')
258 EFGH 100 Hello, FUNC!
259 # View with different definer
260 SHOW CREATE VIEW aview.view_user;
261 View Create View character_set_client collation_connection
262 view_user CREATE ALGORITHM=UNDEFINED DEFINER=`jeffrey`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`view_user` AS select 1 AS `1` utf8mb3 utf8mb3_general_ci
263 SHOW CREATE VIEW aview.view_user2;
264 View Create View character_set_client collation_connection
265 view_user2 CREATE ALGORITHM=UNDEFINED DEFINER=`abcd`@`localhost` SQL SECURITY INVOKER VIEW `aview`.`view_user2` AS select 1 AS `1` utf8mb3 utf8mb3_general_ci
266 # View with different character_set and connection collation
267 SHOW CREATE VIEW aview.view_character_set;
268 View Create View character_set_client collation_connection
269 view_character_set CREATE ALGORITHM=UNDEFINED DEFINER=`jeffrey`@`localhost` SQL SECURITY DEFINER VIEW `aview`.`view_character_set` AS select 1 AS `1` latin1 latin1_swedish_ci
270 # Check for General tablespace
271 SHOW CREATE TABLE tablespace.t2;
272 Table Create Table
273 t2 CREATE TABLE `t2` (
274 `a` int DEFAULT NULL,
275 `b` varchar(50) DEFAULT NULL
276 ) /*!50100 TABLESPACE `tbsp1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
277 SHOW CREATE TABLE tablespace.t3;
278 Table Create Table
279 t3 CREATE TABLE `t3` (
280 `a` int NOT NULL,
281 `b` varchar(50) DEFAULT NULL,
282 `c` varchar(50) DEFAULT NULL,
283 PRIMARY KEY (`a`)
284 ) /*!50100 TABLESPACE `tbsp1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
285 SELECT * FROM tablespace.t3;
286 a b c
287 11 he ra
288 SHOW CREATE TABLE tablespace.t4;
289 Table Create Table
290 t4 CREATE TABLE `t4` (
291 `a` int DEFAULT NULL
292 ) /*!50100 TABLESPACE `tbsp2` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
293 # Check for table with blackhole engine
294 SHOW CREATE TABLE test.t_blackhole;
295 Table Create Table
296 t_blackhole CREATE TABLE `t_blackhole` (
297 `a` int NOT NULL,
298 PRIMARY KEY (`a`)
299 ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1
300 # Check for table with special character in name
301 SHOW CREATE TABLE `test`.`t_sc~!@#$%^&*(`;
302 Table Create Table
303 t_sc~!@#$%^&*( CREATE TABLE `t_sc~!@#$%^&*(` (
304 `a` int NOT NULL,
305 PRIMARY KEY (`a`)
306 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
307 # Check for JSON types
308 SHOW CREATE TABLE test.t_json;
309 Table Create Table
310 t_json CREATE TABLE `t_json` (
311 `jdoc` json DEFAULT NULL
312 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
313 # Check for geometry data types
314 SHOW CREATE TABLE test.geom;
315 Table Create Table
316 geom CREATE TABLE `geom` (
317 `g` geometry DEFAULT NULL,
318 `pt` point NOT NULL,
319 `ml` multipoint DEFAULT NULL,
320 `multi` multilinestring NOT NULL,
321 SPATIAL KEY `pt` (`pt`)
322 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
323 # Restart on the upgraded data dir
324 # restart: --loose-skip-log-bin --skip-log-replica-updates --skip-replica-preserve-commit-order --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_LOG --innodb-page-size=16k
325 # Execute FTS queries that modify FTS pages
326 select count(*) from sakila.film_text;
327 count(*)
328 1000
329 select * from sakila.film_text where film_id = 984;
330 film_id title description
331 984 WONDERFUL DROP A Boring Panorama of a Woman And a Madman who must Overcome a Butler in A U-Boat
332 select * from sakila.film_text where match(title,description) against("SCISSORHANDS");
333 film_id title description
334 770 SCISSORHANDS SLUMS A Awe-Inspiring Drama of a Girl And a Technical Writer who must Meet a Feminist in The Canadian Rockies
335 delete from sakila.film_text where film_id = 984;
336 SET GLOBAL innodb_optimize_fulltext_only=ON;
337 optimize table sakila.film_text;
338 Table Op Msg_type Msg_text
339 sakila.film_text optimize status OK
340 # Restart the server with default options.
341 # restart