作者官方网站: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;