Drew,
It is a good idea to explicitly close the connection and release the
connection handle on the server side. If Apache PHP threads do not exit
normally the database session can remain open. This leaves a zombie
connection on the database server.
What is your connection/close logic and what driver are you using?
Best regards,
Andrew
---------------------------------------
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness Infrastructure Technology
http://www.openlinksw.com
On 2/4/01 8:26 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anyone know of or have a problem that means that the
> HTML server will not receive the message back from the MySQL
> server to say close the connection.
> The two servers are on two seperate machines.
> The html server is Apache using the PHP scripting language.
> The error messages I am getting, not so much error messages but
> messages, when I do a netstat on the html machine state that alot
> of the sql connections are time_wait or close_wait. This should
> cause no problem I here you say but when the majority of the html
> server connections are on time_wait or close_wait then the site
> starts to slow right down. And eventually cause database server
> busy errors for users. On the SQL server the netstat results appear
> to be fine with the majority of them being Established. Can any
> shed some light on this problem or even tell me of a way to fix it. If
> any questions about the problem need to be asked I will try and
> answer them. Thanks in advance.
>
> Drew
>
> Andrew Toussaint
> Richardson-Shaw Pty Ltd
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
