Queries clogging MySQL

[Lynne]

None of those tell me a thing. Like I said, those are problem queries because the table is locked and thus the queries can't be performed. The real problem is whatever is locking the tables. You need to start noting down the times and what is going on on your forum when this happens and then see if you can figure it out. Basically a near impossible task (believe me, I say that from experience!).

What you might want to do is turn off all your modifications. Leave them off for a couple of days and see if that fixes the problem. Then turn on a modification a day and keep seeing if the problem returns. Maybe that way you can figure out what modification is causing the problem and then disable it for good.