Search Results
https://dev.mysql.com/doc/internals/en/open.html
Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open method. For an example of how to implement file locking, see the get_share() and free_share() methods of ...
https://dev.mysql.com/doc/internals/en/wait-condition.html
Like 'sleep', this method can also be used, when all but one thread reach a blocked state. If you are able to detect that the threads are in their blocked state by using SQL statements, then you can use this method. Example: --connection conn1 LOCK ...The remaining thread runs the statement(s) until the expected result is ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
It is not advisable to take a lock on a record and maintain it for a extended time since this can impact other transactions. NdbTransaction::releaseLockHandle() Description This method is used to release a lock handle (see ...A transaction consists ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-4-0-0.html
For more information on the variables added and removed in MySQL 8, see Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 The following metrics were added for MySQL 8 support: Sys Schema Table Metadata Lock Waits ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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 ...