Blocking (data processing)

A deadlock occurs when one transaction is prevented by another.

A blocking is often confused with a deadlock , the main difference being that when blocking only the first process is blocked by the second process. In the event of a deadlock, however, the processes block each other.

The occurrence of a deadlock in a database is not uncommon and usually only represents a temporary state .

Web links

• http://dev.mysql.com/doc/mysql/en/internal-locking.html