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/general-thread-states.html
If not, verify that you do not have a full disk and that the disk is not in very heavy use. However, to reopen the table, it must wait until all other threads have closed the table in question. However, to reopen the table, it must wait until all ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
You have previously seen SHOW DATABASES, which lists the databases managed by the server. To find out which database is currently selected, use the DATABASE() function: mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
For Point objects that have a geographic spatial reference system (SRS), the longitude and latitude may be obtained using the ST_Longitude() and ST_Latitude() functions, respectively. ST_Latitude() handles its arguments as described in the ... A ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
With a Tight Index Scan, the grouping operation is performed only after all keys that satisfy the range conditions have been found. The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-connection-security.html
These are in addition to the privileges REPLICATION SLAVE and BACKUP_ADMIN that all replication user accounts must have (see Section 20.2.1.3, “User Credentials For Distributed Recovery”). Stop the primary member last, so that you do not trigger ... From MySQL 8.0.27, Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
A member that is new to the group does not have anything to apply. As state transfer from the binary log is based on classic asynchronous replication, it might take a very long time if the server joining the group does not have the group's data at ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
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 updates from any clients, even users who have the CONNECTION_ADMIN or SUPER privilege.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server instance. Any replicated transactions that are received by group members on asynchronous replication channels from ...The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
A joining member must have its initial connection to the group permitted by the allowlist in order to retrieve the address or addresses for distributed recovery. If a joining member does not have a permitted address for the appropriate protocol, its ... When and only when the XCom communication stack is used for establishing group communications (group_replication_communication_stack=XCOM), the Group Replication plugin lets you specify an allowlist of hosts from which an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
If a joining member does not have a permitted address for the appropriate protocol, its connection attempt is refused. After you have upgraded every group member to a MySQL Server version that supports IPv6 for Group Replication, you can change the ... As of MySQL 8.0.14, Group Replication group members can use IPv6 addresses as an alternative to IPv4 addresses for communications within the ...