<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. Sincerely, Craig Vincent --------------------------------------------------------------------- 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