RE: blocking in connection pool

2010-04-13 Thread Thomas Fischer
Hi Will, Anyone out there with Torque use in a high volume load situation? I'm having trouble with a bottleneck in DBCP with Torque. I set my DBCP connection pool limit to 300 (in the Torque config file) and my mysql max_connections to 300, but the max_used_connections variable in MySQL

Re: blocking in connection pool

2010-04-13 Thread Thomas Vandahl
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

Re: blocking in connection pool

2010-04-13 Thread Will Glass-Husain
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