Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. If it does, and some members have less write ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
Member actions have a priority from 1 to 100, with lower values being actioned first. The server must be writeable (with the read_only system variable set to OFF) and have the Group Replication plugin installed. In this state, it does not accept ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
When the member is in super read only mode, clients cannot make any updates, even if they have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). When the member is in offline mode, connected client users are disconnected on their ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-status-variables.html
For example, if we have a group with three members and we send a 100-byte message, this value accounts for 300 bytes, since we send 100 bytes to each node. These status variables all have member scope since they reflect what the local member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, this replication user is also used as the clone user on the donor, and requires the correct permissions for this role too. If you do ... Group Replication uses a distributed recovery process to synchronize group members when joining them to the ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
Table 14.26 GTID Functions Name Description WAIT_FOR_EXECUTED_GTID_SET() Wait until the given GTIDs have executed on the replica. If a timeout is specified, and timeout seconds elapse before all of the transactions in the GTID set have been applied, ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
For InnoDB and MyISAM tables, you have some control over collection of table statistics by means of the innodb_stats_method and myisam_stats_method system variables, respectively. These variables have three possible values, which differ as follows: ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
InnoDB tables are represented in this view if they have been opened since the last server restart and have not aged out of the table cache. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
Notes To see information about a routine, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-Per-Table Tablespace Advantages File-per-table tablespaces have the following advantages over shared tablespaces such as the system tablespace or general tablespaces. File-Per-Table Tablespace Disadvantages File-per-table tablespaces have the ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...