locking read
A SELECT
statement that also performs a locking operation on an InnoDB
table. Either SELECT ... FOR UPDATE
or SELECT ... LOCK IN SHARE MODE
. It has the potential to produce a deadlock, depending on the isolation level of the transaction.
See also deadlock.
See also isolation level.
See also locking.