Database connections

We can alter the maximum connections an Artifactory node can open to the DB by modifying the Artifactory System YAML.

Default values:

artifactory:
  database:
    maxOpenConnections: 100
...    
access:
  database:
    maxOpenConnections: 100
...
metadata:
  database:
    maxOpenConnections: 100

Tuning example:

artifactory:
  database:
    maxOpenConnections: 300
...    
access:
  database:
    maxOpenConnections: 300
...
metadata:
  database:
    maxOpenConnections: 300

Important: The Artifactory maxOpenConnections parameter is being used also by the Artifactory Session Management mechanism.
This means once the above example is used, the Artifactory node will open up to 1200 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) * ((artifactory.database.maxOpenConnections * 2) + access.database.maxOpenConnections + metadata.database.maxOpenConnections) + 50;

*The extra 50 connections are to provide extra breathing room in situations where all DB connection pools are exhausted.