Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
Do not use this option unless you know exactly what it does! --external-locking Command-Line Format --external-locking[={OFF|ON}] Type Boolean Default Value OFF Enable external locking (system locking), which is disabled by default. If you use this ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html
In_use The number of table locks or lock requests there are for the table. For example, if one client acquires a lock for a table using LOCK TABLE t1 WRITE, In_use is 1. If another client issues LOCK TABLE t1 WRITE while the table remains locked, ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
Figure 5.28 Client Connection Overview Client Connections and Metadata Locks The Client Connections management window includes a Show Details for connections to MySQL 5.6 and higher, as the following figure shows. Figure 5.29 Client Connections ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
NdbOperation::readTuple() used with any lock mode can read but not write blob values. When the LM_CommittedRead lock mode is used with readTuple(), the lock mode is automatically upgraded to LM_Read whenever blob attributes are accessed. A scan with ... This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-tableactivity-category.html
Table Locks Immediate (Delta) The number of times that a request for a table lock could be granted immediately. Table Locks Waited (Delta) The number of times that a request for a table lock could not be granted immediately and a wait was needed.
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
Some external program is manipulating data files or index files at the same time as mysqld without locking the table properly. You are running many mysqld servers using the same data directory on a system that does not support good file system locks ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the deadlock. InnoDB is aware of table locks if innodb_table_locks = 1 (the default) and ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-multiple-nodes.html
A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this lock. This is true for a lock issued by any statement that locks tables as part of its operations.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
UNLOCK TABLES; This benefits performance because the index buffer is flushed to disk only once, after all INSERT statements have completed. Explicit locking statements are not needed if you can insert all rows with a single INSERT. Locking also ...