maria-discuss team mailing list archive
Mailing list archive
Re: MariaDB shutdowns silently
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.
On Thu, Apr 22, 2010 at 4:30 AM, Arjen Lentz <arjen@xxxxxxxxxxxxx> 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.