ITPub博客

首页 > 数据库 > MySQL > Check connection related issue of mysql

Check connection related issue of mysql

原创 MySQL 作者:yuanqc 时间:2018-09-30 16:29:29 0 删除 编辑

Check connection issue of mysql


#show connection configuration
show variables like '%max_connection%';


#Change the limitation of max_connection temporarily
set global max_connections=600;


#check current status
status;

#check how many processes running
show processlist;


#Kill the locked connections
for id in `mysqladmin processlist | grep -i locked | awk '{print $1}'`
do
   mysqladmin kill ${id}
done


#Run killing sql

source kill_thread_id.sql


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10973950/viewspace-2215352/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    47
  • 访问量
    102564