PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/8.0/en/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) ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
ft_min_word_len and ft_max_word_len indicate the minimum and maximum word length for FULLTEXT indexes on MyISAM tables. If you use myisamchk to perform an operation that modifies table indexes (such as repair or analyze), the FULLTEXT indexes are ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
The NDB storage engine does not support FULLTEXT indexes, which are possible for MyISAM and InnoDB tables only. Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Most MySQL indexes (PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT) are stored in B-trees. Exceptions: Indexes on spatial data types use R-trees; MEMORY tables also support hash indexes; InnoDB uses inverted lists for FULLTEXT indexes. Indexes are used ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-advantages.html
(You can create FULLTEXT indexes on the underlying MyISAM tables, but you cannot search the MERGE table with a full-text search.) If the MERGE table is nontemporary, all underlying MyISAM tables must be nontemporary. MERGE tables can help you solve ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. OPTIMIZE TABLE using online DDL is not supported for InnoDB tables that contain FULLTEXT indexes. OPTIMIZE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
For this reason, all statements relying on the fulltext plugin are treated as unsafe in MySQL. The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...