Results 1 to 1 of 1
Thread: Database Locking Issue
Nov 19, 2008, 22:13 #1
- Join Date
- Sep 2004
- 0 Post(s)
- 0 Thread(s)
Database Locking Issue
Not sure why this is happening, but for some reason the connections clog on my database server. When I visit the database via the MySQL query browser, I issue the query "SHOW FULL PROCESSLIST".
It shows me a strange result where close to all of the queries are LOCKED ... they'll seem to point to one particular table. I'm not sure whether the table that's been queried has been locked on purpose, or if an INSERT is causing the lock to happen, or maybe just a long SELECT statement.
I have a slow query log, but no queries relative to that table show up in it.
The only thing that comes to mind is that is being LOCKED is a MEMORY table. Could it be that the memory hits a spike causing everything to go into limbo. Could this be why?I can't believe I ate the whole thing