1、进入 information_schema数据库,查看数据库中被锁的线程
select * from information_schema.innodb_trx;
2、可以批量查看被锁线程
SELECT concat(‘KILL ‘,id,’;') FROM information_schema.processlist WHERE user=’root’;
3、找到对应的线程Id,将其杀死
kill thread_id(49308)
select * from information_schema.innodb_trx;
SELECT concat(‘KILL ‘,id,’;') FROM information_schema.processlist WHERE user=’root’;
kill thread_id(49308)