PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/keyring-encrypted-file-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_encrypted_file, see Section 8.4.4.13, “Supported ... Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_file, see Section 8.4.4.13, “Supported Keyring Key ... The keyring_file keyring plugin stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
Example (using the SQL interface): SELECT keyring_key_generate('MyKey', 'AES', 32); SELECT keyring_key_remove('MyKey'); For information about the characteristics of key values permitted by keyring_oci, see Section 8.4.4.13, “Supported Keyring Key ... Note The keyring_oci plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/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. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
mysql> SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current; +------------------------------------------------------+----------------+----------------+ | EVENT_NAME | WORK_COMPLETED | WORK_ESTIMATED | ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...