You can use the Database Server Configuration page to manage the
data source connection pool settings.
About this task
A database connection pool is a cache of connections to the database that can be modified to
improve performance. You can use this task to configure the settings for the connections.
Procedure
- Go to the top level of the Appliance Dashboard click
Configure.
- Under Manage External Entities, click Database Server
Configuration.
- Select Identity data store and click either
Configure or Reconfigure.
- Click the Connection Pool tab in the Edit Identity data store
details window.
- Specify the values that you want 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:
- Specifies the maximum number of physical connections that you can create in this pool.
- Minimum connection:
- Specifies the minimum number of physical connections to maintain. The default is 5
connections.
Attention: You must set this value to 0 for PostgreSQL.
- 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.
- Click Save Configuration.