mysql按条件删除被锁

mysql报错：
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction

(1)SHOW FULL PROCESSLIST; 找到操作的id,kill掉
(2)SELECT * FROM information_schema.INNODB_TRX;

(3)KILL 616694;