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/clone-plugin-limitations.html
Before 8.0.37, the point release number also had to match, so cloning the likes of 8.0.36 to 8.0.42 or vice-versa is not permitted Prior to MySQL 8.0.27, DDL on the donor and recipient, including TRUNCATE TABLE, is not permitted during a cloning ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Note A local cloning operation does not support cloning of user-created tables or tablespaces that reside outside of the data directory. Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File ...The ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-stop.html
On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status table. If necessary, you can stop a cloning operation with a KILL QUERY processlist_id ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html
Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary ... The clone plugin, introduced in MySQL 8.0.17, permits cloning data locally or from a remote MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
For source/replica replication connections, the configured compression algorithms and compression level are available from multiple sources: The Performance Schema replication_connection_configuration table has COMPRESSION_ALGORITHMS and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS implements an INFORMATION_SCHEMA table that exposes more detailed monitoring information for failed connection attempts. For more information about this table, see Section 28.6.2, “The INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot ...Because of this, constraint handling is a bit different in MySQL than in other ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. You can verify that the UNDO files were created and obtain information about them by querying the Information ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
This section describes the acceptable formats for date and time literals. The following alternative formats are also understood: ss, mmss, or hhmmss. Beginning with MySQL 8.0.19, you can specify a time zone offset when inserting TIMESTAMP and ...