分类：查看事务

2021
01-21

MySQL 查看事务和锁情况的常用语句分享

一些查看数据库中事务和锁情况的常用语句查看事务等待状况：SELECTr.trx_idwaiting_trx_id,r.trx_mysql_thread_idwaiting_thread,r.trx_querywaiting_query,b.trx_idblocking_trx_id,b.trx_mysql_thread_idblocking_thread,b.trx_queryblocking_queryFROMinformation_schema.innodb_lock_waitswINNERJOINinformation_schema.innodb_trxbONb.trx_id=w.blocking_trx_idINNERJOINinformation_sc... 继续阅读 >