Manage database connection pool settings

We can use the Database Server Configuration page to manage the data source connection pool settings.

A database connection pool is a cache of connections to the database that can be modified to improve performance. We can use this task to configure the settings for the connections..

1. Go to the top level of the Appliance Dashboard click Configure > Database Server Configuration.

2. Select Identity data store and click either Configure or Reconfigure.

3. Click the Connection Pool tab in the Edit Identity data store details window.

4. Specify the values to set for the connections.

   Connection timeout:

   Specifies the interval, in seconds, after which a connection request times out and a ConnectionWaitTimeoutException is thrown.

   Maximum connections:

   Maximum number of physical connections that we can create in this pool.

   Minimum connection:

   Minimum number of physical connections to maintain.

   Reap time:

   Specifies the interval, in seconds, between runs of the pool maintenance thread.

   Unused timeout:

   Specifies the interval, in seconds, after which an unused or idle connection is discarded.

   Aged timeout:

   Specifies the interval in seconds before a physical connection is discarded.

5. Click Save Configuration.

Parent topic: Manage the database server configuration