Understanding MySQL locks (1) Overview

For other data centers, MySQL provides a host-specific mechanism.The most important feature is that different memory engines support different memory systems.But in general, MySQL memory engines use three types of memory customization:Rows are sorted, sorted, and sorted.. Among them, MyISAM mainly uses the table sequence, while the row sequence is mainly used InnoDB.

 

 ① Table crashes: the startup speed is small, and the acceleration speed is fast. No dead ends may occur. The granularity is large, and the probability of sudden bursts is the highest and the degree of occurrence is the lowest. 
 (2) rows: Large Opening and slow loading; dead ends may occur; minimum granularity, minimum probability of abrupt occurrence, and highest degree of occurrence. 
     ③ too many labels: the time between the start and end operations is between the table sequence and the row sequence. There will be dead rows. The granularity is determined between the table sequence and the row sequence, general concurrency  
Each lock is designed based on its own application scenarios. Table locks may be suitable for Web applications, while row-level locks may be more suitable for OLTP systems.