MySQL bug? [message #6450] |
Fri, 11 October 2002 15:34 |
ctbk
Messages: 142 Registered: April 2002 Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
Hi, in another thread I described what happens to me if I turn on persistent connections.
I suspect it is a DB problem, but I'm not sure.
The fact is now I get the same problem (much less often) even if I use non-peristent connections:
Query: Initiating mysql_connect
Server Version: Unknown
What can I do to avoid this error??
Anyone knows what is the problem?
(the result of this malfuncioning is a blank page <html><body></body></html> or something like that.)
~
~
:wq
|
|
|
Re: MySQL bug? [message #6452 is a reply to message #6450] |
Fri, 11 October 2002 16:17 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Persistant connection should not be used unless you are 110% certain your server is properly configured. The reason for this is fairly simple. MySQL has a limit on the number of opened connections at any one time. When you use persistant connections each Apache child will eventually have an open connection to MySQL. This will result in lower number of avaliable MySQL connection being avaliable at any one time and could result in various problems.
FUDforum Core Developer
|
|
|
|
Re: MySQL bug? [message #12957 is a reply to message #12876] |
Thu, 18 September 2003 16:45 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
You can cleanup all persistent connections by restarting apache or restarting mysql. The prior is easier. I DO NOT recommend using persistent connections.
FUDforum Core Developer
|
|
|