确认进程id,用kill id杀死进程
show processlist;
select * from information _ schema.process list;
询问正在运行的进程
select * from information _ schema.processlistwherelength (info ) 0;
//询问是否锁定表格
show OPEN TABLES where In_use 0;
//检查人员被锁定
select * from information _ schema.innodb _ locks;
//等待锁定
select * from information _ schema.innodb _ lock _ waits;
//杀死锁表的过程
基尔12041