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.

Filter by
Sorted by
Tagged with
0
votes
1answer
33 views

How many operations SQL Server support per connection

I am making a multi threaded application in which I will use a single SQL Server connection and perform select, insert, update and delete. So once my application starts, it will open connection ...
0
votes
0answers
11 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
14 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) ...
-3
votes
1answer
34 views

What is a connection pool?

Please explain me what is connection pool in Postgres and MongoDB database.
1
vote
1answer
70 views

How many pool connection size should be set for a 1000 users Jira system?

For a Jira system, if use Jira's default connection configuration as below: <?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <...
0
votes
0answers
45 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 ...
1
vote
2answers
140 views

SSMS How do I open a new Query Window using Same Connection Instance of current Window

Coming from Oracle I have discovered that SSMS connects slightly different than Oracle's SQL Developer. Oracle you click ONE connection and then all tabs you open then use that Connection. SSMS ...
0
votes
0answers
174 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 ...
1
vote
1answer
215 views

Is it possible to configure pgbouncer to distribute queries among master and slave?

We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master. Now our application (c# webapi) connects to master only directly. We want to execute ...
3
votes
2answers
448 views

Sql server sleeping state is increasing using ADO.NET?

We have one live ASP.Net application which is used by around 1000 concurrent users. In this application we have used connection pooling. There are 2 connection string defined in web.config with ...
2
votes
2answers
116 views

Connection pooling - NodeJS or Database products?

Consider the mysql package. The description covers connection pooling thus, Rather than creating and managing connections one-by-one, this module also provides built-in connection pooling using ...
-1
votes
2answers
125 views

Is there something similar to PgPool-II for oracle

I am running apps in kubernetes, which for even one app, it may have multiple containers; thus, the jdbc pool won't work. Is there a layer similar to PgPool-II for oracle database? Thanks in advance
0
votes
2answers
8k 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
59 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
253 views

MySQL stalls and strange threads/connections behavior is observed

We have a MySQL instance which most of the time works just fine. From time to time, however, we observe strange behavior. What happens is that suddenly MySQL connections reach the limit (currently set ...
1
vote
1answer
535 views

Debug Connection Pool Error

I have been getting the below error. System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.InvalidOperationException: Timeout expired. The timeout ...
1
vote
1answer
525 views

Mysql connection pool set timezone

Service application is nodejs It is using mysql connection pool. Currently, we will plan to sell service to another country What is the best way to set timezone? timezone setting execute, and query ...
0
votes
1answer
93 views

how to find a connection string value for a session in sql server?

I know there was a similar question before at SO as shown here However, that answer really does not address my question. So here is my scenario, and I will demo it with PowerShell. The following code ...
2
votes
1answer
1k views

Connection pool Error

I am getting the below error from my .net application. Source: xxx.Services.xxx.xxx.xxxx.xxxx.xxxxRequest --- System.Data.Entity.Core.EntityException: The underlying provider failed on Open. -...
0
votes
1answer
1k views

How does Pymongo connection work?

I created a small speed test from misc.Database import Database import time db = Database.getDb() def main(): test_db = db.test_db.find({}) return "done" if __name__ == '__main__': ...
3
votes
1answer
268 views

Does missing logout event in SQL Server trace mean connection leak?

(originally asked this question on StackOverflow was told that this community is a right one). I am investigating possibility of unreleased SQL Server database connections. I ran SQL Server Profiler ...
0
votes
2answers
109 views

WARN max_connections from pt-variable-advisor - what to configure for DBaaS?

Our VM configuration (hosted on Vmware) # cat /proc/cpuinfo |grep "cpu cores" | awk -F: '{ num+=$2 } END{ print "cpu cores", num }' cpu cores 32 # free -h total used free ...
1
vote
0answers
61 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
4k 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....
3
votes
1answer
207 views

Error creating connection pool for dbid:

We have an application that uses TomCat and Java to receive files and move them to a SQL Server 2012 instance. Previous versions of this software worked just fine. The new release fails on our ...
0
votes
1answer
3k views

Python Postgres psycopg2 ThreadedConnectionPool exhausted

I have looked into several 'too many clients' related topic here but still can't solve my problem, so I have to ask this again, for me specific case. Basically, I set up my local Postgres server and ...
1
vote
0answers
570 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, ...
0
votes
1answer
951 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 ...
5
votes
3answers
9k views

Downside of large “max connections” in a connection pool from a web app [closed]

I understand that if you don't pool database connections at all, then you bear the overhead of establishing a new database connection every time you need to query the database, which will make your ...
1
vote
1answer
512 views

Periodic connection failure on SQL Server 2012 AlwaysOn cluster

Since last wednesday (so a we're dealing with this for a week now) we're getting periodic connection problems on our production database cluster. (An alwayson cluster running on windows 2012, three ...
1
vote
1answer
385 views

Grouping SQL Server Connections By Connection Pool

In SQL Server 2014 is there a way to group connections by the connection pool that belong to? We are trying to find out if a specific application is leaking connections and hitting the default max ...
2
votes
1answer
1k views

What is the sense to use server_lifetime with PgBouncer?

I've found server_lifetime option in PgBouncer config, and I'm trying to undestand if it is really needed in our case. https://pgbouncer.github.io/config.html The pooler will try to close server ...
9
votes
1answer
6k views

Choice of connection pooling library for VM deploys

HickariCP docs say: HikariCP relies heavily on accurate high-resolution timers for both performance and reliability. It is imperative that your server is synchronized with a time-source such as ...
3
votes
1answer
2k views

Connection Timeouts and Failed Database Connections on AWS RDS

Environment details - Amazon RDS running PostgreSQL 9.3.14, db.r3.xlarge, IOPS 2000, 500 GB Issue - Numerous java.sql.SQLTimeoutException: Timeout after 30000ms of waiting for a connection and java....
3
votes
1answer
325 views

Confused about maximum connections in PostgreSQL

I am building a web application and I using PostgreSQL as the database management system. The following page details the maximum connections setting: https://www.postgresql.org/docs/9.5/static/...
5
votes
3answers
7k views

How to handle MySQL database connections/pooling from Lambda -> RDS with Node

I'm running into some problems while testing my Lambda function. I my test, I execute in parallel N executions of my Lambda function. In my lambda function, I retrieve a database connection through ...
1
vote
2answers
276 views

How to Deal with Performace counters

Recently we got this alert from monitoring team. SQLServer:General Statistics Logins/sec has exceeded the threshold of 2 I tried to know a bit about it and if the value is less than 2 per ...
0
votes
1answer
239 views

Is there a way to prevent “reset role” in PostgreSQL

Is there a way to prevent a user from running "reset role" in PostgreSQL, and thus gaining permission he may not have ? I have an architecture with many databases on a single server. An API connects ...
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
2answers
381 views

PgBouncer on separate server than PostgreSQL

Right now I am hosting PostgreSQLand PgBouncer on the same Linode with 48GB of RAM and 12 Cores. The server gets many short lived connections per second. The server load will increase with time and I ...
0
votes
1answer
834 views

Pooler (pgbouncer) + MasterDB + Slaves

During a spike, my connections go from 30 to over 140, as you can see below: I'm willing to set-up a pooler like pgbouncer, but have some questions as my scenario is not that easy: 1 Load Balancer ...
2
votes
1answer
549 views

MongoDB Connection Issues

We have a MEAN application with a 3-member MongoDB replica set. Somehow the total connection count keeps increasing until the primary is not able to take any new connections and goes down, making the ...
2
votes
1answer
968 views

Hundreds of TCP connections opened by sqlservr.exe

We have Tomcat on one machine and SQL Server on another. Our SQL Server machine is Windows 2008 R2 64bit machine with 32GB usable RAM 4 processors, 16 cpus. We use database pooling to keep db ...
6
votes
1answer
1k views

SQL Connection Pooling

I have a .net website connecting to SQL. Just wondering if connection pooling is enabled by default or is it something I have to activate myself?
3
votes
2answers
110 views

Edit Application Name to Log Connection once for Logons on Pooled Connections

I am wondering if I can change the application name of a connection in SQL Server itself, e.g. in the logon trigger? Is that possible or is the application name "read only"? Edit to explain the ...
9
votes
2answers
2k views

Postgres with pgpool architecture

Below is an example pgpool architecture: This implies that you only need to have pgpool on a single server; is this true? When I look at the configuration I also see that you configure backends ...
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 ...
4
votes
1answer
626 views

Are database connections from an application expensive from a performance point of view?

A colleague tells me that connections to a database are expensive and could harm performance of the application. They ask me to create a procedure that calls say another 8 procedures, that way they ...
1
vote
1answer
8k views

Tomcat7 JDBC connection pool -> Connection has been abandoned

I have the following configuration for the JDBC connection pool initialSize="2" minIdle="10" maxIdle="50" maxActive="100" maxWait="15000" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor....
2
votes
0answers
206 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 ...