mysql查看事务状态及死锁命令

事务 SELECT
trx_id,
trx_state,
trx_started,
trx_requested_lock_id,
trx_wait_started,
trx_mysql_thread_id,
trx_query
FROM
INFORMATION_SCHEMA.INNODB_TRX;

死锁
-- Command to view the latest detected deadlock in MySQL
SHOW ENGINE INNODB STATUS;

LATEST DETECTED DEADLOCK