天涯小站 2.0

 找回密码
 注册
搜索
查看: 4540|回复: 4

just got this error a couple of times

[复制链接]
发表于 2009-2-27 00:16:01 | 显示全部楼层 |阅读模式
Just FYI Little Rain & Little Star:

Discuz! info: Can not connect to MySQL server

Time: 2009-2-27 12:11am
Script: /index.php

Error: User tyxzwww_dbuser already has more than 'max_user_connections' active connections
Errno.: 1203

Similar error report has been dispatched to administrator before.

http://faq.comsenz.com 搜索此错误的解决方案
回复

使用道具 举报

发表于 2009-2-27 01:01:16 | 显示全部楼层
感觉是程序的一个BUG,用户连接没有及时关掉,结果太多超过限额,最后就连不上了。不过,风雨处理得比较快,没几分钟就好了。
回复 支持 反对

使用道具 举报

发表于 2009-2-27 09:18:30 | 显示全部楼层
谢谢小宋和雪月。正在设法解决中。
回复 支持 反对

使用道具 举报

发表于 2009-2-27 20:18:27 | 显示全部楼层
How many max mysql connections you get?

If you are on a small hosting company, you may ask them to increase your mysql connections.   If you are on a big hosting company, they usually set up as it is and no way you can increase it.

I used to run a dedicated server myself, so no limits on this issue.  But dedicated server costs too much.  Shared hosting is good enough in most cases.  Now I switch my sites to shared hosting.

I got 25 max. mysql connections.  They said for a forum with 300-400 active users, it will only hit the 25 limits once a while.  I will have to wait and see.
回复 支持 反对

使用道具 举报

发表于 2009-2-27 21:02:15 | 显示全部楼层
4# searain

Thanks Searain.  Yes unfortunately, I am with a large hosting comany and its limiation is close to yours.  I am considering to either upgrade or some other short term fix.

I will have to restore the 60 second limit if the problem comes up again.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

手机版|天涯小站

GMT-5, 2026-1-27 08:34 PM

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表