Hi, On Mon, 2002-02-18 at 18:56, Craig Vincent wrote: > <snip> > I am using MySql server in my application. > My application needs MySql server to be running for 24 hours and needs to > make connection with server at any time. > I have heared that by default MySql server will close the connection after 8 > hours. So, does it mean that after every 8 hours I need to restart MySql > server? > If it is true, is there any solution for it? > How can I run MySql server for 24 hours without manual intervention? > </snip> > > You're close, it's by default a MYSQL server will close an IDLE connection > after 8 hours....IDLE being the operative word....as long as your > application runs a query at least once every 8 hours (assuming you keep the > timeout at the default value) you won't have a problem.
And even if the connection is closed or lost some other way, it is not something to restart the server for! Goodness. The client can simply reconnect, and in fact most will do so automatically without the application even noticing that the connection was gone for a bit. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
