mysql too many connections

mysql too many connections

-- 最大连接数
show variables like 'max_connections';
-- 最大返回数          Max_used_connections/max_connections * 100%  应该要大于10%
show global status like 'Max_used_connections'
-- 主机 连接数
SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;
-- 显示全部连接信息
show full processlist;