maria-discuss team mailing list archive

[Joshua Partogi <jpartogi@xxxxxxxxxx>]

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 <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.
>
>
> Regards,
> Arjen.