Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - What Is a Dead Lock
(Continued from previous topic...)
What Is a Dead Lock?
A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks
the other transaction as shown in the following diagram:
(transaction 1) (transaction 2)
update row X to create lock 1
update row Y to create lock 2
update row X
(blocked by lock 1)
update row Y
(blocked by lock 2)
(dead lock created)
(Continued on next topic...)
- What Is a Transaction?
- How To Start a New Transaction?
- How To End the Current Transaction?
- How To Create a Table for Transaction Testing?
- How To Switch between Autocommit-On and Autocommit-Off Modes?
- How To Find Out the Current Transaction Mode?
- How To Start a New Transaction Explicitly?
- How To Commit the Current Transaction?
- How To Rollback the Current Transaction?
- What Happens to the Current Transaction If a START TRANSACTION Is Executed?
- What Happens to the Current Transaction If a DDL Statement Is Executed?
- What Happens to the Current Transaction If the Session Is Ended?
- What Happens to the Current Transaction If the Session Is Killed?
- How Does MySQL Handle Read Consistency?
- What Are Transaction Isolation Levels?
- How To View and Change the Current Transaction Isolation Level?
- What Is a Data Lock?
- How To Experiment Data Locks?
- How Long a Transaction Will Wait for a Data Lock?
- What Happens to Your Transactions When ERROR 1205 Occurred?
- What Is a Dead Lock?
- How To Experiment Dead Locks?
- What Happens to Your Transactions When ERROR 1213 Occurred?
- What Are Impacts on Applications from Locks, Timeouts, and DeadLocks?