- 8.0.19 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 8.0.19 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.05 sec) mysql> 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 114688 Jan 30 09:53 98427/test/fts_0000000000000423_0000000000000096_index_1.ibd -rw-r----- 1 umshastr common 114688 Jan 30 09:52 98427/test/fts_0000000000000423_0000000000000096_index_2.ibd -rw-r----- 1 umshastr common 114688 Jan 30 09:52 98427/test/fts_0000000000000423_0000000000000096_index_3.ibd -rw-r----- 1 umshastr common 114688 Jan 30 09:52 98427/test/fts_0000000000000423_0000000000000096_index_4.ibd -rw-r----- 1 umshastr common 114688 Jan 30 09:52 98427/test/fts_0000000000000423_0000000000000096_index_5.ibd -rw-r----- 1 umshastr common 114688 Jan 30 09:52 98427/test/fts_0000000000000423_0000000000000096_index_6.ibd strings 98427/test/fts_0000000000000423_0000000000000096_index_1.ibd 8infimum supremum j{?x ~-$a4] fv,1 (yG8 etK4{ ZA$U )K9]L< (8w5]% Z!4K \ L` gD*]u TzR$ Tlo} AG"e niK8M fnW,; -2?` 2p E infimum supremum 3against 2called :collections 6full 4function /has 6implements 3indexes 1match 1model 2myisam 4mysql /now 0only 8search 1space 6support 2tables 6text 0used vector strings 98427/test/fts_0000000000000423_0000000000000096_index_2.ibd 9infimum supremum {{?x jP:[# /G9c W/-$ mc:/ jC(7 LPNr /tHQ eKq$ xNLl B^]z YOW: }m3a infimum supremum strings 98427/test/fts_0000000000000423_0000000000000096_index_3.ibd 1<>5 9infimum supremum 46ZJ 'W'B lP:[! fv,1 ]MW /tHQ B].lyk p~qsx "fH3\ AG"e niK8M pph3 Wgo| 1<>E infimum supremum strings 98427/test/fts_0000000000000423_0000000000000096_index_4.ibd 9infimum supremum 46ZJ d=^iC1GZ I!53n 1y8V\6 /tHQ o-r- 6d"c ~[^) <}% O{ OO xNLm >\Pe g\a| 1ORE infimum supremum strings 98427/test/fts_0000000000000423_0000000000000096_index_5.ibd :infimum supremum iS'6 85 & jC(7 LPNr /tHQ eKq$ xNLl B^]z YOW: 4\5_ _dil{ 1bvE infimum supremum strings 98427/test/fts_0000000000000423_0000000000000096_index_6.ibd 9infimum supremum 46^J 'G'B d!{N wS6( <]M@mM0 fv,1 (yG8 etK4{ ZA$U )K9]L< (8w5]% Z!4K \ L` gD*]u TzR$ Tlo} -o-r /f?` t$R&l ?\^}"7o/ infimum supremum