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/innodb-transaction-model.html
The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase locking. InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
The mysqld on which the copying ALTER TABLE statement is issued takes a metadata lock, but this is in effect only on that mysqld. Regardless of the algorithm used, the mysqld takes a Global Schema Lock (GSL) while executing ALTER TABLE; this ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”, for more ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
LOCKED_BY_THREAD_ID When a thread currently has a mutex locked, LOCKED_BY_THREAD_ID is the THREAD_ID of the locking thread, otherwise it is NULL. The mutex_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (NAME) ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
Otherwise, the thread is blocked by a call to thd_wait_begin() and the value specifies the type of wait. Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
Note InnoDB mutexes and rwlocks can also be monitored using Performance Schema tables. For rwlocks, the Name field reports the source file where the rwlock is implemented, and the line number in the file where the rwlock is created. SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. InnoDB row-level locking (without escalation ... Storage engines are MySQL components that handle the SQL operations for different table ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
The following statements are not permitted: The locking statements LOCK TABLES and UNLOCK TABLES. Also, the same local variable name can be used in nested blocks. A local variable in an inner block takes precedence over a local variable in an outer ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
To ensure that no thread group becomes blocked by stalled statements, the thread pool has a background thread that regularly monitors thread group states. A statement becomes blocked if it encounters a disk I/O operation or a user level lock (row ...