- 5.7.29

rm -rf 98428/
rm -rf keyring/
mkdir keyring
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/98428 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98428 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98428/log.err --plugin_dir=/export/umesh/server/binaries/GABuilds/mysql-5.7.26/lib/plugin/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring 2>&1 &

 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 CHARACTER SET utf8mb4 ENCRYPTION='Y';
Query OK, 0 rows affected (0.03 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)

mysql> \q
Bye
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98428 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98428/log.err --plugin_dir=/export/umesh/server/binaries/GABuilds/mysql-5.7.26/lib/plugin/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring 2>&1

-
ls -l 98428/test/
total 1184
-rw-r----- 1 umshastr common     65 Jan 30 10:20 db.opt
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_1.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_2.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_3.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_4.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_5.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_0000000000000030_INDEX_6.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_BEING_DELETED_CACHE.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_BEING_DELETED.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_CONFIG.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_DELETED_CACHE.ibd
-rw-r----- 1 umshastr common  98304 Jan 30 10:20 FTS_0000000000000028_DELETED.ibd
-rw-r----- 1 umshastr common   8578 Jan 30 10:20 t1.frm
-rw-r----- 1 umshastr common 114688 Jan 30 10:20 t1.ibd

 strings 98428/test/t1.ibd |head
1c666b27-4341-11ea-97d2-0010e05f3e06
JtA{=gE
-#,/;
93 n
1oxj3
@sCh
Z1Y8
%iR:
=r7\
o{VP

 ls -l 98428/test/FTS_0000000000000028_0000000000000030_INDEX_1.ibd
-rw-r----- 1 umshastr common 98304 Jan 30 10:20 98428/test/FTS_0000000000000028_0000000000000030_INDEX_1.ibd

 strings 98428/test/FTS_0000000000000028_0000000000000030_INDEX_1.ibd
infimum
supremum
 strings 98428/test/FTS_0000000000000028_0000000000000030_INDEX_2.ibd
infimum
supremum
3against
2called
collections
 strings 98428/test/FTS_0000000000000028_0000000000000030_INDEX_3.ibd
infimum
supremum
6full
4function
/has
6implements
!indexes






--- 8.0.19

rm -rf 98428/
rm -rf keyring/
mkdir keyring
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/98428 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98428 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/98428/log.err --mysqlx=0 --log-error-verbosity=3  --secure-file-priv=/tmp/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring 2>&1 &

 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.01 sec)

mysql> use test
Database changed
mysql>  CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) ENGINE = InnoDB CHARACTER SET utf8mb4 ENCRYPTION='Y';
Query OK, 0 rows affected (0.05 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.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> shutdown;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/98428 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/98428/log.err --mysqlx=0 --log-error-verbosity=3 --secure-file-priv=/tmp/ --early-plugin-load='keyring_file.so' --keyring_file_data=$PWD/keyring/keyring 2>&1


--
 strings 98428/test/t1.ibd |head
6906afe9-4340-11ea-a3d2-0010e05f3e06ZC
"{(5
!2U"
Vm Jd)
$kD)
bq;1
i^-Gv
bU19
D>]+u<
UC:%

 strings 98428/test/fts_0000000000000423_0000000000000096_index_1.ibd
8infimum
supremum
j{?x
~-$a4]
*M{Y
Z9Mn
6\tc
(yO8
/tHQ
<;s|
^{mS
fnW,;
-2?`
}m3a
eMW7(=
infimum
supremum
3against
2called
:collections
6full
4function
/has
6implements
3indexes
1match
1model
2myisam
4mysql
/now
0only
8search
1space
6support
2tables
6text
0used
vector
 strings 98428/test/fts_0000000000000423_0000000000000096_index_2.ibd
9infimum
supremum
{{?x
jP:[#
/G9c
W/-$
mc:/
*M{Y
Z9Mn
1pz$wp$
s 9MA
/tHQ
eKq$
^{mS
infimum
supremum