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.