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/replication-howto-masterstatus.html
Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. Choose one of the following options: If you have existing data that needs be to synchronized with the replica before you start replication, ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
(See Section 9.4, “Using mysqldump for Backups”.) For InnoDB tables, it is possible to perform an online backup that takes no locks on tables using the --single-transaction option to mysqldump. To get a consistent backup, stop the server or lock ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
If the server is running, it is necessary to perform appropriate locking so that the server does not change database contents during the backup. MySQL Enterprise Backup does this locking automatically for tables that require it. This distinction can ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-options-variables.html
clone_block_ddl Command-Line Format --clone-block-ddl Introduced 8.0.27 System Variable clone_block_ddl Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Enables an exclusive backup lock on the donor MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
A consistent read does not set any locks on the tables it accesses, and therefore other sessions are free to modify those tables at the same time a consistent read is being performed on the table. With FOR SHARE, a locking read occurs instead: A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another one. Because all transactions involved are waiting for the same resource to become available, none of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
However, strict isolation levels require greater locking overhead, which can cause waits. Disabling Row Locks for memcached DML Operations The innodb_api_disable_rowlock option can be used to disable row locks when memcached requests through the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before an in-place online DDL operation can finish, it must wait for transactions that hold metadata locks on the table to commit ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
BatchSizePerLocalScan: Used to calculate number of lock records for scan with hold lock. LockPagesInMainMemory: 0=disable locking, 1=lock after memory allocation, 2=lock before memory allocation. MaxLCPStartDelay: Time in seconds that LCP polls for ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
Successful use of LOCAL load operations within mysqlimport also requires that the server permits local loading; see Section 8.1.6, “Security Considerations for LOAD DATA LOCAL” --lock-tables, -l Command-Line Format --lock-tables Lock all tables ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...