查找并杀掉运行中事务

-- 获取线程id然后杀掉
SELECT * FROM information_schema.innodb_trx;
kill 36272;
kill 36275;
kill 35971;
kill 35972;

-- 其它
select * from performance_schema.events_statements_current;
show processlist;

SELECT object_name, index_name, lock_type, lock_mode, lock_data FROM performance_schema.data_locks;