https://dev.mysql.com/internal-temporary-tables.html
Columns take only as much storage as needed, which reduces disk I/O, space requirements, and processing time compared to on-disk tables that use fixed-length rows. In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...
https://dev.mysql.com/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...
https://dev.mysql.com/keyring-aws-plugin.html
(Its value can be changed at runtime if desired using SET GLOBAL.) If necessary, create the directory in which the configuration file will be located. This is a one-time operation, performed by executing the following statements (adjust the .so ...
https://dev.mysql.com/keyring-installation.html
Note Only one keyring plugin should be enabled at a time. Keyring service consumers require a keyring plugin to be installed. MySQL provides these plugin choices: keyring_file: A plugin that stores keyring data in a file local to the server host.
https://dev.mysql.com/keyring-okv-plugin.html
Connect again to the Oracle Key Vault server, this time without logging in. Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables ...
https://dev.mysql.com/keyring-udfs-general-purpose.html
That is, the value of the CURRENT_USER() function at the time of key manipulation must have the same value as when the key was stored in the keyring. MySQL Server supports a keyring service that enables internal server components and plugins to ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/known-issues.html
The default value of max_sort_length is 1024 and can be changed at server startup time or at runtime. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and porting ...
https://dev.mysql.com/large-page-support.html
Normally, you put these in an rc file or equivalent startup file that is executed during the system boot sequence, so that the commands execute each time the system starts. Some hardware/operating system architectures support memory pages greater ...
