Once you have executed these commands, the error log starts filling up, so you may want to keep an eye on it from time to time and turn it off if its size is worrying you.

You may want to turn it on for a while, and check the logs for "Deadlock encountered.... Printing deadlock information", then turn it off.

To the Author:

I'd like to know once you have identified what tables etc are part of the problem, how do you go about solving the problem in the first place?