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-mode-change-online-enable-gtids.html
However, if you have the possibility to take the servers offline when enabling GTID transactions that process is easier. Beginning with MySQL 8.0.23, you can set up replication channels to assign GTIDs to replicated transactions that do not already ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) While locked, a role cannot be used to ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
Important START REPLICA sends an acknowledgment to the user after all the replication threads have started. However, the replication receiver thread might not yet have connected to the source successfully, or an applier thread might stop when ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
If you encounter a full-table error, there are several reasons why it might have occurred: The disk might be full. You are using InnoDB tables and have run out of room in an InnoDB tablespace file. For example, you are using MyISAM tables on an ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. It is possible to define multiple triggers for a given table that have the same trigger event and action time. For example, you can have ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
Users who have logged in to Windows can connect from MySQL client programs to the server based on the information in their environment without specifying an additional password. Windows pluggable authentication provides these capabilities: External ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
This includes the rules governing the relationship between any unique keys (including any primary key) that the table might have, and the column or columns used in the partitioning expression, as discussed in Section 26.6.1, “Partitioning Keys, ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
Increases in the compression effort do not have a linear relationship to increases in the compression ratio. A transaction involving a mix of non-transactional and transactional storage engines does not have its payload compressed. If transaction ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
If you have no hostname command or are running on Windows, you can manually type the host name of your machine (without backticks) following the -h option. For example, you might have a cron job that removes old files from the /tmp directory. You ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
The MySQL server must have the necessary write access to create the directory. The recipient must have enough disk space for the cloned data. If you clone to a named directory using the DATA DIRECTORY clause, you must have enough disk space for the ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...