mysql 查看连接数设置连接数以及问题排查

连接数被占满

SHOW VARIABLES LIKE '%max_connections%';  查看最大连接数设置
SHOW GLOBAL STATUS LIKE 'Max_used_connections'; 查看已使用连接数

set GLOBAL max_connections = 200;修改最大连接数

SELECT  SUBSTRING_INDEX(HOST,":",1),COUNT(1) FROM information_schema.processlist GROUP BY SUBSTRING_INDEX(HOST,":",1) ;  产看不同ip占用连接数

 

最大错误数导致连接失败

is blocked because of many connection errors; unblock with \'mysqladmin flush-hosts\'

执行flush  hosts；就可以了

最大错误连接数查看以及修改

 select * from performance_schema.host_cache

SHOW VARIABLES LIKE 'max_connect_errors';

SET GLOBAL max_connect_errors = 100;