maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Hi Joshua,

Is your database server crashing or are you getting a 'MySQL server
has gone away' error message after some inactivity period in your
application?

To determine if your database is crashing, check the error log.  You
can determine if your database is actually restarting by checking the
'uptime' value in 'SHOW GLOBAL STATUS', or by using \s in the mysql
command line client.

If you are getting the error message but your server is not actually
restarting then there are helpful hints in the MySQL manual:
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

Likely you need to either increase wait_timeout or decrease your
recycle time in your connection pool.

--
Justin Swanhart

On Tue, Apr 20, 2010 at 8:51 PM, Joshua Partogi <jpartogi@xxxxxxxxxx> wrote:
> Dear all,
>
> I am currently running MariaDB in production and I often found it
> would shutdown itself silently after inactivity. The application
> itself is using Ruby on Rails. I have disabled the max_timeout
> settings in my.cnf but the problem still occurs. Is there anything
> else I should watch out for to prevent this issue continuing to occur?
>
> Thank you very much for your assistance.
>
> Kind regards,
> Joshua
>
> --
> http://twitter.com/scrum8
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>