Hi Arjen, Can you please explain to me how a persistent connection would affect MySQL to shutdown by itself? I have looked at the Ruby MySQL driver code and there is nothing related to persistent connection. I searched through google and found that persistent connection is only available in PHP MySQL driver.
Thank you very much in advance for your time and assistance. Kind regards, Joshua -- http://twitter.com/scrum8 On Thu, Apr 22, 2010 at 4:30 AM, Arjen Lentz <ar...@openquery.com> wrote: > Hi Joshua > > On 21/04/2010, at 3:07 AM, Joshua Partogi wrote: >> >> I am getting MySQL server has gone away. I think there is an issue >> with how the MySQL Ruby driver establish connection to MySQL. I have >> been noticing that when there is inactivity in the application, MySQL >> would just fade away silently. I am going to monitor this again and >> see what is the root cause of this. > > Just for clarity, this appears to be your connection going away, not the > server crashing or shutting down or anything. > To make sure of this you can check the Uptime in SHOW GLOBAL STATUS. > > The time an inactive connection stays in place is controlled by wait_timeout > for applications (and interactive_wait_timeout for mysql cmdline client). > Does your Ruby environment use persistent connections? Then still it should > handle possibly loss of a connection as that can be caused just by general > network errors as well - it's transient and not really an error that needs > to break things on the front end or otherwise bother a user. > > > Regards, > Arjen. _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
