连接数被占满
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;