Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
For example, if the donor instance runs on a Linux 64-bit platform, the recipient instance must also run on that platform. The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Each NULL column takes one bit extra, rounded up to the nearest byte. This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
Numbers with a value of zero are stored using one bit. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space.
https://dev.mysql.com/doc/refman/8.4/en/concurrent-inserts.html
Use of the CONCURRENT option affects the performance of LOAD DATA a bit, even if no other session is using the table at the same time. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
For better security, use a certificate with an RSA key size of at least 2048 bits. This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
Because of this, constraint handling is a bit different in MySQL than in other DBMSs. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial data types are not permitted; columns that use floating-point number types are also not permitted. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT ...