Some understanding of MySQL lock

Innodb The storage engine supports row-level locks, and table-level locks are supported, but row-level locks are used by default

Innodb The biggest difference with MyISAM is two points, one is to support transactions, the other is to use row-level locks

Shared lock, exclusive lock Awareness

Shared Lock (S): Allows a transaction to read one line, preventing other transactions from acquiring an exclusive lock on the same data set

Exclusive Lock (X): A transaction that allows an exclusive lock to update data, preventing other transactions from acquiring shared and exclusive locks on the same data set.

This article is from the DBA Sky blog, so be sure to keep this source http://9425473.blog.51cto.com/9415473/1660943

Some understanding of MySQL lock