Re: mysql client connectivity and orphaned connections

2004-07-01 Thread Egor Egorov
Jim [EMAIL PROTECTED] wrote: I'm just wondering if anyone can tell me exactly what happens when one is using the mysql client on a remote server and the connection to that server (in this case over ssh) gets dropped. if your ssh session suddenly closes, the only thing that happens is that

mysql client connectivity and orphaned connections

2004-06-28 Thread Jim
Hi, I'm just wondering if anyone can tell me exactly what happens when one is using the mysql client on a remote server and the connection to that server (in this case over ssh) gets dropped. In this case, I was in the midst of a long OPTIMIZE TABLE. Stepped out to get some coffee and the ssh

Re: mysql client connectivity and orphaned connections

2004-06-28 Thread Eric Bergen
When a connection is dropped most read only queries will be immediatly dropped, write queries such as your optimize table will continue until they complete as not to corrupt any table data or leave anything unfinished. -Eric On Mon, 28 Jun 2004 17:29:22 -0400, Jim [EMAIL PROTECTED] wrote: Hi,