Shulou(Shulou.com)06/01 Report--

MySQL locks include table, page-level and row-level locks. Table-page locks are intentional locks, available in IX and IS, and are generally used before row-level locks; row-level locks are traditional S and X locks. The compatibility characteristics of these locks are as follows:

ISIXSXIS compatible compatible incompatible incompatible IX compatible incompatible S incompatible incompatible X incompatible incompatible

There are three kinds of row locking algorithms in InnoDB storage engine, namely:

* Record Lock Single row record lock

Gap Lock, locks a range, but does not contain the record itself Next-Key Lock GapLock+RecordLock

Record Lock is relatively easy to understand, GapLock needs to note that it locks the range, including both left and right gaps. Gap Lock works to prevent multiple transactions from inserting records into the same range, resulting in phantom reads.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.