MySQL如何查看锁

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如何查看锁

标签：