LInux网站提示“Too many connections”的解决方法

连接数超过了 MySQL 设置的值,与 max_connections 和 wait_timeout 都有关系,wait_timeout 的值越大,连接的空闲等待就越长,这样就会造成当前连接数越大.

解决方法:MySQL 服务的配置,修改 MySQL 配置文件,Windows下为 my.ini,Linux下为 my.cnf,中的参数:

1.max_connections= 1000

2.wait_timeout = 5

如果没有请自行添加以上两句,修改后重启 MySQL.

·Mysql "Too many connections"错误解决办法(2014-09-24)
·mysql ERROR 1040: Too many connections(2014-10-02)
·MySQL连接too many connection错误并且启动时间特别长(2014-10-04)
·Mysql “Too many connections” 的解决方法(2014-10-04)
·Host ‘XXXXXX’ is blocked because of many connection errors(2014-10-13)
·mysql出现too many connections错误提示(2014-10-14)
·mysql too many connections(2014-10-17)
·MYSQL提示 max_open_files: 2048 max_connections: 800 table_cache: 619(2014-09-23)
·ERROR 1040: Too many connections问题解决办法(2014-09-28)
·mysql 1040 Too many connections错误(2014-10-08)
·mysql 1040错误提示Too many connections的解决方法(2014-10-12)

相关文章