August 5th, 2012, 08:08 AM
Waiting for table level lock
I have 130 processes like this.
I even restarted the server but they are still there!
Does this look familiar to anyone?
August 6th, 2012, 08:26 AM
Yes you are most certainly using MyISAM tables and performing some sort of insert/update/delete that takes a long time for example with a column in the WHERE clause that is missing an index or the query affects a _lot_ of rows or something equivalent.
Since a write lock is an exclusive lock all other threads will wait for that lock to finish, so look through your processlist for one that is running and that is the culprit.