Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are periodically flushed to disk. A large log buffer enables large transactions to run without the need to write redo log data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
A range of 400 thousand space IDs is reserved for session temporary tablespaces. InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces store user-created temporary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...
https://dev.mysql.com/doc/refman/8.4/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-server-config.html
The MySQL server listens on one or more network sockets for TCP/IP connections. Each socket is bound to one address, but it is possible for an address to map onto multiple network interfaces. Set the bind_address system variable at server startup ...
https://dev.mysql.com/doc/refman/8.4/en/iterate.html
ITERATE label ITERATE can appear only within LOOP, REPEAT, and WHILE statements. ITERATE means “start the loop again.” For an example, see Section 15.6.5.5, “LOOP Statement”.
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, begin with Section 8.4.4.3, “Keyring Plugin Installation”. If you ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
The component_keyring_file keyring component stores keyring data in a file local to the server host. Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. keyring_aws_rotate_cmk() Associated keyring plugin: keyring_aws keyring_aws_rotate_cmk() rotates the AWS KMS ...