网站多刷新几次就出现 mysql 数据库无法连接

• 请不要在回答技术问题时复制粘贴 AI 生成的内容

This topic created in 4476 days ago, the information mentioned may be changed or developed.

网站多刷新几次就出现error info: Can't Connect MySQL Server(localhost:3306)! 去网上查了下可能是最大连接数造成的，去服务器上执行 netstate -an 发下127.0.0.1:3306 TIME_WAIT 的特别多达到5000个了。如果不限制 mysql使用端口数，估计更多，请教！

MySQL

刷新

5 replies • 1970-01-01 08:00:00 +08:00

shiniv

Feb 19, 2014

加个像memcached之类的缓存软件看看

est

Feb 19, 2014

应该用mysql 的 SHOW FULL PROCESSLIST\G 去查

hellohacker

Feb 19, 2014

@est
***************************
Id: 4167
User: root
Host: localhost:4547
db: NULL
Command: Sleep
Time: 745
State:
Info: NULL
***************************
Id: 4448
User: root
Host: localhost:4893
db: o2o
Command: Sleep
Time: 775
State:
Info: NULL
***************************
Id: 24163
User: root
Host: localhost:4278
db: NULL
Command: Sleep
Time: 217
State:
Info: NULL
***************************
Id: 25717
User: root
Host: localhost:3395
db: o2o
Command: Sleep
Time: 138
State:
Info: NULL
***************************
Id: 31113
User: root
Host: localhost:4880
db: NULL
Command: Query
Time: 0
State: NULL
Info: SHOW FULL PROCESSL
5 rows in set (0.00 sec)

fire9

Feb 19, 2014

检查你的程序吧，为啥连接不释放呢？

ijophy

Feb 19, 2014

可能是程序本身写的有问题
疑似mysql connect 没有释放