MySQL如何查看鎖

標籤：

A 通過視圖表查

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

  INNER JOIN information_schema.innodb_trx r  ON  

r.trx_id = w.requesting_trx_id

 

B 通過參數查看

show global variables like ‘%lock%‘;

 

C 查看innodb引擎的狀態

show engine innodb status\G;

MySQL如何查看鎖