MySQL Forums
Forum List  »  InnoDB

Re: locking problems
Posted by: Mike Beck
Date: February 15, 2005 10:06AM

so from the innodb status we cannot see what actually caused the deadlock, the two queries were not really locking each other, but would be worked on as soon as another, unknown query would no longer lock the auto-inc column?
so there is one query which still has that lock and is not ending but which is not in a deadlock situation? how can i find out what that is?
I assume i should try to find out which query exactly is causing the problems instead of just using INSERT IGNORE on every insert query i use?

Options: ReplyQuote

Written By
February 09, 2005 10:47AM
February 13, 2005 04:21AM
Re: locking problems
February 15, 2005 10:06AM
February 15, 2005 02:09PM

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.