lpa Posted August 26, 2022 Share Posted August 26, 2022 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? Link to comment Share on other sites More sharing options...
DaveP Posted August 26, 2022 Share Posted August 26, 2022 Are you on myISAM or InnoDB tables? Link to comment Share on other sites More sharing options...
lpa Posted August 26, 2022 Author Share Posted August 26, 2022 I am on myISAM. Link to comment Share on other sites More sharing options...
flydev Posted August 28, 2022 Share Posted August 28, 2022 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 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now