Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-internal-data.html
Data retrieved from the lock tables exists when the SELECT is executed, but might be gone or changed by the time the query result is consumed by the client. Even if you issue a single SELECT (joining INNODB_TRX and PROCESSLIST, for example), the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
mysql> SELECT NAME, TOTAL_ROW_VERSIONS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE 'test/t1'; +---------+--------------------+ | NAME | TOTAL_ROW_VERSIONS | +---------+--------------------+ | test/t1 | 0 | +---------+--------------------+ ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
mysql> SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current; +-------------------------------+----------------+----------------+ | EVENT_NAME | WORK_COMPLETED | WORK_ESTIMATED | ... To reduce the warmup ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
Consequently, SELECT COUNT(*) statements only count rows visible to the current transaction. For information about how InnoDB processes SELECT COUNT(*) statements, refer to the COUNT() description in Section 14.19.1, “Aggregate Function ... This ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Configuring the Number of Sampled Pages The MySQL query optimizer uses estimated statistics about key distributions to choose the indexes for an execution plan, based on the relative selectivity of the index. The optimizer might choose very ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); In addition, the keyring_aws_rotate_cmk() and keyring_aws_rotate_keys() functions “extend” the keyring plugin interface to ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Example: SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by component_keyring_encrypted_file, see Section 8.4.4.10, “Supported Keyring Key Types ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
Example: SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by component_keyring_file, see Section 8.4.4.10, “Supported Keyring Key Types and ...