MySQL lock mechanism/management (concurrency lock, row lock, table lock, pre-lock, global lock, etc)

MySQL Lab 1 .? MySQL concurrency and Isolation Control Mechanism Meta-data metadata lock: Implemented in the tablecache cache, provides isolation operations for DDL (DataDefinitionLanguage. A special meta-data metadata type called NameLock. (SQL layer) table-level data lock (SQL layer) storage engine-specific mechanism ro

MySQL Lab 1 .? MySQL concurrency and Isolation Control Mechanism Meta-data metadata lock: Implemented in the table cache, provides isolation operations for DDL (Data Definition Language. A special meta-data metadata type called Name Lock. (SQL layer) table-level data lock (SQL layer) storage engine-specific mechanism ro

MySQL lab

1 .? MySQLConcurrency and Isolation Control Mechanism

• Meta-data metadata lock: Implemented in the table cache and provides isolation for DDL (Data Definition Language. A special meta-data metadata type called Name Lock. (SQL layer)
• Table-level data lock (SQL layer)
• Storage engine-specific mechanisms-row locks, page locks, table locks, Version Control (implemented in the engine)
• Global read lock-flush tables with read lock (SQL layer)

(...)
Read the full text of MySQL lock mechanism/management (concurrency lock, row lock, table lock, pre-lock, global lock, etc.) (1,324 words)

? Tan junqing published a study on MySQL performance, MySQL Cluster, and MySQL HA High Availability-MySQL laboratory, 2010.
The source and author information of an article can be reproduced at will.
Link: http://www.mysqlab.net/blog/2010/09/mysql-lock-management/

Tags: InnoDB, lock, metadata, Table cache