-- 查看事务对应的线程
select t1.trx_id, t1.trx_state, t1.trx_query, t2.id, t2.state, t2.command from information_schema.innodb_trx t1, information_schema.processlist t2 where t1.trx_mysql_thread_id =t2.id\G
-- 查询正在进行的事务
select * from information_schema.innodb_trx;
-- 查看正在索的事务
select * from information_schema.innodb_locks;
-- 查看等待锁的事务
select * from information_schema.innodb_lock_waits;
mysql 查询事务对应线程
最新推荐文章于 2022-10-10 16:32:18 发布