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