Re: Query id in the show engine innodb status output
Your application should check for errors.
Your application should not BEGIN... do lots of other stuff ...COMMIT -- it is asking for a LOCK WAIT TIMEOUT.
You could turn on the "general log" to capture all the queries. Then wade through it to find the naughty transaction.
Subject
Views
Written By
Posted
5428
May 13, 2011 02:11PM
Re: Query id in the show engine innodb status output
5315
May 15, 2011 12:29PM
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.