MySQL 查询锁和被锁信息

最新推荐文章于 2024-07-31 09:08:05 发布

VincentQB

最新推荐文章于 2024-07-31 09:08:05 发布

阅读量2.8k

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/zwjzqqb/article/details/79179013

版权

MySQL 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

SELECT 
  r.`trx_id` waiting_trx_id,
  r.`trx_mysql_thread_id` waiting_thread,
  r.`trx_query` waiting_query,
  b.`trx_id` bolcking_trx_id,
  b.`trx_mysql_thread_id` blocking_thread,
  b.`trx_query` block_query 
FROM
  information_schema.`INNODB_LOCK_WAITS` w 
  INNER JOIN information_schema.`INNODB_TRX` b 
    ON b.`trx_id` = w.`blocking_trx_id` 
  INNER JOIN information_schema.`INNODB_TRX` r 
    ON r.`trx_id` = w.`requesting_trx_id` ;