MySQL Forums
Forum List  »  InnoDB

Re: Deadlock on UPDATE foo SET bar = ( SELECT ... )
Posted by: KimSeong Loh
Date: November 08, 2008 06:30AM

Deadlock always involved multiple statements that are being executed at the same time.

If you look at the deadlock information in the show innodb status, you should be able to see which statements cause the deadlock or lock wait timeout, this is a concurrency problem that will occur sometimes, you just need to write your application to retry the transaction when it happens.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Deadlock on UPDATE foo SET bar = ( SELECT ... )
1754
November 08, 2008 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.