mysql事务锁表 Lock wait timeout exceeded; try restarting transaction

-- 查看被锁住的
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
-- 等待锁定
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
-- 查看事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
-- 杀掉trx_mysq_thread_id
kill 25496;

 

Lock wait timeout exceeded; try restarting transaction

https://blog.csdn.net/wsjzzcbq/article/details/85237992

Lock wait timeout exceeded; try restarting transaction

https://blog.csdn.net/java__project/article/details/100137526

 

posted @ 2017-12-09 15:16  tonggc1668  阅读(139)  评论(0)    收藏  举报