Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Remote Cloning Prerequisites To perform a cloning operation, the clone plugin must be active on both the donor and recipient MySQL server instances. The clone plugin supports the following syntax for cloning remote data; that is, cloning data from ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
During the cloning operation, both the binary log position (filename, offset) and the gtid_executed GTID set are extracted and transferred from the donor MySQL server instance to the recipient. In addition to cloning data, a cloning operation ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
The clone plugin permits cloning data locally or from a remote MySQL server instance. Cloned data is a physical snapshot of data stored in InnoDB that includes schemas, tables, tablespaces, and data dictionary metadata. The cloned data comprises a ...
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
We continue to support transactional and nontransactional databases to satisfy both mission-critical 24/7 usage and heavy Web or logging usage. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-dns-srv.html
MySQL supports use of DNS SRV records to connect to servers in these contexts: Several MySQL Connectors implement DNS SRV support; connector-specific options enable requesting DNS SRV record lookup both for X Protocol connections and for classic ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
To ensure that a new, unrelated connection opens after session reuse fails silently, invoke MySQL client programs with both the --ssl-session-data and --ssl-session-data-continue-on-failed-reuse command-line options. This section describes options ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Previously, this was handled by treating both operands as the larger type, but now, since any allowed value for c is less than the constant, the WHERE expression can instead be folded as WHERE 1, so that the query is rewritten as SELECT * FROM t ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. Because of this, constraint handling is a bit different in MySQL than in other DBMSs. We must handle the case when you have ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
This option is supported with both CREATE FUNCTION and CREATE PROCEDURE. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you ...
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
A range is given in the form M − N, where M is less than or equal to N and both numbers are in the CPU range. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] ...