Re: Setting the reconnect flag in MySQL 4.0.24

2005-11-22 Thread SGreen
m: <[EMAIL PROTECTED]> > To: "Betty Trakimas" <[EMAIL PROTECTED]> > Cc: > Sent: Tuesday, November 22, 2005 12:06 PM > Subject: Re: Setting the reconnect flag in MySQL 4.0.24 > > > > "Betty Trakimas" <[EMAIL PROTECTED]> wrote on

Re: Setting the reconnect flag in MySQL 4.0.24

2005-11-22 Thread Gleb Paharenko
Hello. MYSQL structure has a field reconnect, you may set it from your application. Also, as I remember, if you're using prepared statements your client program automatically reconnects. Betty Trakimas wrote: > Hello, > > We just upgraded from 3.23.58 to 4.0.24. Our database connectio

Re: Setting the reconnect flag in MySQL 4.0.24

2005-11-22 Thread Betty Trakimas
TED]> To: "Betty Trakimas" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, November 22, 2005 12:06 PM Subject: Re: Setting the reconnect flag in MySQL 4.0.24 "Betty Trakimas" <[EMAIL PROTECTED]> wrote on 11/22/2005 11:08:51 AM: Hello, We just upgraded from 3.23

Re: Setting the reconnect flag in MySQL 4.0.24

2005-11-22 Thread SGreen
"Betty Trakimas" <[EMAIL PROTECTED]> wrote on 11/22/2005 11:08:51 AM: > Hello, > > We just upgraded from 3.23.58 to 4.0.24. Our database connection, which can > remain open for a very long time, is timing out after being idle overnight, > where it never had in 3.23.58. I learned from the man

Setting the reconnect flag in MySQL 4.0.24

2005-11-22 Thread Betty Trakimas
Hello, We just upgraded from 3.23.58 to 4.0.24. Our database connection, which can remain open for a very long time, is timing out after being idle overnight, where it never had in 3.23.58. I learned from the manual that there is a global variable WAIT_TIMEOUT, which appears to be set at 2880