mysql执行sql语句报错事务锁住

报错情况

1205 - Lock wait timeout exceeded; try restarting transaction

先找出长时间运行的事务

SELECT * FROM information_schema.INNODB_TRX ORDER BY trx_started ASC;

终止长时间运行的事务

KILL [PROCESS_ID];