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 what we want. Some of them, in this case our system logger, may have long periods of inactivity (ie, overnight, more than 8 hours, no logs to store in the database, so no activity on that client connection). So... if there is a way to set the interactive_timeout to infinite, that would be most handy.
Regards, Becky Daniel Rosher wrote: > 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 > having to make ever client connect forever!!. I'm sure the JDBC driver will > allow for this. > > Regards, > Dan > > > -----Original Message----- > > From: beckymcelroy [mailto:beckymcelroy]On Behalf Of Becky McElroy > > Sent: Tuesday, 12 February 2002 9:31 a.m. > > To: [EMAIL PROTECTED] > > Subject: How to connect in non-interactive mode > > > > > > Hello- > > > > How does one run a client in non-interactive mode? Or, is there a way > > to set interactive_timeout at the MySQL server to infinite? We have a > > software component connecting to MySQL (using Mark Matthews JDBC driver) > > and there may be a long time (> 8 hours) of inactivity. > > > > Any suggestions much appreciated - > > > > Becky McElroy > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- Becky McElroy Scientific Software Engineering, Inc. 1004 Copeland Oak Drive Morrisville, NC. 27560 Phone: 919-462-0303 ext.24 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php