1. If my tomcat is configured to accept 100 incoming requests concurrently, how many connections should be present in DB connection pool ? In other words, if there a known optimal ratio of number of connections / number of incoming requests ?

  2. Is it possible that application servers have made more requests / transactions per second than the db is configured to handle ? If yes, then what happens ? Are transactions queued ? dropped ?

  • 1
    During my work with some developers they always configure database connection nearly 33% of tomcat max connection. if the application server made request more than DB can handle it will make DB very slow, then the application server will have performance issue due queue – Ahmad Abuhasna Dec 16 '15 at 8:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.