PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
It is not mandatory for all members of a group to have the same setting for group_replication_member_expel_timeout, but it is recommended in order to avoid unexpected expulsions. You can use the group_replication_member_expel_timeout system ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-throttling.html
In order to avoid large jumps in throughput once the queue size goes beyond the threshold, the throughput is only allowed to grow by the same 10% per period after that. Based on the metrics gathered across all servers in the group, a throttling ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
Group Replication uses a total order on writes, and therefore this implies waiting for this and all preceding writes that are in secondaries’ queues to be applied. In terms of distributed consistency guarantees, either in normal or failure repair ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
The recommended order of upgrading members in a single-primary group is to upgrade all secondaries, and then upgrade the primary last. This section explains the steps required for upgrading a member of a group. This procedure is part of the methods ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
Group Replication uses a distributed recovery process to synchronize group members when joining them to the group. Distributed recovery involves transferring transactions from a donor's binary log to a joining member using a replication channel ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
By default, MySQL (8.0.18 and later) employs hash joins whenever possible. It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Due to the difference in result types, the displayed values differ: High-order 0 digits are not displayed for the numeric result. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
For multi-file tablespaces, specify each file: ibd2sdi ibdata1 ibdata2 The files of a multi-file tablespace must be specified in order of the ascending page number. ibd2sdi is a utility for extracting serialized dictionary information (SDI) from ...
https://dev.mysql.com/doc/refman/8.0/en/index-preloading.html
Although the blocks stay in the cache, because there are enough buffers for all of them, they are fetched from disk in random order, and not sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...