Translation of "Chapter 7. Concurrent transactions. " of "Methods for searching errors in SQL application" just published.
By Sveta Smirnova-Oracle on Jul 14, 2010
This is short chapter which gives some clue what to do with concurrent transactions.
Chapter 7. Concurrent transactions.
Yet another frequent example of similar problem is "Lock wait timeout
exceeded" error while you use InnoDB tables. Most often running query
SHOW ENGINE INNODB STATUS is enough to find the problem, because it
will show last transactions. But output of this command does not
contain information about all queries in the same transaction, but only
about last one. What to do if SHOW ENGINE INNODB STATUS doesn't provide
Rest of the chapter is here