Questions tagged [connection-pool]
108 questions
24
votes
1 answer
HikariCP Idle connections staying in connection pool as active
I am using Spring Boot (1.5.6), Hibernate, Postgres, Hikari (2.7.8) . My configuration is…
Saif
- 6,804
- 8
- 40
- 61
9
votes
2 answers
sequelize - connection pool size
now i`m reading an article on http://docs.sequelizejs.com/manual/installation/getting-started.html
and cannot understand this sentences written below.
If you're connecting to the DB from multiple processes, you'll have to
create one instance per…
jwkoo
- 2,393
- 5
- 22
- 35
7
votes
1 answer
Max connection pool size and autoscaling group
In Sequelize.js you should configure the max connection pool size (default 5). I don't know how to deal with this configuration as I work on an autoscaling platform in AWS.
The Aurora DB cluster on r3.2xlarge allows 2000 max connections per read…
NinjaFisherman
- 296
- 4
- 15
6
votes
1 answer
HikariCP prepared statement cache
I was looking into HikariCP for using it in one of my projects. The statement cache section of the project page in github says that it doesn't support prepared statement cache at the connection pool level.
But the initialization section has the…
sivaguru perumal
- 103
- 1
- 8
5
votes
1 answer
How to avoid database connection pool from being exhausted when using FastAPI in threaded mode ( with `def` instead of `async def`)
I use FastAPI for a production application that uses asyncio almost entirely except when hitting the database. The database still relies on synchronous SQLAlchemy as the async version was still in alpha (or early beta) at the time.
While our…
Sid
- 6,134
- 9
- 34
- 57
5
votes
1 answer
Spring boot connection pool understanding
In Spring boot application.properties file we have the following options:
server.tomcat.max-threads = 100
server.tomcat.max-connections = 100
spring.datasource.tomcat.max-active = 100
spring.datasource.tomcat.max-idle = 30
This is my repository…
Almas Abdrazak
- 3,209
- 5
- 36
- 80
4
votes
0 answers
HikariPool-2 - Failed to validate connection
I am new to spring boot so doesn't know much about configuration in application.properties or pom.xml . I'm trying to do a CRUD operation in MySQL DB hosted in Azure VM. Once I start my spring-boot application and perform a DB operation, it works…
Debadatta Meher
- 83
- 2
- 10
3
votes
2 answers
When does a Hikari pool connections work? - Spring/Spring Boot
I have the below doubts on the Hikari or any database pooling concept.
When does the connection pool gets created?
Suppose if I have mentioned spring.datasource.hikari.maximum-pool-size=50
Will it create 50 database instances?
As by default,…
murali
- 49
- 8
3
votes
1 answer
Connection pool in MongoDB with jongo
I would like to use connection pool for MongoDB. I have used MongoDB with Jongo and Spring MVC framework.
Here is my spring xml code for MongoDB configuration, which is working fine.
Maulik Kakadiya
- 1,467
- 1
- 21
- 31
3
votes
1 answer
How to configure DataSource for a Spring-Boot Application in a Standalone (war) and in an embedded Tomcat?
I have a Spring-Boot-Aplication with the following dependencyManagement:
org.springframework.boot
…
Meziane
- 1,586
- 1
- 12
- 22
3
votes
1 answer
Tomcat JDBC connection pool, connections are created more than maxActive
I am using tomcat 8.0.39, mysql 5.7 server and mysql connector 5.1.34
here is my context.xml config
Devan Sivaprakasam
- 41
- 1
- 3
3
votes
2 answers
How to check if the db connection is success or not in node js and mysql
I'm using mysql connection pool to create connection. The code looks like the following.
var pool = mysql.createPool(connectionProps);
by accessing pool, I'll get the an Object, even if the connection is not Successful. I checked it with starting…
Demolition
- 138
- 1
- 1
- 10
2
votes
0 answers
No connection pool for XX - ActiveRecord Error in Ruby on Rails
I created a method called connect_and_do_something like below;
What this method does is:
①to connect SampleModel with various databases passed as an argument db_name
②do something by using SampleModel
def connect_and_do_something(db_name)
config =…
f3h45gp9dnwel
- 21
- 2
2
votes
0 answers
Database Connection Pool Size
if you were hitting the ceiling on the max number of connections on your DB, what is peoples thoughts on having a smaller connection pool size than the number of threads * workers.
If you didn't want to scale up the database, is it possible that a…
l33z3r
- 617
- 5
- 16
2
votes
1 answer
How wildfly resets properties set on connection when returned to connection pool
I am doing jndi lookup for datasource configured in JBOSS
DataSource dataSource = (DataSource) new InitialContext().lookup(dataSourceStr);
return dataSource.getConnection();
Connection is closed by using try-with-resource.
Once I get connection…
Archana Mundaye
- 523
- 1
- 5
- 19