Re: Question on load balanced pool

Hi Jonathan,

Jonathan Reichhold wrote, On 4/25/2010 9:37 PM:
> Has there been any consideration to a
> LeastExecutingStatementsBalanceStrategy connection selection for the load
> balancer pool in addition to the random and the bestResponseTime.  In my
> situation we have lots of requests which have a large variance in timing,
> and bestResponseTime isn't great for this, while random isn't great either.
>  Noticed with the JMX instrumentation have a way to get the number of active
> requests per db and wondering if this has been considered as a strategy.

It hasn't been considered from my end, yet.  The load-balancing 
instrumentation adds visibility to number of active physical connections 
(which may be idle while still actively connected), as opposed to 
"actively being used".  We can give the latter some thought, but the 
concern I have is that collecting statistics across multiple Connection 
objects in real-time (or close enough to be useful for this purpose) 
will cause contention.


Best regards,

-- 
Todd Farmer
MySQL Support Manager, Americas
MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]