Search

Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 296.5Kb
Man Pages (Zip) - 401.9Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb


Displaying 51 to 58 of 58 total results
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. This section discusses how to use myisamchk to check or repair MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
FULLTEXT initialization The server is preparing to perform a natural-language full-text search. The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
<collation name="latin1_fulltext_ci" id="1025"/> </charset> Declare the sort order for the collation in the latin1.xml file. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
FOR EXPORT does not apply to InnoDB system tablespace files, or to InnoDB tables that have FULLTEXT indexes. | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
FULLTEXT indexes cannot be created on a column that uses any of these character sets. Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual ...