تحديد حجم المجمّع

في هذا الدرس

size a pool from capacity, not by guesswork.

الموضوعات المخطط لها

• Start with the database: total connections across all app instances must stay under what the server can serve (cores and disks, and max_connections).
• A common starting rule: connections ≈ (core_count × 2) + effective_spindle_count; treat it as a start, then measure.
• Little's law: concurrent connections needed ≈ requests per second × average time a connection is held.
• Multiply the pool by the number of app instances; autoscaling can overload the database.
• Shorter transactions need fewer connections; fix slow queries before enlarging the pool.