mysql deadlock solution~

Mysql server seem to be in deadlock state because of transaction(race condition).

But, restarting Mysql server doesn't make faster开发者_高级运维 or recover from locking state. Web site is very very slow yet.

Basically yes, i have to change my web application queries first. But, is there any way to recover mysql server from locking state.

Deleting some table? or processing? or rollback?

---

Maybe killing the processes in mysql. You can go first

mysql> SHOW PROCESSLIST;

then mysql> kill 27; (the corresponding processes)