Member Avatar for sathishnadu

Can anyone explain me on details the difference of Deadlock and Lockwait errors found on MySQL 5.1. Is it just the same? When did the deadlock error occur and when did the lockwait timeout occur?

  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 6 Minutes Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Deadlock is two threads infinitely waiting on the same thing. Lockwait timeout means one thread timed out while waiting to get a lock, thus preventing a deadlock.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.