Database Connection Pool Optimizer

Optimize connection pool settings for this setup:

**Application Type:** {{APPLICATION_TYPE}}
**Database System:** {{DATABASE_SYSTEM}}
**Connection Pool Library:** {{POOL_LIBRARY}}
**Server Resources:** {{SERVER_RESOURCES}}
**Concurrent Users:** {{CONCURRENT_USERS}}
**Query Characteristics:** {{QUERY_CHARACTERISTICS}}
**Current Issues:** {{CURRENT_ISSUES}}

Please provide:
1. Optimal pool size calculation with formula
2. Recommended configuration settings:
   - Minimum/maximum connections
   - Connection timeout
   - Idle timeout
   - Max lifetime
   - Validation query
3. Code implementation example
4. Monitoring metrics to track
5. Load testing recommendations
6. Troubleshooting common issues
7. Scaling considerations