Hi team need help with DB Pool,
consider the following Scenario
DB pool settings are:
dbConn.SetMaxIdleConns(80)
dbConn.SetMaxOpenConns(250)
dbConn.SetConnMaxLifetime(5 * time.Minute)
sql.DBStats{MaxOpenConnections:250, OpenConnections:250, InUse:250, Idle:0, WaitCount:399, WaitDuration:4442935235, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:69}
MY DB pool size is not coming down.Post this we have increased the size to 2000 and we are restarting our service once in a day.
DB Stat : sql.DBStats{MaxOpenConnections:2000, OpenConnections:154, InUse:151, Idle:3, WaitCount:0, WaitDuration:0, MaxIdleClosed:0, MaxIdleTimeClosed:0, MaxLifetimeClosed:258}
How can we resolve this?
Top comments (0)