Collections:
What Is a Dead Lock in MySQL
What Is a Dead Lock in MySQL?
✍: FYIcenter.com
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)
2017-04-28, 866👍, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...