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-online-ddl-operations.html
ALGORITHM=INPLACE is not permitted under certain conditions if columns have to be converted to NOT NULL. The server prohibits changes to foreign key columns that have the potential to cause loss of referential integrity. Online support details, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Due to the exclusive metadata lock requirements outlined above, an online DDL operation may have to wait for concurrent transactions that hold metadata locks on the table to commit or rollback. Online DDL improves several aspects of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
The instance must have performed a slow shutdown before being put into the read-only state. Changes to configuration option settings that would normally change the behavior of write operations, have no effect when the server is in read-only mode.
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Enabling innodb_stats_on_metadata may reduce access speed for schemas that have a large number of tables or indexes, and reduce stability of execution plans for queries that involve InnoDB tables. If your database has many large tables, consider ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when inserting multiple rows into a table that has multiple unique keys. If you specify an ON DUPLICATE KEY UPDATE clause and a ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/installing.html
A bugfix track upgrade includes point releases, such as MySQL 8.4.x upgrading to 8.4.y, while innovation track releases typically only have minor releases, such as MySQL 9.4.0 upgrading to 9.5.0. A summary of the procedure follows and later sections ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
A table with no explicit primary key may still have an effective implicit primary key if it has any UNIQUE indexes on NOT NULL columns. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
component_keyring_encrypted_file configuration files have these properties: A configuration file must be in valid JSON format. Any configuration file that stores a password should have a restrictive mode and be accessible only to the account used to ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
The primary variable is lock_order, which indicates whether to enable the LOCK_ORDER tool at runtime: If lock_order is disabled (the default), no other LOCK_ORDER system variables have any effect. If lock_order is disabled (the default), no other ...