Re: Disconnect database connection after idle timeout
Perrin Harkins <[email protected]>
| Newsgroups | gmane.comp.apache.mod-perl |
|---|---|
| Message-ID | <CAC0_be2ofBNnztnqdds4B=LEYNeDCWjB0yrU_k+Yo6UnHjqccA@mail.gmail.com> |
On Thu, Nov 13, 2014 at 10:29 AM, Xinhuan Zheng <[email protected]> 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