show global variables like ‘wait_timeout’; # 查询最大等待时间
set global wait_timeout=60; # 设置最大等待时间
SHOW PROCESSLIST; # 查询sql 进程
kill 10577; # 杀死某个id
select * from information_schema.processlist where user=‘’; #
select concat(‘KILL ‘,id,’;’) from information_schema.processlist where user=‘’;
show variables like ‘%max_connections%’;