Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/creating-ssl-rsa-files-using-mysql.html
SSL and RSA File Characteristics SSL and RSA files created automatically by the server have these characteristics: SSL and RSA keys have a size of 2048 bits. MySQL provides these ways to create the SSL certificate and key files and RSA key-pair ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables normally require less main memory while their contents are being actively ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Each row is preceded by a bitmap that indicates which columns contain the empty string (for string columns) or zero (for numeric columns). If a string column has a length of zero after trailing space removal, or a numeric column has a value of zero, ... Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
For example, these server configuration values do not have holes: tls_version=TLSv1.2,TLSv1.3 tls_version=TLSv1.3 The prohibition on holes also applies in other configuration contexts, such as for clients or replicas. For better security, use a ...
https://dev.mysql.com/doc/refman/8.4/en/engine-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/doc/refman/8.4/en/enterprise-encryption-configuring.html
The functions provided by the component_enterprise_encryption component have a minimum key length of 2048 bits for RSA keys, which is in line with current best practice for minimum key lengths. MySQL Enterprise Encryption lets you limit keys to a ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/floating-point-types.html
For FLOAT, the SQL standard permits an optional specification of the precision (but not the range of the exponent) in bits following the keyword FLOAT in parentheses, that is, FLOAT(p). The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax.