select r.trx_id waiting_trx_id, r.trx_mysql_thread_Id waiting_thread,
r.trx_query waiting_query, b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query
from information_schema.innodb_lock_waits w inner join information_schema.innodb_trx b on b.trx_id = w.blocking_trx_id
MySQL查询阻塞语句
最新推荐文章于 2024-06-08 16:00:53 发布
通过SQL语句,从information_schema.innodb_lock_waits和information_schema.innodb_trx表中获取当前数据库中的阻塞事务信息,包括等待事务ID、等待线程、阻塞事务ID、阻塞线程及各自执行的查询,帮助诊断和解决MySQL的锁冲突问题。
摘要由CSDN通过智能技术生成