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/generated-column-index-optimizations.html
You can see this using EXPLAIN: mysql> EXPLAIN SELECT * FROM t1 WHERE f1 + 1 > 9\G *************************** 1. That is also apparent in the rewritten query available in the extended EXPLAIN information displayed by SHOW WARNINGS: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
In some cases, MySQL is able to do much better than that and avoid creation of temporary tables by using index access. With this access method, MySQL uses the property of some index types that the keys are ordered (for example, BTREE). If the GROUP ... The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
Important For the coordinator to be able to configure group wide actions on a running group, all members must be running MySQL 8.0.13 or higher and have the functions installed. The operation is therefore rejected if any server running MySQL Server ... You can configure an online group while Group Replication is running by using a set of functions, which rely on a group action ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
In MySQL 8.0.17 and later, for state transfer from the binary log, the joiner only selects a donor that is running a lower or equal patch version of MySQL Server compared to itself. Because this method of state transfer uses the existing MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
From MySQL 8.0.26, you can set the Group Replication system variable group_replication_view_change_uuid to use an alternative UUID in the GTIDs for view change events, so that they are easy to distinguish from transactions received by the group from ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-monitoring.html
You can use the MySQL Performance Schema to monitor Group Replication. Beginning with MySQL 8.0.21, messages relating to Group Replication lifecycle events other than errors are classified as system messages; these are always written to the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-offline-upgrade.html
See Section 20.8.3.2, “Upgrading a Group Replication Member” for how to remove members from a group and shutdown MySQL. See Chapter 3, Upgrading MySQL for how to perform an upgrade. If you have a requirement to allow members at earlier releases ... To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-reduce.html
The minimum setting for the XCom message cache size is 1 GB up to MySQL 8.0.20. From MySQL 8.0.21, the minimum setting is 134217728 bytes (128 MB), which enables deployment on a host that has a restricted amount of available memory. From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-group-member-stats.html
To use this table to monitor a Group Replication member, issue the following statement: mysql> SELECT * FROM performance_schema.replication_group_member_stats\G Beginning with MySQL 8.0.19, you can also use the following statement: mysql> TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
From MySQL 8.0.27, the group communication engine can use a single leader to drive consensus when the group is in single-primary mode. The column value is 1 if the group was started with group_replication_paxos_single_leader set to ON, and its ...