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/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/8.0/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/8.0/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/8.0/en/innodb-memcached-setup.html
mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags INT, cas BIGINT UNSIGNED, expiry INT, primary key(city_id) ) ENGINE=InnoDB; Add an entry to the innodb_memcache.containers table so ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/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/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/8.0/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 ...