II.
Workflow overview
Reference · liveworkflow:database-connection-pool-tuning
Database Connection Pool Tuning overview
Analyzes and optimizes database connection pool configurations -- profiling connection checkout latency, identifying pool exhaustion events, measuring connection idle timeout effectiveness, evaluating pool size against concurrent query load, analyzing connection leak patterns via stack trace attribution, testing pool warm-up strategies, validating PgBouncer/ProxySQL intermediate pooler settings, and recommending pool parameter changes with load-test validation. Excludes query optimization and schema migration.
Attributes
displayName
Database Connection Pool Tuning
workflowKind
development
triggerType
on-demand
typicalCadence
per-regression
complexity
single-team
description
Analyzes and optimizes database connection pool configurations -- profiling
connection checkout latency, identifying pool exhaustion events, measuring
connection idle timeout effectiveness, evaluating pool size against
concurrent query load, analyzing connection leak patterns via stack trace
attribution, testing pool warm-up strategies, validating
PgBouncer/ProxySQL intermediate pooler settings, and recommending pool
parameter changes with load-test validation. Excludes query optimization
and schema migration.
Outgoing edges
applies_to_domain2
- domain:databases·DomainDatabases
- domain:software-engineering·DomainSoftware Engineering
involves_role3
- role:database-administrator·RoleDatabase Administrator
- role:performance-profiler·RolePerformance Profiler
- role:backend-engineer·RoleBackend Engineer
performed_by_org_unit2
- org-unit:database-team·OrgUnitDatabase Team
- org-unit:engineering·OrgUnitEngineering
requires_skill_area2
- skill-area:postgres-tuning·SkillAreaPostgres Performance Tuning
- skill-area:observability-pipeline·SkillAreaObservability Pipeline
triggers_responsibility2
- responsibility:performance-budget-tracking·ResponsibilityPerformance budget tracking
- responsibility:slo-definition·ResponsibilitySLO definition
Incoming edges
None.