I tried the same config on test stacks. numidle always "10" why it is
behaving differently in prod?
<Resource name="jdbc/DS"
auth="Container"
type="javax.sql.DataSource"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
fairQueue="false"
validationQuery="SELECT 1"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
maxActive="100"
maxIdle="10"
minIdle="10"
maxWait="10000"
initialSize="10"
removeAbandonedTimeout="60"
removeAbandoned="true"
logAbandoned="true"
minEvictableIdleTimeMillis="300000"
jmxEnabled="true"
jdbcInterceptors="ConnectionState;StatementFinalizer;ResetAbandonedTimer"
username="<user>"
password="<password>"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://<DBservername>/<schema>?useServerPrepStmts=false&useOldAliasMetadataBehavior=true"/>
On Wed, May 11, 2016 at 7:35 AM, Niranjan Babu Bommu <
[email protected]> wrote:
> Hi Mark
> I have included defined data source in this mail, do you want me to
> include complete server.xml?
>
> thanks
> Niranjan
>
> On Wed, May 11, 2016 at 7:19 AM, Mark Thomas <[email protected]> wrote:
>
>> On 11/05/2016 11:58, Niranjan Babu Bommu wrote:
>> > Hi,
>> >
>> > we are migrating prod servers to tomcat, since we are doing it slowly we
>> > have found an issue in jdbc connection pool, tomcat is not releasing
>> idle
>> > jdbc connections, even we have tried setting maxIdle="10" but "NumIdle
>> 97"
>> > always. due to this threads are piling up in database.
>> >
>> > I'm including my config here, can someone please help me out, how to
>> > minimize idle jdbc connections.
>>
>> Where have you added the configuration below?
>>
>> Mark
>>
>>
>> >
>> > <Resource name="jdbc/DS"
>> > auth="Container"
>> > type="javax.sql.DataSource"
>> > testWhileIdle="true"
>> > testOnBorrow="true"
>> > testOnReturn="false"
>> > fairQueue="false"
>> > validationQuery="SELECT 1"
>> > validationInterval="30000"
>> > timeBetweenEvictionRunsMillis="30000"
>> > maxActive="100"
>> > maxIdle="10"
>> > minIdle="10"
>> > maxWait="10000"
>> > initialSize="10"
>> > removeAbandonedTimeout="60"
>> > removeAbandoned="true"
>> > logAbandoned="true"
>> > minEvictableIdleTimeMillis="300000"
>> > jmxEnabled="true"
>> >
>> >
>> jdbcInterceptors="ConnectionState;StatementFinalizer;ResetAbandonedTimer"
>> > username="<user>"
>> > password="<password>"
>> > driverClassName="com.mysql.jdbc.Driver"
>> >
>> >
>> url="jdbc:mysql://<DBservername>/<schema>?useServerPrepStmts=false&useOldAliasMetadataBehavior=true"/>
>> >
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
> --
> *Thanks*
> *Niranjan*
> *+1 781.956.6900 <%2B1%20781.956.6900>*
>
--
*Thanks*
*Niranjan*
*+1 781.956.6900*
