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

    Add to del.icio.us
  Digg  Digg it
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: 25411
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: 25411
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 
Top Posters Last 30 Days
AllenAyres 12
Gizmo 10
S7ARBVCK 2
blaaskaak 2
Cambridge 1
Murphdog 1
MattUK 1
Who's Online
0 Registered (), 23 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
[7.3.1] add search to showmembers page
by blaaskaak
Today at 04:50 AM
BeyondCompare v3.00
by blaaskaak
09/05/08 02:46 PM
Noob - need help, or a reality check!
by Gizmo
09/04/08 03:21 AM
Here I am! Rock me like a Hurricane!
by AllenAyres
09/02/08 03:05 PM
[7.x] Generic Page Outside of forum directory
by Gizmo
08/30/08 05:43 PM
Team UBBDev Rides Again!
by Gizmo
08/28/08 11:45 PM
Multiple Identity Detector
by MattUK
08/28/08 04:10 PM
New Mods
[7.3.1] add search to showmembers page
by blaaskaak
Today at 04:50 AM
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks