[CONJS-70] Pool improvement Created: 2019-04-30  Updated: 2019-05-06  Resolved: 2019-05-06

Status: Closed
Project: MariaDB Connector/node.js
Component/s: pool
Affects Version/s: None
Fix Version/s: 2.0.4

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

Pool improvement :

New Options

`idleTimeout` Indicate idle time after which a pool connection is released. Value must be lower than @@wait_timeout. In seconds (0 means never release) integer 1800
`minimumIdle` Permit to set a minimum number of connection in the pool. integer set to connectionLimit value

2 goals :

  • permit not having fixed pool size
  • For pools that does have a period of inactivity, permit to release connection before server close the connection due to inactivity.

Handling connection error

In case of failover, pool must wait for some small time before the next connection creation.
Current implementation loops, resulting in using much CPU for no reason.

Initial pooling activation errors must clearly be logged.


Generated at Thu Feb 08 03:22:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.