mysql查询进行中的sql语句

确定是否锁表
select * from information_schema.innodb_locks;

查询正在锁的事务
select * from information_schema.innodb_locks;

查询等待锁的事务
select * from information_schema.innodb_lock_waits;

查询未提交的事务
select * from information_schema.innodb_trx

查询所有的线程
select * from information_schema.PROCESSLIST;