https://dev.mysql.com/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/condition-pushdown-optimization.html
This exclusion extends to JSON, BIT, and ENUM columns as well. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for ...
https://dev.mysql.com/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/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/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/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/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/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. CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] ...
https://dev.mysql.com/creating-rsa-files-using-openssl.html
To create the RSA private and public key-pair files, run these commands while logged into the system account used to run the MySQL server so the files will be owned by that account: openssl genrsa -out private_key.pem 2048 openssl rsa -in ... This ...
https://dev.mysql.com/creating-ssl-rsa-files-using-mysql.html
SSL and RSA files created automatically by the server or by invoking mysql_ssl_rsa_setup have these characteristics: SSL and RSA keys are have a size of 2048 bits. For some distribution types, such as RPM packages, mysql_ssl_rsa_setup invocation ...
