#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,653
    Rep Power
    171

    Waiting for table level lock


    Hello forum;

    I have 130 processes like this.

    I even restarted the server but they are still there!

    Does this look familiar to anyone?

    Thanks
  2. #2
  3. No Profile Picture
    Problem Solver
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jan 2001
    Location
    Stockholm, Sweden
    Posts
    4,495
    Rep Power
    534
    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.
    /Stefan

IMN logo majestic logo threadwatch logo seochat tools logo