mysql操作

-- mysql 查看mysql 是否设置了自动提交

show variables like 'autocommit';

--关闭 自动提交

set autocommit = 0;

--打开

set autocommit = 1;

 

----- 查看 mysql 正在执行的进程列表
show processlist;

--杀死进程

kill id;

 

 

-- 杀死该服务器请求的进程

select * from information_schema.processlist where host like '10.253.101.5%';

select concat('kill ',id,';') from information_schema.processlist where host like '10.253.101.5%';