13.2.10.1. InnoDB Lock Modes

InnoDB implements standard row-level locking where there are two types of locks:

*

A shared (S) lock allows a transaction to read a row (tuple).
*

An exclusive (X) lock allows a transaction to update or delete a row.

MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.1 InnoDB Lock Modes