The INNODB_FT_DEFAULT_STOPWORD
table was added in MariaDB 10.0 and MySQL 5.6
The Information Schema INNODB_FT_DEFAULT_STOPWORD
table contains a list of default stopwords used when creating an InnoDB fulltext index.
The PROCESS
privilege is required to view the table.
It has the following column:
Column | Description |
---|---|
VALUE |
Default stopword for an InnoDB fulltext index. Setting either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable will override this. |
SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD\G *************************** 1. row *************************** value: a *************************** 2. row *************************** value: about *************************** 3. row *************************** value: an *************************** 4. row *************************** value: are ... *************************** 36. row *************************** value: www
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb_ft_default_stopword-table/