tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: Mysql timouts...
Date Fri, 23 Feb 2007 12:41:41 GMT
Sorry... my bad.  My math doesn't work early in the morning.   :-[

At any rate, the validation query run every minute is still acting as a
keep-alive on the connection.  It'll never go stale.  Personally I'd
drop the testWhileIdle, timeBetweenEvictionRuns, minEvictableIdleTime
and just let the pool test on borrow.  That's the default behavior as
long as a validationQuery is specified.

--David

Jacob Rhoden wrote:

> David Smith wrote:
>
>> I think I see what's happening here.  You've told the database pool to
>> continually test connections every hour.  The validation query itself
>>  
>>
>>>      validationQuery="select 1"  testWhileIdle="true"
>>>      timeBetweenEvictionRunsMillis="60000"
>>>      minEvictableIdleTimeMillis="60000"
>>>     
>>
> This is why I am confused, isnt 60000=60 seconds? It is certinaly not
> doing an idle test every 60 seconds, why does it say Millis?
>
> Best Regards,
> Jacob
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message