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
Monetize Your Site
#286114 - 03/30/06 06:54 PM Re: 'max_user_connections' issues - please! [Re: Billyo]
AllenAyres Offline

I type Like navaho

Registered: 03/10/00
Posts: 25580
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 (32 downloads)

_________________________
Organizer

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

I type Like navaho

Registered: 03/10/00
Posts: 25580
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 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks