- 5.7.29 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.29 MySQL Community Server (GPL) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test Database changed mysql> CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) ENGINE = InnoDB charset utf8mb4; Query OK, 0 rows affected (0.02 sec) mysql> INSERT INTO t1 VALUES('MySQL has now support', 'for full-text search'), ('Full-text indexes', 'are called collections'), ('Only MyISAM tables','support collections'), ('Function MATCH ... AGAINST()','is used to do a search'), ('Full-text search in MySQL', 'implements vector space model'); Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> shutdown; Query OK, 0 rows affected (0.00 sec) -- ls -l 98427/test/*INDEX_*.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_1.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_2.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_3.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_4.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_5.ibd -rw-r----- 1 umshastr common 98304 Jan 30 09:57 98427/test/FTS_0000000000000028_0000000000000030_INDEX_6.ibd strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_1.ibd infimum supremum strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_2.ibd infimum supremum 3against 2called collections strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_3.ibd infimum supremum 6full 4function /has 6implements !indexes strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_4.ibd infimum supremum 1match 1model 2myisam 4mysql /now only strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_5.ibd infimum supremum 8search 1space 6support 2tables text strings 98427/test/FTS_0000000000000028_0000000000000030_INDEX_6.ibd infimum supremum 0used vector