PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position Yes SOURCE_POS_WAIT() Block until the replica has read and applied all updates up to the specified position WAIT_FOR_EXECUTED_GTID_SET() Wait ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. Although you do not have to create an account specifically for replication, you should be ...The user name is specified by the SOURCE_USER | MASTER_USER option of the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) when you set up a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-monitoring.html
The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. See Section 7.4.3, “The General ...For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-context-mysql-feature-ports.html
mysqld must be able to bind to the Group Replication communication port and listen there. mysqld must be able to bind to the X Plugin communication port and listen there. If you enable certain MySQL features, you might need to set the SELinux TCP ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
Serialized dictionary information (SDI) is present in all InnoDB tablespace files except for temporary tablespace and undo tablespace files. SDI records in an InnoDB tablespace file only describe table and tablespace objects contained within the ...
https://dev.mysql.com/doc/refman/8.0/en/server-side-help-support.html
Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/8.0/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/8.0/en/set-role.html
Granted roles include those granted explicitly to the user and those named in the mandatory_roles system variable value. When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...