InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) locks. - A shared (S) lock permits the transaction that holds the lock to read a row. - An exclusive (X) lock permits the transaction that holds the lock to update or delete a row. If transaction T1 holds a shared (S) lock on row r, then requests from some distinct transaction T2 f..