show processlist;//查询mysql所有连接线程
SELECT CONCAT('KILL ',id,';') FROM information_schema.`PROCESSLIST` WHERE DB = 'topsale';//杀死他有连接线程
show processlist;//查询mysql所有连接线程
SELECT CONCAT('KILL ',id,';') FROM information_schema.`PROCESSLIST` WHERE DB = 'topsale';//杀死他有连接线程
转载于:https://www.cnblogs.com/Yusco/p/10712482.html