mysql如何查看正在执行的sql语句
show variables like '%general_log%'
#开启
set global general_log = on;
# 关闭
set global general_log = off;
然后去具体目录查看文件
#查看进行中的事物
SELECT * FROM information_schema.innodb_trx ;
#查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
#查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
#首先查询是否锁表
SHOW OPEN TABLES WHERE In_use > 0;
#查询进程
SHOW PROCESSLIST;