IntermediateScenario
10 min
Database Connection Exhaustion
DatabasesConnection PoolingTroubleshooting
Advertisement
Interview Question
Your application logs show frequent database connection pool exhaustion errors. How do you investigate and fix this?
Key Points to Cover
- Check DB pool settings vs workload
- Inspect for unclosed connections or long-running queries
- Increase pool size or optimize queries as needed
- Add caching or read replicas to reduce load
- Configure timeouts and retries properly
Evaluation Rubric
Analyzes connection pool usage30% weight
Identifies query/connection issues30% weight
Proposes tuning or scaling fixes20% weight
Mentions caching/replica strategies20% weight
Hints
- 💡Check ORM connection leak issues.
Potential Follow-up Questions
- ❓How would you tune pool sizes?
- ❓What about retry storms?
Advertisement