Questions tagged [connection-pooling]

In client applications, a connection pool is a cache of connections maintained so that the connections can be reused when future requests to the resource are required. Many DBMSes also support server-side connection-pooling allowing them to service more concurrent clients than they have server-side processes or threads servicing them.

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
44 views

Database connections and related issues?

If my tomcat is configured to accept 100 incoming requests concurrently, how many connections should be present in DB connection pool ? In other words, if there a known optimal ratio of number of ...
2
votes
0answers
217 views

Connection Pools and TempDB Internal Objects

I am thinking I know the basics of the problem here, but I want to make sure I know the details before trying to explain it to others. We recently upgraded our third party application software to a ...
1
vote
0answers
22 views

how to maximize usage of number of databases on a postgres server while limited by connections

We're building a system where ideally we'd give a database per client in a multi-tenant setup. However, although a single Postgres install supports 4,294,950,911 databases on a server, the suggested ...
1
vote
0answers
63 views

concurrent configuration PostgreSQL and tomcat

Postgresql has a default of 100 regarding max_connections. Tomcat pooling has a default of 100 regarding maxActive and maxIdle. How about configuring data sources in context.xml for Apps in Tomcat? ...
1
vote
0answers
5k views

org.postgresql.util.PSQLException: This connection has been closed. error for long running transactions

We are getting "org.postgresql.util.PSQLException: This connection has been closed." on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate....
1
vote
0answers
652 views

Keeping MySql connections alive

I'm running a Windows service, which connects to a MySql database via Entity Framework. Every 10 seconds it issues a query to the database to see if any new records have been added. If it finds any, ...
1
vote
0answers
1k views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
0
votes
0answers
12 views

ADO Command CommandTimeout isn't respected with MARS Connection=True

We're using ADO with Classic ASP/VBScript to talk to SQL Server. When setting MARS Connection=True in the SQL connection string, I'm finding that neither the CommandTimeout property of ADODB.Command ...
0
votes
0answers
50 views

Multi tenant database connection pool for multiple databases

How I can create multi tenant database connection pool for multiple databases. So basically I want to create connection pool at Instance level(don't want to create connection pool for every database) ...
0
votes
0answers
121 views

Correct MongoDb connection pool strategy

I am not using any sort of ORM just the mongo node.js driver in express. Currently I wrap every request in a promise that creates a new mongo client and closes the connection when the promise either ...
0
votes
0answers
314 views

How to create multiple pool connection using Psycopg2 in Cloud Functions (GCP)

I am creating Cloud Functions for some queries to read and write in different databases. In GCP concept, I am connected to Cloud SQL - Postgres and using Psycopg2, tested locally - python postgres ...
0
votes
2answers
11k views

What settings control the maximum number of connections per user in Oracle 12c?

We have some software that is throwing an exception "Pooled connection request timed out" I know the reason for this and i know the fix. I just need to buy some time on the production server until i ...
0
votes
0answers
82 views

MySQL pooled connections and crontab jobs (not reusing connections)

I have several cron jobs running and the task that cron has to do is execute a file that in turn checks and compares crawled data with data in the database, if it exists then the script ends and if it ...
0
votes
1answer
1k views

Load Balancing PG Bouncer With HA Proxy

I have a server with two instances of PG Bouncer running on different ports. Both are using session mode to pool. I set up HA Proxy to load balance incoming connections between these two processes to ...
0
votes
0answers
29 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...