https://dev.mysql.com/innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains ...The INNODB_FT_DELETED table has these columns: DOC_ID The document ID of the newly deleted ...
https://dev.mysql.com/create-table.html
FULLTEXT A FULLTEXT index is a special type of index used for full-text searches. WITH PARSER The WITH PARSER option can only be used with FULLTEXT indexes. CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] ...
https://dev.mysql.com/innodb-ft-being-deleted-table.html
For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the ...
https://dev.mysql.com/writing-full-text-plugins.html
The instructions use the source code in the plugin/fulltext directory of MySQL source distributions, so change location into that directory. This is the value that identifies the plugin as being legal for use in a WITH PARSER clause when creating a ... MySQL supports server-side full-text parser plugins with MyISAM and ...
https://dev.mysql.com/server-system-variables.html
ft_max_word_len Property Value Command-Line Format --ft-max-word-len=# System Variable ft_max_word_len Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Minimum Value 10 The maximum length of the word to be included in a MyISAM FULLTEXT ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. For related usage information and examples, see Section 15.14.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index ...
https://dev.mysql.com/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. Note When adding ...
https://dev.mysql.com/plugin-types.html
For example, a full-text parser plugin becomes available to be named in a WITH PARSER clause when creating individual FULLTEXT indexes. When you associate a parser plugin with a FULLTEXT index, the plugin is required for using the index. The plugin ...
https://dev.mysql.com/tablespace-copying.html
FOR EXPORT is not supported on tables that have a FULLTEXT index. After importing a table with a FULLTEXT index, run OPTIMIZE TABLE to rebuild the FULLTEXT indexes. Alternatively, drop FULLTEXT indexes before the export operation and recreate them ... This section describes how to copy a file-per-table tablespaces from one MySQL instance to another, otherwise known as the Transportable Tablespaces ...
https://dev.mysql.com/faqs-cjk.html
Why do some LIKE and FULLTEXT searches with CJK characters fail? A.11.12. Why do some LIKE and FULLTEXT searches with CJK characters fail? For LIKE searches, there is a very simple problem with binary string column types such as BINARY and BLOB: we ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
