What are recommended settings for Tomcat connection maxThreads and database c3p0 max_size?

[knowshan]

I was wondering if it is recommended approach to match Tomcat maxThreads with database connections c3p0 max_size when using JDBC. Do these values need to be close to each other (match http connection limit with database connection limit)? Any insights on configuring these values will be helpful.  

[knowshan · Accepted solution]

Answering own Q: It seems like recommended settings are here - https://confluence.atlassian.com/confkb/confluence-slows-and-times-out-during-periods-of-high-load-due-to-database-connection-pool-146407630.html . 

It would have been nice if Atlassian shipped Confluence with their own recommendations - keeping http and database thread numbers close to each other.

[kgbvax]

>keeping http and database thread numbers close to each other.

This ^  is likely bad advice, evidence

https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing