监控查询慢sql

mysql：
--查询慢sql：业务db用户

select b.time, b.host, b.id, b.state, b.user, b.db, b.info
  from information_schema.processlist b
 where b.info is not null
 order by b.time

1、查询是否锁表
show OPEN TABLES where In_use > 0;
 
2、查询进程
    show processlist
  查询到相对应的进程===然后 kill    pid
 
补充：
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 
 
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; 

计算ID

select (1000+500+500+500+500+500+500+260+280)-4641.33 from dual;
---------------------

监控查询慢sql

原文：https://www.cnblogs.com/insane-Mr-Li/p/10805381.html