Re: How to connect in non-interactive mode

2002-02-13 Thread Becky McElroy
Dan, Thanks for your response. I see what you're saying. However, in our case, the only 'clients' connecting to the MySQL server are software modules, no humans. Well actually, humans too, but only through our software modules. So no clients getting disconnected until the server is restarted is

RE: How to connect in non-interactive mode

2002-02-13 Thread Daniel Rosher
. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: How to connect in non-interactive mode Dan, Thanks for your response. I see what you're saying. However, in our case, the only 'clients' connecting to the MySQL server are software modules, no humans. Well actually, humans too

RE: How to connect in non-interactive mode

2002-02-11 Thread Daniel Rosher
If you set the interactive_timeout to infinite then no clients will get disconnected until the server is restarted. I know the perl DBI allows for a client to implement ping ($dbh-ping) ... this will reset the timeout for that particular client, allow the client to check for connectivity, without