diff options
| author | Chris Lu <chrislusf@users.noreply.github.com> | 2025-12-07 13:26:47 -0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-12-07 13:26:47 -0800 |
| commit | 5d53edb93b8e955905209570d1132e06c8ccd6e0 (patch) | |
| tree | b8d41802572696a2c16188d1146d79a7a3925786 /weed/command/filer.go | |
| parent | dcc200fec058e51bbb3e4fe49744637fd16d01b2 (diff) | |
| download | seaweedfs-5d53edb93b8e955905209570d1132e06c8ccd6e0.tar.xz seaweedfs-5d53edb93b8e955905209570d1132e06c8ccd6e0.zip | |
Optimize database connection pool settings for MySQL and PostgreSQL (#7645)
- Reduce connection_max_idle from 100 to 10 (PostgreSQL) and from 2 to 10 (MySQL)
- Reduce connection_max_open from 100 to 50 for all database stores
- Set connection_max_lifetime_seconds to 300 (5 minutes) to force connection recycling
This prevents 'cannot assign requested address' errors under high load by:
1. Limiting the number of concurrent connections to reduce ephemeral port usage
2. Forcing connection recycling to prevent stale connections and port exhaustion
3. Reducing idle connections to minimize resource consumption
Fixes #6887
Diffstat (limited to 'weed/command/filer.go')
0 files changed, 0 insertions, 0 deletions
