Becky, You would have to change NET_WAIT_TIMEOUT in mysql_com.h in the source from 8*60*60 to n*60*60 where n is in hours, then recompile.
Regards, Dan > -----Original Message----- > From: beckymcelroy [mailto:beckymcelroy]On Behalf Of Becky McElroy > Sent: Wednesday, 13 February 2002 8:08 a.m. > 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, 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
