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/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ...When the read_only system variable is enabled, CREATE ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. DROP ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. If the IF EXISTS clause is given, the statement produces a warning ...When the read_only system variable is enabled, DROP ROLE additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
If you do not set an unreachable majority timeout, the servers in the minority group never enter the ERROR state automatically, and you must stop them manually. When the timeout specified by group_replication_unreachable_majority_timeout elapses, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...For example, to exclude stage and statement instrumentation, do this: $> ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the source. The SHOW REPLICA STATUS statement, which you must execute on each replica, ...The Performance Schema has replication tables that provide this information in a more accessible ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP REPLICA instruction remains in effect. If the replica is stopped unexpectedly (for example due to an error in a worker thread, or another ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
Once the MySQL upgrade procedure has been performed on the member, group_replication_start_on_boot must be set to 1 to ensure Group Replication starts correctly after restart. The Group Replication metadata is in place on the upgraded server, ...
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
In both nestings, T1 must be processed in the outer loop because it is used in an outer join. T2 and T3 are used in an inner join, so that join must be processed in the inner loop. Here we must introduce conditional pushed-down predicates guarded by ...The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN ...This is a conservative ...
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 ...