MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Clarification Needed: innodb_lock_wait_timeout and version 4.0.20+
Posted by: Harrison Fisk
Date: November 03, 2004 03:05PM

Hi,

No, innodb_lock_wait_timeout isn't at all related to the problem you are seeing. You are running into a real deadlock, ie. A is waiting on B who is waiting on A who is waiting on B...., so InnoDB needs to roll on of them back in order to allow anyone to continue.

One tool very useful in debugging the deadlock scenarios is SHOW INNODB STATUS; If you run that command after you get a deadlock, it will tell you more information about how the deadlock occured, ie. what statements were waiting on each other and so on.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Clarification Needed: innodb_lock_wait_timeout and version 4.0.20+
Lukas Bradley
November 03, 2004 10:09AM
Re: Clarification Needed: innodb_lock_wait_timeout and version 4.0.20+
Harrison Fisk
November 03, 2004 03:05PM


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.