ZR-1 Net Registry Forums

ZR-1 Net Registry Forums (http://zr1.net/forum/index.php)
-   Forum News (http://zr1.net/forum/forumdisplay.php?f=15)
-   -   Forum running slow (http://zr1.net/forum/showthread.php?t=11008)

zr1mom 01-25-2010 08:11 PM

Forum running slow
 
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 01-25-2010 09:04 PM

Re: Forum running slow
 
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 01-25-2010 10:17 PM

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

Jeffvette 01-25-2010 11:58 PM

Re: Forum running slow
 
http://www.logician.org/10-vbulletin...ql-connections

Z Factor 01-26-2010 01:11 AM

Re: Forum running slow
 
Quote:

Originally Posted by Jeffvette (Post 80516)

Thanks for the link. :thumbsup:

:cheers:

flyin ryan 01-26-2010 01:15 AM

Re: Forum running slow
 
Quote:

Originally Posted by Jeffvette (Post 80516)

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

Jeffvette 01-26-2010 02:55 AM

Re: Forum running slow
 
Quote:

Originally Posted by flyin ryan (Post 80518)
Oh' Ya'...That answer's everything :icon_scra, LOL. I'm just a dumb engine builder, LMAO...


Vroom, Vroom.

Jeffvette 01-26-2010 03:28 AM

Re: Forum running slow
 
Quote:

Originally Posted by Dynomite (Post 80523)
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 01-26-2010 09:52 PM

Re: Forum running slow
 
Quote:

Originally Posted by Jeffvette (Post 80524)
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


All times are GMT -4. The time now is 03:16 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Copyright ZR-1 Net Registry 2025