查看锁信息

SELECT
 r.trx_id waiting_trx_id,
 r.trx_mysql_thread_id waiting_thread,
 LEFT (r.trx_query, 20) waiting_query,
 concat(
  concat(lw.lock_type, ' '),
  lw.lock_mode
 ) waiting_for_lock,
 b.trx_id blocking_trx_id,
 b.trx_mysql_thread_id blocking_thread,
 LEFT (b.trx_query, 20) blocking_query,
 concat(
  concat(lb.lock_type, ' '),
  lb.lock_mode
 ) blocking_lock
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
INNER JOIN information_schema.innodb_locks lw ON lw.lock_trx_id = r.trx_id
INNER JOIN information_schema.innodb_locks lb ON lb.lock_trx_id = b.trx_id

posted @ 2015-12-02 14:09 文采飞扬 阅读(...) 评论(...) 编辑 收藏