监控查询慢sql

作者官方网站:http://www.wxl568.cn

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;