Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
An ALTER INSTANCE [ENABLE|DISABLE] INNODB REDO_LOG operation requires an exclusive backup lock, which prevents other ALTER INSTANCE operations from executing concurrently. Other ALTER INSTANCE operations must wait for the lock to be released before ... ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER INSTANCE defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
A RENAME TO operation cannot be performed while LOCK TABLES or FLUSH TABLES WITH READ LOCK is in effect for tables that reside in the tablespace. Exclusive metadata locks are taken on tables that reside in a general tablespace while the tablespace ...It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
How do I force the source to block updates until the replica catches up? A.14.5. On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. What issues should I be aware of when ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
For example, some optimizations may not be available, or more locking might be required. InnoDB might escalate to a range-key lock rather than taking a single row lock for one matching row. A function is nondeterministic if, given fixed values for ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
CREATE TABLESPACE tablespace_name [ADD DATAFILE 'file_name'] [FILE_BLOCK_SIZE = value] [ENGINE [=] engine_name] A general tablespace can be created in the data directory or outside of it. For a general tablespace to contain compressed tables ... A ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
LOCK TABLES Enable use of LOCK TABLES on tables for which you have the SELECT privilege. The CREATE, DROP, EVENT, GRANT OPTION, LOCK TABLES, and REFERENCES privileges can be specified at the database level. [WITH GRANT OPTION] [AS user [WITH ROLE ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
Given those file names, the copy commands look like this: $> cd export_basedir/data/hr $> cp employees_125.sdi /tmp/export $> cp managers_238.sdi /tmp/export $> cp employees.{MYD,MYI} /tmp/export $> cp managers.{MYD,MYI} /tmp/export Unlock the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Row-level locking and Oracle-style consistent reads increase multi-user concurrency and performance. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
A LOCK clause specifies a low degree of locking (SHARED or NONE) that is not compatible with the particular type of DDL operation. A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...