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/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. Table-Level Optimizer Hints Table-level hints affect: Use of the Block Nested-Loop (BNL) and Batched Key Access (BKA) ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
The following instructions assume that MySQL is not already installed on your system using a third-party-distributed RPM package; if that is not the case, follow the instructions given in Section 3.8, “Upgrading MySQL with the MySQL Yum ...Before ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
If you do not set a maximum key size, the upper limit is 16384 for the RSA algorithm and 10000 for the DSA algorithm, as specified by OpenSSL. The most important of these are as follows: The legacy functions support the older DSA algorithm and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache using a variation of the least recently used (LRU) algorithm. Buffer Pool LRU Algorithm The buffer pool ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
How Page Compression Works When a page is written, it is compressed using the specified compression algorithm. Writes to the tablespace that occur after setting the new compression algorithm use the new setting, but to apply the new compression ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('abc')); -> 'abc', 616263, 'abc' mysql> SELECT HEX(255), CONV(HEX(255),16,10); -> 'FF', 255 INSERT(str,pos,len,newstr) Returns the string str, with the substring beginning at position pos and len ...For ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
Indexes can be used for views processed using the merge algorithm. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used during generation of the ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... Online creation of a multi-value index is not supported, which means the operation uses ALGORITHM=COPY. As with other indexes on columns of InnoDB tables, a multi-valued index cannot be created with USING HASH; attempting to do so results in a warning: This storage engine does not support the HASH index algorithm, storage engine default was used ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
The derived_merge flag also applies to views that contain no ALGORITHM clause. Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...