How to reduce the number of database connections

SonarQube Server / Community Build
,
1

Hi,

We are currently using SonarQube Server Community Edition 10.7.0, deployed using Helm, and we are trying to reduce the number of database connections (we use RDS with Postgres) using environment variables.

We tried to change the values in the Helm charts values as following:

env:
  - name: SONAR_JDBC_MAXACTIVE
    value: "10"
  - name: SONAR_JDBC_MAXIDLE
    value: "3"

However, the number of database connections is always at 20.
Did we miss any behavior?
Is 20 the strict minimum value for SonarQube to run?
Anything else?

Thank you in advance,
Best,

Yoan

2

Hi Yoan,

Welcome to the community!

Have you also tuned SONAR_JDBC_MINIDLE? Also, the recommendation is that maxActive be 1.2 x maxThreads. There’s nothing in the docs to suggest that’s enforced, but have you tuned that as well?

Also, would you mind explaining why you want to do this?

 
Thx,
Ann