在数据库命令行中查询
select * from information_schema.processlist where command not in ('Sleep') and user not in ('mydba','event_scheduler','repl','binlogbak','system user')
找到你当时执行的语句的进程id
kill id;
在数据库命令行中查询
select * from information_schema.processlist where command not in ('Sleep') and user not in ('mydba','event_scheduler','repl','binlogbak','system user')
找到你当时执行的语句的进程id
kill id;