PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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/5.7/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 12.19.1, “Aggregate Function ... This ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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 6.4.4.6, “Supported ...
https://dev.mysql.com/doc/refman/5.7/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 6.4.4.6, “Supported Keyring Key ... The keyring_file keyring plugin stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/5.7/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. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
A migration from 2-digit YEAR(2) columns to 4-digit YEAR columns should also involve examining application code for the possibility of changed behavior under conditions such as these: Code that expects selecting a YEAR column to produce exactly two ... This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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 ...