Hello Ben!
I am in no ways a socket expert, so I can only provide a general remark
and pass on what I got from hearsay (below):
When pursuing such things, please provide information about the
operating systems used, client/server assignment etc.
Gleb Paharenko wrote:
Hello.
MySQL usually
Hello.
MySQL usually waits some time for data from client even if connection
is broken, because MySQL could no nothing about it. The time depends
of the socket implementation of your OS (for example for TCP, connection
can be marked as established even if the other side is down for several
s
this would leave the connection
open in MySQL.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 10:05
To: mysql@lists.mysql.com
Subject: Re: Cleanup of connections
Hello.
Normally mysqld successfully closes connection if client has correctly
disconn
Hello.
Normally mysqld successfully closes connection if client has correctly
disconnected. If you want to debug this issue, please, provide
information about your operating system and MySQL version. If your
developers connect to MySQL through TCP/IP, check with netstat the state
of connect
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 09:07
To: mysql@lists.mysql.com
Subject: Re: Cleanup of connections
Hi,
They appear to be in SLEEP state
Hello.
What state do MySQL threads of your old connections have?
Ben Smith <[EM
Hello.
What state do MySQL threads of your old connections have?
Ben Smith <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 23 lines --]
>
> Hi,
>
> I've noticed that connections are sometimes left open in MySQL when i use
> the Show Processlist command
Hi,
I've noticed that connections are sometimes left open in MySQL when i use
the Show Processlist command. Does MySQL do any form of housekeeping to
close old connections or is it just down to the developers to make sure they
issue close connection statements?
Thanks.
==
