Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
From: "Noel O'Brien" <nobrien@newbay.com>
Organization: Newbay Software
To: jmeter-user@jakarta.apache.org
Subject: Re: Replace JDBC Pool
Date: Tue, 21 Apr 2009 16:05:55 +0100
User-Agent: KMail/1.10.4 (Linux/2.6.27-11-generic; KDE/4.1.4; i686; ; )
Cc: sebb <sebbaz@gmail.com>
References: <200904211541.40692.nobrien@newbay.com>
 <25aac9fc0904210747w14885a24l552e9d9bc044da22@mail.gmail.com>
In-Reply-To: <25aac9fc0904210747w14885a24l552e9d9bc044da22@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
  boundary="Boundary-00=_UDe7J/eKPOYOy8c"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200904211605.56034.nobrien@newbay.com>

--Boundary-00=_UDe7J/eKPOYOy8c
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

On Tuesday 21 April 2009 15:47:16 sebb wrote:
> On 21/04/2009, Noel O'Brien <nobrien@newbay.com> wrote:
> > Hi All,
> >
> >  I'm seeing some issues with slow INSERT/COMMIT times (about 4sec!) to
> > MySQL from our product and would like to recreate the same setup with
> > JMeter to rule out certain components (hibernate, DBCP, etc.)
> >
> >  Our product uses DBCP for connection pooling but JMeter uses Avalon if
> > I'm not mistaken. Is it an easy task to replace Avalon with DBCP in
> > JMeter?
>
> No, but if you set the JDBC Config Max Number of Connections to 0, it
> will use a connection per thread, i.e. no pooling.

Interesting, I'll try  this to see what the effect is.

> I'd like to remove connection pooling altogether from JMeter.
> JMeter threads are supposed to be independent users, and users don't
> share DB pools.

That's a shame, as it pooling was useful in my case to simulate how our 
product works and to help point towards the DB as a bottleneck. I can see your 
point thought, from an end-user point of view there's no sharing of DB pools. 
Maybe it could be left an an option?

> >  Regards,
> >
> > Noel
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


--Boundary-00=_UDe7J/eKPOYOy8c--