mysql事务锁住

查看事务时间大于十秒的

SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX where TIME_TO_SEC(timediff(now(),trx_started))>10 ORDER BY trx_started

查看所有进程
SHOW PROCESSLIST 
 

查询进程

SELECT
*
FROM
information_schema.processlist WHERE USER='root'
AND command='Sleep'
and db = '库名'
order by time desc;

SELECT GROUP_CONCAT(CONCAT('kill ',Id) SEPARATOR';') AS cmd FROM information_schema.processlist WHERE command='Sleep'
AND USER='root'
and db = '库名';

使用kill 命令结束进程