PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
Key string values can be created at runtime and stored into a variable or table using SET, SELECT, or INSERT. If you install the legacy functions then upgrade to MySQL 8.0.30 or later, the functions you created remain available, are supported, and ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
In NDB 8.0.31 and later, you can enable binary logging of compressed transactions for tables using the NDB storage engine at run time using the ndb_log_transaction_compression system variable introduced in that release, and control the level of ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. This is in contrast to all other data types, for which storage is allocated once per column when the table is opened. A BLOB is a binary large object that ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
The table shown at https://msdn.microsoft.com/en-us/goglobal/cc305152.aspx provides information about the Unicode values of cp932 characters. For cp932 table entries with characters under which a four-digit number appears, the number represents the ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and unloading, and also registers loaded components in the mysql.component ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. For small numbers of tables (typically less than 7 to 10) this is not a problem. The behavior of ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
The tablespace_definition_cache option sets a limit for the number of tablespace definition objects that can be stored in the dictionary object cache. The table definition cache partition exists in parallel with the table definition cache that is ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all rows from a MyISAM table, TRUNCATE TABLE tbl_name is faster than DELETE FROM tbl_name. Truncate operations are not ...To ...