Mysql 查询锁状态常用命令

show status like '%lock%;

select * from information_schema.processlist;
select * from information_schema.processlist where state like "%Waiting%";
select * from information_schema.innodb_trx;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

SELECT INNODB_LOCKS.*
FROM INNODB_LOCKS
JOIN INNODB_LOCK_WAITS
  ON (INNODB_LOCKS.LOCK_TRX_ID = INNODB_LOCK_WAITS.BLOCKING_TRX_ID);

SELECT * FROM INNODB_LOCKS
WHERE LOCK_TABLE = db_name.table_name;

SELECT TRX_ID, TRX_REQUESTED_LOCK_ID, TRX_MYSQL_THREAD_ID, TRX_QUERY
FROM INNODB_TRX
WHERE TRX_STATE = 'LOCK WAIT';

show engine innodb status;