Mysql基于INNODB引擎的性能辅助监控语句

查询事务
SELECT * FROM information_schema.INNODB_TRX;

查询正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

查询等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

查询进程
show PROCESSLIST;

查询是否锁表
show OPEN TABLES where In_use > 0;

查看session的表
select * from sys.session;

查看当前执行的线程
select * from performance_schema.threads;

查看执行完成，但未commit的sql语句
select * from performance_schema.events_statements_current;

查看慢查询sql语句
   select * from mysql.slow_log;

查看慢查询的设置
  show variable like 'slow%'

查看加锁的状态
show engine innodb status;