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)