We can alter the maximum connections Artifactory can open to the DB. This will be configured at the $ARTIFACTORY_HOME/etc/db.properties configuration file.
Default value:
pool.max.active=98
Tuning example:
pool.max.active=300
Important: The above parameters are being used by Artifactory, Access, and the Database Locking mechanism.
This means once the above example is used, Artifactory as a server will open up to 900 DB connections.
Therefore we need to make sure the DB can accommodate the total number of connections all Artifactory nodes can open.
As a rule of thumb we will require from the DB a number of connections based on:
Total # of connections = (number of nodes) * 3 * (pool.max.active) + 50;
Default value:
pool.max.active=98
Tuning example:
pool.max.active=300
Important: The above parameters are being used by Artifactory, Access, and the Database Locking mechanism.
This means once the above example is used, Artifactory as a server will open up to 900 DB connections.
Therefore we need to make sure the DB can accommodate the total number of connections all Artifactory nodes can open.
As a rule of thumb we will require from the DB a number of connections based on:
Total # of connections = (number of nodes) * 3 * (pool.max.active) + 50;