mysql - 13.进阶命令-事务/锁/进程

1.查询数据库当前事务 - 检查当前mysql Thread id 对应的执行信息

SELECT * FROM information_schema.INNODB_TRX;

SELECT * FROM information_schema.processlist where id in (SELECT trx_mysql_thread_id  FROM information_schema.INNODB_TRX);

 

查询数据库事务

--查看事务

SELECT * from information_schema.INNODB_TRX;

--查看锁

SELECT * FROM information_schema.INNODB_LOCKs;

--查看锁等待

SELECT * FROM information_schema.INNODB_LOCK_waits;

 

文档说明

https://blog.csdn.net/yuyinghua0302/article/details/82318408

 

 

show PROCESSLIST ;

 

//查询innerdb 状态数据

show engine innodb status;