Forum running slow

[zr1mom]

Sorry I know the forum for sometime now has been running slow. Below is the error that we are getting. I have spoke to the people that manage the forum and they say there is nothing they can do. We might have to move the forum to another provider.

If anyone is a DB expert that can look at the error and let me know what we can do I would appreciate it.

Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User zr1netre already has more than 'max_user_connections' active connections /hermes/bosweb/web243/b2437/ipw.zr1netre/public_html/forum/includes/class_core.php on line 311

Thanks,
Mom

[Dynomite]

It is overloaded or not properly closing connections. Most likely overloaded.

In the code, the programmer must 'close' a connection each time he requests db data. If this is not done every time, it causes orphaned connections and you eventually run out of connections until they time out. It could also be coded fine, but that there are simply too many users or too many forums using the same db server.

[flyin ryan]

50-50 here, Sometimes slow as heck, other times fine :dontknow:.

[Jeffvette]

http://www.logician.org/10-vbulletin-max_user_connections-setting-persistent-mysql-connections-and-too-many-open-mysql-connections

[Z Factor]

http://www.logician.org/10-vbulletin-max_user_connections-setting-persistent-mysql-connections-and-too-many-open-mysql-connections

Thanks for the link. :thumbsup:

:cheers:

[flyin ryan]

http://www.logician.org/10-vbulletin-max_user_connections-setting-persistent-mysql-connections-and-too-many-open-mysql-connectionsOh' Ya'...That answer's everything :icon_scra, LOL. I'm just a dumb engine builder, LMAO...

[Jeffvette]

Oh' Ya'...That answer's everything :icon_scra, LOL. I'm just a dumb engine builder, LMAO...


Vroom, Vroom.

[Jeffvette]

Your vbulletin is openning too many mySQL connections in the server, then fails to close them, hence you get the problem just like smarty pants said in post #2 :sign10:


Did you offer a solution :blahblah:





















:-D

[Dynomite]

Did you offer a solution :blahblah:







What is all this vacant space for :sign10:

Oh...I know...you offered a solution in white letters :sign10:













:-D
:-D