Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/morocco/public_html/forum/includes/class_core.php on line 314
MySQL Error :
Error Number :
Request Date : Thursday, April 21st 2011 @ 10:30:57 AM
Error Date : Thursday, April 21st 2011 @ 10:30:57 AM
Script : http://www.morocco-knowledgebase.net/forum/forum.php
Referrer :
IP Address : 82.69.99.119
Username :
Classname : vB_Database
MySQL Version :
____________________________________
I'm getting periodic problems with this error and have had a series of online chats with the technical support guys at Hostgator who start off telling me that I need to upgrade to a better package. Seeing as I've never had more than 9 concurrent online users (my forum is still under development), I refused to accept this.
Then I found one of THEIR technical documents that reckoned a site with 500 currently active members will rarely hit the limit that Hostgator sets of 25 MySQL connections, as the connections are taken and released very quickly.
I found this article: http://www.logician.org/10-vbulletin...ql-connections which recommended turning persistent connection off, so I did that.
HostGator say it is probably an error in the vBulletin software. But this is a completely vanilla site, no script changes/mods whatsoever (other than turning persistent off), and my thinking was that if it was a vBulletin issue, other users would get similar problems.
The problem goes away for a while, then returns—nothing from 9 April until today, and then had eight errors in one hour. I don't understand what the problem is and (assuming it's not vBulletin?) I need some ammunition to go back to HostGator with.
It seems that webcrawlers are counted in the number of connections, could they be part of the problem?
Tim
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/morocco/public_html/forum/includes/class_core.php on line 314
MySQL Error :
Error Number :
Request Date : Thursday, April 21st 2011 @ 10:30:57 AM
Error Date : Thursday, April 21st 2011 @ 10:30:57 AM
Script : http://www.morocco-knowledgebase.net/forum/forum.php
Referrer :
IP Address : 82.69.99.119
Username :
Classname : vB_Database
MySQL Version :
____________________________________
I'm getting periodic problems with this error and have had a series of online chats with the technical support guys at Hostgator who start off telling me that I need to upgrade to a better package. Seeing as I've never had more than 9 concurrent online users (my forum is still under development), I refused to accept this.
Then I found one of THEIR technical documents that reckoned a site with 500 currently active members will rarely hit the limit that Hostgator sets of 25 MySQL connections, as the connections are taken and released very quickly.
I found this article: http://www.logician.org/10-vbulletin...ql-connections which recommended turning persistent connection off, so I did that.
HostGator say it is probably an error in the vBulletin software. But this is a completely vanilla site, no script changes/mods whatsoever (other than turning persistent off), and my thinking was that if it was a vBulletin issue, other users would get similar problems.
The problem goes away for a while, then returns—nothing from 9 April until today, and then had eight errors in one hour. I don't understand what the problem is and (assuming it's not vBulletin?) I need some ammunition to go back to HostGator with.
It seems that webcrawlers are counted in the number of connections, could they be part of the problem?
Tim
Comment