確定是否鎖表
select * from information_schema.innodb_locks;
查詢正在鎖的事務(wù)
select * from information_schema.innodb_locks;
查詢等待鎖的事務(wù)
select * from information_schema.innodb_lock_waits;
查詢未提交的事務(wù)
select * from information_schema.innodb_trx
查詢所有的線程
select * from information_schema.PROCESSLIST;
