I am having a problem with mongrel not responding after a period of
inactivity. Searching the various logs and such, it seems to be a
problem with mysql. The facts:
- I am running CentOS5
- I do not have a warning about using the non-production mysql driver
at the top of my log, so I presume I am using the C version from the
- I added this statement to my production.rb file located at config/
ActiveRecord::Base.verification_timeout = 30
In fact, I tried this first at 14400 as suggested in the Mongrel FAQ,
to no better result.
- I set the wait_timeout mysql variable to 604000 using set global
wait_timeout = 604000. This value sticks when set.
- I set the wait_timeout mysql variable to 604000 using set
wait_timeout = 604000. This value sticks only as long as my mysql
session is open. Show variables like "wait_timeout" yields 604000.
However, when I close that session and go back in, the value is back
When the problem occurs, the production.log shows "Broken Pipe".
Restarting mongrel fixes it.
I presume the wait_timeout variable is to blame. The mysql
documentation says it will get it's value from the global wait_timeout
setting, but that is not happening.
I also tried setting the interactive_timeout, but that had no impact.