首页 > 数据库 >mysql too many connections

mysql too many connections

时间:2022-09-26 10:23:28浏览次数:56  
标签:show -- many connections host too mysql

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;

 

标签:show,--,many,connections,host,too,mysql
From: https://www.cnblogs.com/yexuba/p/16729972.html

相关文章