This is new part which contains information about what to do if problem is repeatable only when queries run concurrently.






Chapter 6. Locks and deadlocks.




In the last part we discussed how to find cause of the problem in case
if it is always repeatable. But there are cases when problem occurs
only under particular circumstances.




For example, such easy query can run long enough:








mysql> select * from t;

+-----+

| a |

+-----+

| 0 |

| 256 |

+-----+

2 rows in set (3 min 18.71 sec)



...


Rest of the chapter is here








Read More about [Translation of "Chapter 6. Locks and deadlocks." of "Methods for searching errors in SQL application" just published....