On 12 May 2016 12:16 am, "Niranjan Babu Bommu" <niranjan.bo...@gmail.com> wrote: > > I tried the same config on test stacks. numidle always "10" why it is > behaving differently in prod? > Are you sure your testing db config is identical to the prod one?
> <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*