PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
An update operation most frequently executed for temporary tables is performed much faster when the updated node is in the cache and need not be read from disk first. The CACHE INDEX statement sets up an association between a table and a key cache, ...Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> SHOW VARIABLES LIKE 'key_buffer_size'; +-----------------+---------+ | Variable_name | Value | +-----------------+---------+ | key_buffer_size | 8384512 | +-----------------+---------+ Key cache variables are structured system variables that have a name and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. However, you can add a unique key that uses both c1 and c2. The rule governing this relationship can be expressed as follows: All columns used in the ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 13.4.1, “Spatial Data Types”). The ARCHIVE engine ignores BLOB columns if ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
If you do not set the timeout, there is no upper limit to the wait time, and new transactions can start during that time. Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... A deadlock can also occur when such statements lock ranges of index records and gaps, with each transaction acquiring some locks but ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-brokers.html
For example: userid=gogouser passwd=gogopass Start gogoc: $> /etc/init.d/gogoc start To start gogoc each time your system boots, execute this command: $> rc-update add gogoc default Use ping6 to try to ping a host: $> ping6 ipv6.google.com To see ...
https://dev.mysql.com/doc/refman/8.0/en/setting-environment-variables.html
To have the settings take effect each time you log in, use the interface provided by your system or place the appropriate command or commands in a startup file that your command interpreter reads each time it starts. Environment variables can be ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
For more complete information, see Section 12.10, “Supported Character Sets and Collations”. For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci, respectively. The INFORMATION_SCHEMA ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the statement that you are using (Section 15.2.7, “INSERT Statement”, Section 15.2.17, “UPDATE Statement”, and so forth). Normally, errors occur for ...