常用sql SELECT * FROM information_schema.INNODB_TRX 查询 正在执行的事务: SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 查看正在锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; 查看等待锁的事务