AnsweredAssumed Answered

How to tune to improve gateway database connections?

Question asked by jcrivkin on May 4, 2017
Latest reply on Aug 30, 2017 by Stephen_Hughes

We are running performance tests with approximately 450,000 requests spread evenly over an hour.  We have one appliance that uses the MySQL database.  We monitor with App Dynamics.  Requests and responses are very small.  The request is just a URL with no body; the response is less than 1K.  In our test, we see many slow transactions - about 4,000 have response times > 1500ms.  The back end has an average response time of < 10ms.  App Dynamics reports that the gateway is having difficulty getting a pooled connection from a datasource (SSG-MySQL DB-LOCALHOST-5.5.48).

 

Are we attempting an unreasonable load for a single server?  Is there a way to tune to improve DB connectivity.  I'm not sure if these are the appropriate cluster properties, but jdbcConnection.pooling.maxPoolSize.defaultValue = 50 and jdbcConnection.pooling.minPoolSize.defaultValue = 30. 

 

Thanks.

Outcomes