php forum
php mysql forum
php mysql smarty
 
Topic Options
#286113 - 03/30/06 03:56 PM 'max_user_connections' issues - please!
Organizer Offline
User

Registered: 08/17/02
Posts: 34
Hi all, I am running 6.5 and just moved webhost... well everything should have been fine it ended up not. The forum constantly show white/Blank pages for the users every 2-8 click all depending... the log says that 'max_user_connections' have been reached. <br /><br />The host only allows 20 and I am not sure if that normally should be enoug or not? The forum have 20-40 simular users online usually, the record is 178. On the setup I found persistant connection to be on... so I turned this off, however nothing really seamed to help???<br /><br />1. Does UBB threads not properly close connections? <br />2. Is the 20 limit a problem for a forum with the mentioned number of users logged in at the same time?<br />3. Is there anything else than can be causing this?<br /><br />Any tips and comments are welcome, getting frusteradet as it looks i need to move from the host we just moved to!<br /><br />Christian
_________________________
Organizer

Top
#286114 - 03/30/06 06:54 PM Re: 'max_user_connections' issues - please! [Re: Billyo]
AllenAyres Administrator Offline
I type Like navaho

Registered: 03/10/00
Posts: 25452
Loc: Texas
20 will be enough for small-medium websites, your website may need more. <br /><br />Make sure persistent connections are actually turned off, I'd check again, that sounds like where the issue may be. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
- Allen wavey
- What Drives You?

Top
#286115 - 03/31/06 10:43 AM Re: 'max_user_connections' issues - please! [Re: SurfMinister]
Organizer Offline
User

Registered: 08/17/02
Posts: 34
I checked the include for the config and persistant is set to ""... I also edited the sql.inc or whatever it is called that I believe is the one file that opens all connections and the line that could start query_pconnect I fixed so that it anyway only can do a query_connect!<br /><br />It does for me still sound like something else is wrong, but I can't figure out what.<br /><br />1. Do ubb threads close its connections anywhere? I cant see the use of mysql_close() anywhere... but there might be another way it does it that I am not aware of?<br /><br />2. My change above to make very sure it uses non persistant is coorect?<br /><br />3. For around 50-10 users using the forum all the time, how many connections would me a good minimum that should let everything run smooth?<br /><br />Also added an attachment showing current processlist


Attachments
129239-processlist.gif (18 downloads)

_________________________
Organizer

Top
#286116 - 04/23/06 12:12 AM Re: 'max_user_connections' issues - please! [Re: Billyo]
AllenAyres Administrator Offline
I type Like navaho

Registered: 03/10/00
Posts: 25452
Loc: Texas
Sorry for the late reply, I've been out of the country. You've got some awful long connections there - it really does seem like persistant connections are on. What version of php/mysql are you running? I'm really not sure if threads closes connections properly - that'd be a question for Rick, he's by occasionally, hopefully he'll have an answer for that.
_________________________
- Allen wavey
- What Drives You?

Top


Moderator:  Gizmo 
Who's Online
0 registered (), 23 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Wisdom needed
by Gizmo
Today at 10:54 AM
How to hide sub forums from summary page
by blaaskaak
Yesterday at 09:54 AM
Spell Check [beta]
by Bill B
12/01/08 09:16 PM
PhotoPost BB Code Popup
by AllenAyres
12/01/08 09:41 AM
Problems reading a lot of old posts here
by AllenAyres
12/01/08 09:35 AM
Forum 'Trader Ratings'.
by AllenAyres
12/01/08 09:33 AM
Customization needed
by Gizmo
11/12/08 12:28 PM
New Mods
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Spell Check [beta]
by
10/17/06 09:24 PM
Newest Members
Truth, David DelMonte, nick1, Begbie, cenk
13364 Registered Users
Top Posters
AllenAyres 25452
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks