• Welcome to the world's largest Chinese hacker forum

    Welcome to the world's largest Chinese hacker forum, our forum registration is open! You can now register for technical communication with us, this is a free and open to the world of the BBS, we founded the purpose for the study of network security, please don't release business of black/grey, or on the BBS posts, to seek help hacker if violations, we will permanently frozen your IP and account, thank you for your cooperation. Hacker attack and defense cracking or network Security

    business please click here: Creation Security  From CNHACKTEAM

数据源拒绝建立连接 来自服务器:的消息“连接过多”


Recommended Posts

这里数据库连接数不够,需要调整。

查看当前使用的最大连接数。

显示全局状态,如“最大已用连接数”;

检查Mysql数据库中设置的最大连接数。

显示变量,如“% max _ connections %”;

有两种方法可以设置。

一个是

设置全局最大连接数=2000;//这里的连接数是由Noel找到的当前使用的最大连接数设置的,

例如,当前使用的最大连接数是165,最好将数据库中设置的最大连接数设置为200。

该设置将在数据库重新启动后过期。

第二种类型

查询mysql服务的安装位置

psecf | grep MySQL

查找my.cnf位置

find/-name my.cnf

vim my.cnf

tfhc4tt1nlb3365.png

然后重启mysql服务器。

服务mysql重启

以防重启MySQL失败。未找到服务:单元

使用服务mysqld restart重新启动。

显示完整进程列表//查看当前使用情况

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now