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/connecting-disconnecting.html
If the server runs on a machine other than the one where you log in, you must also specify a host name. For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To ...
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/group-replication-communication-protocol.html
All members of the group must use the same communication protocol version, so that group members can be at different MySQL Server releases but only send messages that can be understood by all group members. Members with different communication ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-server.html
If mysqld does not want to start, verify that you have no my.cnf files that interfere with your setup! You can check your my.cnf arguments with mysqld --print-defaults and avoid using them by starting with mysqld --no-defaults .... The command ...If ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
When the memory required for a hash join exceeds the amount available, MySQL handles this by using files on disk. If this happens, you should be aware that the join may not succeed if a hash join cannot fit into memory and it creates more files than ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...