-- 查看当前事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;

-- 查看当前锁定的记录
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

-- 查看锁等待情况
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

-- 查看所有进程（包括锁信息）
SHOW PROCESSLIST;

-- 更详细的进程信息（MySQL 5.7+）
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE '%locked%';

-- 查看表级锁情况
SHOW OPEN TABLES WHERE In_use > 0;

-- 查找被阻塞的事务和阻塞源
SELECT 
  r.trx_id AS waiting_trx_id,
  r.trx_mysql_thread_id AS waiting_thread,
  r.trx_query AS waiting_query,
  b.trx_id AS blocking_trx_id,
  b.trx_mysql_thread_id AS blocking_thread,
  b.trx_query AS blocking_query
FROM 
  INFORMATION_SCHEMA.INNODB_LOCK_WAITS w
JOIN 
  INFORMATION_SCHEMA.INNODB_TRX b ON w.blocking_trx_id = b.trx_id
JOIN 
  INFORMATION_SCHEMA.INNODB_TRX r ON w.requesting_trx_id = r.trx_id;

-- 终止指定线程（替换 123 为实际线程 ID）
KILL 123;