mysql 查看 竞争锁_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;

原文：http://www.cnblogs.com/janehoo/p/5588839.html