首页 > 数据库技术 > 详细

监控查询慢sql

时间:2019-05-03 16:03:50      阅读:172      评论:0      收藏:0      [点我收藏+]

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;
---------------------

 

 

SELECT G.TARGET || ‘ ‘ || S.MACHINE || ‘ ‘ || ceil((G.LAST_UPDATE_TIME - G.START_TIME)*86400)  
FROM V$SESSION_LONGOPS G, V$SESSION S 
WHERE G.SID = S.SID 
AND G.SERIAL# = S.SERIAL# 
AND G.SOFAR <> G.TOTALWORK 
AND s.state <> ‘INACTIVE‘ 
AND G.OPNAME NOT LIKE ‘RMAN:%‘ 
and G.TARGET <> ‘TD_USERS‘ 
and rownum <2;

 

监控查询慢sql

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!