Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation characteristics. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For example, if a member is running MySQL 8.4.6 then that is the version of the Group Replication plugin. For optimal ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-member-stats.html
Each member in a replication group certifies and applies transactions received by the group. Statistics regarding the certifier and applier procedures are useful to understand how the applier queue is growing, how many conflicts have been found, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not try. Note that in the case of an ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency system. This means that as soon as the incoming traffic slows down or stops, all group members ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
This section explains the steps required for upgrading a member of a group. This procedure is part of the methods described at Section 20.8.3.3, “Group Replication Online Upgrade Methods”. The process of upgrading a member of a group is common ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
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 part of the setting for the optimizer_switch server system variable. row ...