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 < niranjan.bo...@gmail.com> 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 <ma...@apache.org> 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: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> > > > -- > *Thanks* > *Niranjan* > *+1 781.956.6900 <%2B1%20781.956.6900>* > -- *Thanks* *Niranjan* *+1 781.956.6900*