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@scrum8.com> 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
_______________________________________________ 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