weixin_36841105的博客

原创 定位锁命令

1.确定是否锁表select * from information_schema.innodb_locks;2.查询正在锁的事务select * from information_schema.innodb_locks;3.查询等待锁的事务select * from information_schema.innodb_lock_waits;4.查询未提交的事务select * from information_schema.innodb_trx5.查询所有的线程select * fro..