PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. However, because the efficiency of compression depends on the nature of your data, you can make decisions ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, dictionary data can become inconsistent. If a data dictionary corruption or consistency issue prevents you from starting InnoDB, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
JSON_TABLE() supports four types of columns, described in the following list: name FOR ORDINALITY: This type enumerates rows in the COLUMNS clause; the column named name is a counter whose type is UNSIGNED INT, and whose initial value is 1. This ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/known-issues.html
You should try to avoid using unsigned long long values if they resolve to be larger than 63 bits (9223372036854775807) for anything other than bit fields. This section lists known issues in recent versions of MySQL. For information about ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...