db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Will Glass-Husain <wglasshus...@gmail.com>
Subject Re: blocking in connection pool
Date Wed, 14 Apr 2010 00:37:11 GMT
So, I upgraded to DBCP 1.3 and Commons Pool 1.5  (essentially the latest)
and there was  an enormous performance increase.  (with a decreased number
of required connections).

I'm thinking there were some thread contention issues in DBCP/Pool that got
resolved.  I looked through a bug list, which mentions a number of
synchronization related items but couldn't find anything specific that was
related.

I'll also look into the abandoned pool issue. I saw a note about that in the
DBCP docs

Thanks, WILL


On Tue, Apr 13, 2010 at 12:39 PM, Thomas Vandahl <tv@apache.org> wrote:

> On 12.04.10 23:56, Will Glass-Husain wrote:
> > I can see that the DBCP connection pool is blocking.  With 150 users I
> have
> > dozens of threads blocked as follows:
> [...]
> > Any suggestions?
>
> DBCP supports the abandoned-pool feature which can be configured to
> remove objects not returned to the pool after a certain amount of time.
> See if that helps. If it does, I'd do a thorough search for free-
> floating connections in your code (no finally clause).
>
> BTW, with 150 users in a normal usage pattern I'd expect the connection
> usage to be around 20 maximum. What do your users do?
>
> Bye, Thomas.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message