On Thu, Nov 13, 2014 at 10:29 AM, Xinhuan Zheng <xzh...@christianbook.com> wrote:
> We don’t have any front end proxy. I think I see the problem... ;) If you use a front-end proxy so that your mod_perl servers are only handling mod_perl requests, and tune your configuration so that idle mod_perl servers don't sit around for long, that should avoid timeouts. Apache::DBI should also re-connect with no problems if a request comes in after a connection has timed out. If that isn't happening, make sure you are using Apache::DBI properly. Seriously, using a front-end proxy usually reduces the number of databases connections about 10 times. It's the easiest fix here by far. - Perrin