I have a spring boot application with an embedded tomcat server. The max-threads setting of tomcat is currently set to 250. Next to that the spring boot application also uses a MySql database as the datasource. For managing DB connections its using the Hikari connection pool that is set to a maximum of 10 database connections.
The maximum amount of concurrent request threads and the maximum amount of concurrent database connections differ a lot. My question is: Should I lower the max-threads setting to 10 so that each request will always have a database connection available?
I would also like to know what happens when all 10 request threads are taken and an 11th request comes in, will that request get bounced? If that is the case then maybe i should keep the max-threads setting a bit higher then 10.
Thanks
