Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
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 recipient). CLONE ...
https://dev.mysql.com/doc/refman/8.4/en/clone.html
CLONE INSTANCE syntax clones data from a remote MySQL server instance (the donor) and transfers it to the MySQL instance where the cloning operation was initiated (the recipient). CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
BEGIN and BEGIN WORK are supported as aliases of START TRANSACTION for initiating a transaction. SET autocommit disables or enables the default autocommit mode for the current session. This means that, when not otherwise inside a transaction, each ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the connection. By default, connections are uncompressed, but can be compressed if the server and the client agree on a ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Create an empty InnoDB table with identical column and index definitions. You might change the column and index definitions slightly, for better space utilization, reduced I/O and memory consumption when processing result sets, and better query ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
Because there are no tables in a database when it is initially created, the CREATE DATABASE statement creates only a directory under the MySQL data directory. CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...A ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column values. SET DEFAULT: This action is recognized by the MySQL parser, but both InnoDB and ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; For more information, see Section 15.1.20.3, “CREATE TABLE ... | ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the max_heap_table_size and tmp_table_size system variables. Server-side cursors are implemented in the C API using the ...