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/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. The life cycle of a GTID consists of the following steps: ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-server-states.html
The state of a Group Replication group member shows its current role in the group. The Performance Schema table replication_group_members shows the state for each member in a group. If the group is fully functional and all members are communicating ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, which is available from MySQL 8.0.17, this replication user is also used as the clone user on the donor, and requires the correct ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special role. Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
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 behavior. When a joining member ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Each object is the privilege combination of a user and its active roles. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
Roles named in the mandatory_roles system variable value cannot be dropped. The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use DROP USER, you must ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Increase the value of the innodb_buffer_pool_size configuration option, which performs a similar role of allocating cache memory for InnoDB tables. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
The privilege required to configure clone_valid_donor_list is different from the privilege required to execute remote cloning operations, which permits assigning those responsibilities to different roles. This section describes the system variables ...