PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Join-Order Optimizer Hints Join-order hints affect the order in which the optimizer joins tables. Syntax of the JOIN_FIXED_ORDER hint: hint_name([@query_block_name]) Syntax of other join-order hints: hint_name([@query_block_name] tbl_name [, ... One ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
0 0/1 ndb_join_pushdown System Variable ndb_join_pushdown Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON This variable controls whether joins on NDB tables are pushed down to the NDB kernel (data nodes). This ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
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 function. To use cloning, at least one existing group member and the joining member ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...This topic explains the role of view changes and the view change identifier, and the steps to carry out state transfer from the binary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". The connection that an existing member offers to a joining member for Group Replication's ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was away. The joining member begins by checking the relay log for its ...A member ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a server. When state transfer from the donor's binary ...Configuration settings that apply to those roles outside the Group Replication context can apply for Group Replication also, unless they are overridden by a Group Replication-specific configuration setting or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
A member applies these policies to decide whether to join the group normally, or join in read-only mode, or not join the group, depending on which choice results in the safe operation of the joining member and of the existing members of the group.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
In MySQL 8.0.18 and later, this variable also controls the amount of memory used for hash joins. Normally, the best way to get fast joins is to add indexes. Increase the value of join_buffer_size to get a faster full join when adding indexes is not ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. For more information, see Section 10.2.1.12, “Block ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...