# 首先执行下面sql, 查询锁表数据
select * from information_schema.innodb_trx
# 删除运行进程锁ID
kill {trx_requseted_lock_id}
# 批量搜索并转换为 kill 语句
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root';
#即可批量执行操作
# 首先执行下面sql, 查询锁表数据
select * from information_schema.innodb_trx
# 删除运行进程锁ID
kill {trx_requseted_lock_id}
# 批量搜索并转换为 kill 语句
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root';
#即可批量执行操作