On Wednesday 04 February 2009 12:39:47 pm Paul McNett wrote: > johnf wrote: > > Remind me why we need the "KeepAliveInterval". > > To keep the server from dropping the connection even though we haven't sent > any client queries in a while. > > My time and billing app goes against my remote MySQL server, and sometimes > I leave the app open all day, then enter a line item and press "save", and > boom! Dabo bails out of the app completely (sys.exit()) because the > connection is gone and we don't have a way to handle it. > > I think that the bailing out completely needs to be looked at (I don't even > get a chance to copy my information to the clipboard first?) but the > KeepAliveInterval may help the problem from happening in the first place. > > Actually, it won't even help in the case where I put my laptop to sleep and > open it again in a few hours - the server will have already dropped the > connection, so it is indeed something to be experimented with sparingly. > > Paul
I have seen the question "does the connection time out" asked many times with respect to several of the database engines. I don't recall the answer for MySQL but I think most (all) don't have a time out. Could it be something else that is timing out? I do know routers have time outs. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
