[Sqlrelay-discussion] MySQL Load Testing

[Marvin W. <MW...@la...>]

Hi David,

I'm having some issues while doing some load tests with sql relay.

I have a pool of 25 connections that may grow to 50 and I have assigned 50
cursors to the pool.

I've built a server application that uses this pool to connect to a local
cache of data.

If I execute 1 request to my server app it returns a sub second response.

Now when load testing all the way to 300 concurrent requests the app starts
returning response of upto 10 seconds.
I've done some program tracing and filled the app with plenty of logs, I
seem to get a bottle neck on the actual sendQuery.
Some of these queries are taking 9 seconds to execute.  I'm also monitoring
the database, the queries that are run are all under a second.
The slow down seems to be somewhere in the sendQuery but that's all I can
tell.

I thought at first that with only 50 max connections to the pool that the
threads might be waiting for a connection but it does seem to be the case.

If I switch access to this local cache off load-testing all the way to 500
connections my app will return all connections under 2 seconds.

I'm running the new pre-release version 3 of sql relay.

Any ideas what may be the problem or what I can try ?

Many thanks.


Marvin Wright
Flights Developer
Lastminute.com
mw...@la...
+44 (0) 207 802 4543



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************