PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/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 that the files are owned by that account: openssl genrsa -out private_key.pem 2048 openssl rsa -in ... This ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
SSL and RSA File Characteristics SSL and RSA files created automatically by the server or by invoking mysql_ssl_rsa_setup have these characteristics: SSL and RSA have a size of 2048 bits. MySQL provides these ways to create the SSL certificate and ...