PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For example, adding a very small floating-point value to a very large value causes the very small value to be “hidden” by the large value. When inverting the large value later, the effect of the small value is lost. For EXPLAIN, windowing ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
CREATE USER permits these auth_option syntaxes: IDENTIFIED BY 'auth_string' Sets the account authentication plugin to the default plugin, passes the cleartext 'auth_string' value to the plugin for possible hashing, and stores the result in the ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
This may not entirely prevent running out of file descriptors because in some circumstances the server may attempt to extend the cache size temporarily, as described in Section 10.4.3.1, “How MySQL Opens and Closes Tables”. If you get ERROR ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
If the remote cloning procedure takes a long time, in releases before MySQL 8.0.22, it is possible for the set of certification information that accumulates for the group during that time to become too large to transmit to the joining member. If the ...If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. If zero, size at which ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
FILE_BLOCK_SIZE is required when you intend to use the tablespace for storing compressed InnoDB tables (ROW_FORMAT=COMPRESSED). If FILE_BLOCK_SIZE is equal the innodb_page_size value, the tablespace can contain only tables having an uncompressed row ...It can hold multiple tables, and supports all table row ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If the length is still too long, the result type is LONGBLOB. If the length is still too long, the result type is LONGTEXT. row *************************** Table: new_table Create Table: CREATE TABLE `new_table` ( `c1` date DEFAULT NULL ) ... Table ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. Previously, ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
To configure the number of thread groups, use the thread_pool_size system variable. Long wait values are useful for workloads that include long-running statements, to avoid starting too many new statements while the current ones execute. A statement ... The thread pool consists of a number of thread groups, each of which manages a set of client ...