Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

http_connection_pool_timeout option

Specifies the maximum duration that an unused connection can be retained in the connection pool.

Allowed values

Integer, between 1 and 86400, inclusive

Default

60

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes, with SET ANY SYSTEM OPTION No No
Remarks

Excess connections are deleted at an increasing rate based on this value if the pool size exceeds http_connection_pool_basesize.

Changing this option takes effect within 5 seconds during the next purge cycle. Any unused database connections having exceeded http_connection_pool_timeout within the http_connection_pool_basesize threshold are deleted. When the size of a connection pool exceeds the http_connection_pool_basesize threshold, connections are deleted at a more aggressive rate.

Unused excess connections are removed within half the timeout interval, half of the remainder are purged if unused within a quarter timeout interval, and so on. The following database properties have been added to determine the operating efficiency of the connection pools within a database:

  • HttpConnPoolCachedCount
  • HttpConnPoolHits
  • HttpConnPoolMisses
  • HttpConnPoolSteals