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/replication-upgrade.html
A replica at an earlier release might not have the required capability to process transactions that can be handled by the source at a later release. On the replicas, you must ensure that the binary log and relay log have been fully processed, and ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
To update an auto-updated column even when other columns do not change, explicitly set it to the value it should have (for example, set it to CURRENT_TIMESTAMP). Any of the synonyms for CURRENT_TIMESTAMP have the same meaning as CURRENT_TIMESTAMP.
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, same length. Suppose that you have a TINYTEXT ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
In the following example, we assume that you already have a MySQL Server running in a Docker container (see Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker” on how to start a MySQL Server instance with Docker). For MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
However, given that other members do not have to do the same amount of processing that the original member had to do when it originally executed the transaction, they apply the changes faster. Can I deploy Group Replication across wide-area ...What ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
For Group Replication, this includes both transactions that have been committed and applied, which are in the gtid_executed GTID set, and transactions that have been certified but not yet applied, which are in the group_replication_applier channel.
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
In MySQL 8.0.19 and later, none of these have any effect any longer. Beginning with MySQL 8.0.20, support for block nested loop is removed, and the server employs a hash join wherever a block nested loop would have been used previously. Prior to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
Pages made not young The total number of pages not made young in the buffer pool LRU list (pages that have remained in the “old” sublist without being made young). youngs/s The per second average of accesses to old pages in the buffer pool LRU ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...