thinkphp出现 mysql too many connections

Question

thinkphp mysql too many connection
这个错误！
大家有没有遇到呀？
求助~
我的mysql最大连接数是300

Answer 1

Log in to the mysql terminal and use show full processlist to view the mysql connection information.

Answer 2

Mysql has reached the upper limit of the number of connections. Just modify the configuration of mysql.

show variables like '%max_connections%';
set global max_connections = 5000;

If the number of connections is more than 5,000, it is necessary to separate the read and write from the master-slave replication to avoid the upper limit of single-machine read and write.

Answer 3

Restart mysql, or disconnect from the Internet immediately, it is possible that your mysql database has been Ddosed by someone else