[Building Sakai] Does minIdle at javax.sql.BaseDataSource stil work?

[Kenwrick Chan]

Thanks Stephen,
Then I guess the behavior is different than 2.5.x.  With 2.5.x,

minIdle at javax.sql.BaseDataSource=0
maxIdle at javax.sql.BaseDataSource=225
initialSize at javax.sql.BaseDataSource=225
maxActive at javax.sql.BaseDataSource=225

resulted in 225 connections, pretty much consistently.

-kenwrick




On Sun, Jan 2, 2011 at 10:03 PM, Stephen Marquard <
stephen.marquard at uct.ac.za> wrote:

> Hi Kenwrick,
>
> As you've set minIdle to 0, it is working as configured. If you want a
> higher number of connections at all times, then increase minIdle.
>
> But as there's a memory cost for each additional connection in mysql,
> it seems better to let them die off than keep unused connections around.
>
>
> Regards
> Stephen
>
>
> --
> Stephen Marquard, Learning Technologies Co-ordinator
> Centre for Educational Technology, University of Cape Town
> http://www.cet.uct.ac.za
> Email / IM (Jabber/XMPP): stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>
>
> >>> Kenwrick Chan <kchan at hawaii.edu> 1/3/2011 1:40 AM >>>
> Folks,
> We've just upgraded from sakai 2.5.x to sakai 2.7.1.  With 2.5.x if
> you
> wanted to have 225 database connection you'd put the following in
> sakai.properties.
>
> minIdle at javax.sql.BaseDataSource=0
> maxIdle at javax.sql.BaseDataSource=225
> initialSize at javax.sql.BaseDataSource=225
> maxActive at javax.sql.BaseDataSource=225
>
> This same settings doesn't appear to work with 2.7.1.  It starts out
> fine,
> but over time drops down significantly [which is very obvious now
> during the
> holiday break].  This is with mysq
>
>
>
>
>
> ###
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
> +27 21 650 9111. This e-mail is intended only for the person(s) to whom
> it is addressed. If the e-mail has reached you in error, please notify
> the author. If you are not the intended recipient of the e-mail you may
> not use, disclose, copy, redirect or print the content. If this e-mail
> is not related to the business of UCT it is sent by the sender in the
> sender's individual capacity.
>
> ###
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110102/9e2bb362/attachment.html