Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/adminapi-locking.html
Locking Types AdminAPI uses the MySQL Locking Service to provide the following locking types: Read or shared lock: allows concurrent execution of some operations while blocking exclusive operations. If an operation attempts to acquire a shared lock, ... Previously, different instances of MySQL Shell could connect and process AdminAPI operations simultaneously on the same ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
InnoDB Row Lock Waits Displays the InnoDB locks transactions are waiting for. Table 3.2 InnoDB Row Lock Waits Dashboard Name Description Waiting Lock ID The ID of the waiting lock. Blocking Lock ID The ID of the lock that is blocking the waiting ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This enables you to control row locking to ensure safe, transactional document updates on collections and to ...Other sessions can read the rows, but cannot modify them until your transaction ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This enables you to control row locking to ensure safe, transactional document updates on collections and to ...Other sessions can read the rows, but cannot modify them until your transaction ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This enables you to control row locking to ensure safe, transactional document updates on collections and to ...Other sessions can read the rows, but cannot modify them until your transaction ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...The ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent snapshot. Executing the LOCK INSTANCE ...The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place upgrade to MySQL 8.4 from an earlier ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. In ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL functions. Depending on their appearance in the select ...