When experiencing database connection errors under load or seeing 'connection pool exhausted' errors.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Databases & Data Engineering - Use case: Database Connection Pool Configuration - Source task: - Help me configure connection pooling for {{database_type}} accessed by a {{language}} application deployed on {{number}} instances. Calculate: - 1. optimal pool size using the formula (pool size = (core_count * 2) + effective_spindle_count) - 2. min/max pool size, idle timeout, and connection lifetime settings - 3. connection pool monitoring metrics to watch - 4. pool exhaustion detection and handling - 5. show the complete configuration in {{connection_library}} # Goal Pool size calculation, full connection pool configuration, monitoring metrics, and exhaustion handling code. # Constraints - Produce a complete, usable first draft in one response. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Pool size calculation, full connection pool configuration, monitoring metrics, and exhaustion handling code.
{{double-curly}} with your real context.When experiencing database connection errors under load or seeing 'connection pool exhausted' errors.
Too many connections is as bad as too few — each idle database connection consumes memory on the server. Size for realistic concurrency, not maximum theoretical load.
Write a complete, SEO-optimised blog post on the given topic. Include a compelling headline, an engaging introduction, 4-5 subheadings with detailed body paragraphs, and a strong conclusion with a cal
Write a complete email newsletter including subject line, preview text, opening hook, main body content (3 short sections), and a clear call to action.
Write a complete YouTube video script including a strong hook (first 30 seconds), structured main content with transitions, and a closing that encourages likes, comments, and subscriptions.
Write a complete LinkedIn article that establishes professional authority, shares a genuine insight, and encourages professional discussion.