.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

What Is a Dead Lock

Q

What Is a Dead Lock? - MySQL FAQs - Transaction Management: Commit or Rollback

✍: FYIcenter.com

A

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)

2007-05-09, 5258👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML