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/analyze-table.html
MySQL uses the stored key distribution to decide the order in which tables should be joined for joins on something other than a constant. If a join is not optimized in the right way, try running ANALYZE TABLE. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Support for LEFT OUTER JOIN and RIGHT OUTER JOIN with both standard SQL and ODBC syntax. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
This means that although the value of the system variable can be changed while Group Replication is running, and takes effect after you restart Group Replication on the group member, the member still cannot rejoin the group until the setting has ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-securing.html
When a member joins the group, distributed recovery is carried out using a combination of a remote cloning operation, if available and appropriate, and an asynchronous replication connection. Up to MySQL 8.0.20, group members offer their standard ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
To rejoin the replication group, the restored member must have the same server_uuid it used to join the group before. Rebuild the Failed Member to Rejoin as a New Member Sometimes, the steps outlined above in Restoring a Failed Member cannot be ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
Fragmented messages include information in their headers that enables a member joining during message transmission to recover the earlier fragments that were sent before it joined. If the joining member fails to recover the fragments, it expels ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and expels ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
The way which you join upgraded members can depend on which method you are following, and other factors such as whether the group is operating in single-primary or multi-primary mode. The process of upgrading a member consists of removing it from ...
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/mrr-optimization.html
MRR enables batch processing of requests for key access for operations that require access to data rows through index tuples, such as range index scans and equi-joins that use an index for the join attribute. The following scenarios illustrate when ... Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...