Persistent Connections [message #12598] |
Mon, 18 August 2003 04:42 |
Victor_M
Messages: 51 Registered: January 2003 Location: NJ, USA
Karma: 0
|
Member |
|
|
I had this feature turned on and in the last two days we were getting error messages for exceeding the number of connections. I turned it off and it seems to have solved that problem (if not solved, at least reduced it cause I haven't gotten one since).
I'm puzzled because when I look at the forum stats, the number of posts and visitors over the last two days is not higher than what it has been all month. I wonder why this would happen only in the last 2 days. In fact, I was getting that message during hours when the number of visitors is at its lowest number (we have a limit per database set at 50).
And on a related topic, we had one thread with 2,500+ posts. Is that a possible problem related to these errors? Is there a "rule of thumb" number of posts that we should not exceed per thread?
[Updated on: Mon, 18 August 2003 04:43] Report message to a moderator
|
|
|
Re: Persistent Connections [message #12601 is a reply to message #12598] |
Mon, 18 August 2003 12:06 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The persistent connection problem is not related to the number of message or your forum's traffic. It is due to the way persistent database connections are implemented in PHP and cannot be helped. Unless you really fine tune your SQL server and Apache webserver you are alsmost certain to come across a problem of "too many open connections".
FUDforum Core Developer
|
|
|
|
Re: Persistent Connections [message #16510 is a reply to message #16508] |
Tue, 03 February 2004 15:40 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
FUDforum has not requirment for connections, the connections are opened by PHP processes. For example if you have 100 apache children running and 1 application uses persistent connection eventually you'll have 100 persistent connections opened since each apache child will have an active connection.
FUDforum Core Developer
|
|
|