RDS connection pool control

I connect my DB (AWS RDS) to Spring boot JPA, Then my number of connections increase dramatically. it is 12 now, i think it work spring boot 5 + browser 5, workbench 1 + and othrer? so tell me how can i reduce my number of connections? and how can i maintain this connection safely?

**Ans.**
You should be looking for Database connection pooling.

Database connection pooling is a method used to keep database connections open so they can be reused and also it will be keeping the total number of connections within a limit that we are specifying.

The default connection pool in Spring Boot is HikariCP, all you have to do is configure it properly

Sample connection pool configuration,

**&& mysql command sample**
```
SHOW FULL PROCESSLIST;

CALL mysql.rds_kill(467);
```

```
spring.datasource.hikari.connection-timeout = 20000
spring.datasource.hikari.minimum-idle= 10
spring.datasource.hikari.maximum-pool-size= 10
spring.datasource.hikari.idle-timeout=10000
spring.datasource.hikari.max-lifetime= 1000
spring.datasource.hikari.auto-commit =true
```

The issue discusses AWS RDS connections from Spring Boot JPA and shows HikariCP settings plus MySQL commands, but it names no repository file, test, or entry point. First determine whether this repository needs documentation for the connection-pooling question, then define the intended scope and acceptance criteria before making a change.

Written by the indexing model from the issue text.