dev-resources.site

for different kinds of informations.

DB POOL

Published at

10/9/2023

Categories

db

go

postgres

Author

pujith786

Main Article

https://dev.to/pujith786/db-pool-3e1j

Categories

3 categories in total

Author

9 person written this

DB POOL

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?

db Article's

30 articles in total

🛠️ DB Migration For Golang Services, Why it matters? 🐹

MongoDb Atlas: manual backup and restore data

Import the database from the Heroku dump

Why MongoDB? Exploring the Benefits and Use Cases of a Leading NoSQL Database

Database Pool Management with Sidekiq and load_async

HyperGraphs In Relation Model

Use EXISTS instead of COUNT > 0 when checking if records exist

Converting MongoDB ObjectId to Timestamp in Snowflake: A Friendly Guide

Level UP your RDBMS Productivity in GO

Iniciar sesion en mongodb con usuario y contraseña | Mongodb

currently reading

Exploring String Field Types in Databases: CHAR, VARCHAR, and TEXT

How to connect to MySQL DB

How to provision an AWS RDS MySQL Database

Amazon RDS for MySQL

Understanding the Differences Between SQL and NoSQL Databases

Advantages of Relational DB, Graph DB, and RGDB

Understanding Foreign Keys in PostgreSQL

What's behind scenes of PostgreSQL from Apache AGE?

Spring Boot 3 with H2 database example

Basic MongoDB Commands

Guide to Apache AGE 1.3.0 Release for PostgreSQL 13

Laravel useful DB/Eloquent functions:

Docker/DB - Isn't it better to set share directory between host and db container?

Alojar Wordpress en la nube (Google Cloud)

IceFireDB：A database that supports IPFS storage and Redis protocol, interesting direction.

MongoDB Complete Backup And Restore Command With Atlas

Featured ones:

abubakersiddique761