mysql 事务死锁了,手动释放

2021-04-29  本文已影响0人  有趣有趣

查一下受影响的语句
select id, db, user, host, command, time, state, info
from information_schema.processlist
where command != 'Sleep'
order by time desc ;

找到死锁的事务
select * from information_schema.innodb_trx

杀死
kill 796296

上一篇下一篇

猜你喜欢

热点阅读