查看锁情况的SQL

Select * from information_schema.innodb_trx; -- 记录当前运行的事务

Select * from information_schema.innodb_locks; -- 记录当前出现的锁

Select * from information_schema.innodb_locks_waits; -- 记录锁等待的对应关系