Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Keep ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Lock Wait Timeout This timeout applies to all statements that use metadata locks. These include DML and DDL operations on tables, views, stored procedures, and stored functions, as well as LOCK TABLES, FLUSH TABLES WITH READ LOCK, and HANDLER ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-log-exclusive-reads=[0|1] Command-Line Format --ndb-log-exclusive-reads[={OFF|ON}] System Variable ndb_log_exclusive_reads Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value 0 Starting the server with this ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. To find lock information, data_locks is the table containing ...The relation is based on a nested set data model, so the join has several ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
If the consistent option is set to true, which is the default, the LOCK TABLES privilege on all copied tables can substitute for the RELOAD privilege if the latter is not available. If the user account does not have the BACKUP_ADMIN privilege and ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-6.html
Locks can be requested several times for a given find or select statement. An acquired lock is held until the end of the current transaction. For X DevAPI, CollectionFind and TableSelect implement .lockExclusive() and .lockShared() methods, which ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-activity-category.html
Buffer Pool Pages Misc The number of pages that are busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. Row Lock Current Waits The number of row locks currently being waited for. Row Lock ... Lists the InnoDB Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication's certification process for concurrent transactions does not take into account gap locks, as information about gap locks is not available outside of InnoDB. InnoDB does not use gap locks in READ COMMITTED, which aligns the local ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
To do so, stop updating the related tables, commit all transactions, acquire shared locks on the tables, and perform the export operations. FOR EXPORT must remain open while the operation is running; otherwise, the .cfg file is removed as locks are ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...