MySQL InnoDB Table Lock

I had a customer with a problem using a web based email marketing software application. Importing data and deleting data seemed to stop working. The database uses InnoDB tables so I used phpMyAdmin to try to execute the delete SQL code and received the following error:

1205 lock wait timeout exceeded

For future reference: To kill the process which has locked the table visit the ‘Processes’ tab in phpMyAdmin and kill the offending process. Actions on the table should then start working again.

interspire email marketer

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>