Mysql problems: waiting for table level lock

[lpa]

Hello

I have sometimes problem with a PW-site where mysql is stuck with a lot of processes in a state: "Waiting for table level lock". The whole site goes down with that problem as the queue of free PHP processes is used before the database locks are released. 

Has anybody had the same problem? Where to look at for the reason of the locks? How to debug this?

[DaveP]

Are you on myISAM or InnoDB tables?

[lpa]

I am on myISAM. 

[flydev]

A dumb question,  disk or partition full ?

 

You could also look at this answer on dba.stackexchange for identifying the issue:  

https://dba.stackexchange.com/a/48897/170766