0

Possible Duplicate:
“Delete query” not able to be completed

I am trying to delete a single row from the db, but it is not completing,even in 20 minutes.There is no other queries locking up the db. I suspect it is some "leftover" lock from previous operations. Anyone has any idea?

Improve this question
1
  • the table is myisam?
    – Marco Ramos
    May 15, 2010 at 18:44

1 Answer 1

Reset to default
1

show processlist

And maybe enable slow query log

Improve this answer
1
  • +1 for informing me of 'slow query log' feature in mysql, that's really nice...
    – cpbills
    May 15, 2010 at 19:09