mysql数据库 报错 too many connection

  • Post author:
  • Post category:mysql


show full processlist

show variables like ‘%max_connections%’;


SELECT substring_index(host, ‘:’,1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;

show global variables like ‘%wait_timeout’;

set global max_connections = 1000;

set global wait_timeout=250;



版权声明:本文为luwei_cool原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。