Skip to content

MariaDB connector/node.js 2.0.4

Compare
Choose a tag to compare
@rusher rusher released this 07 May 11:33
· 883 commits to master since this release

This version is a Stable (GA) release.

Changelog

  • [CONJS-69] permit set numeric parameter bigger than javascript 2^53-1 limitation
  • [CONJS-68] error when reading datetime data and timezone option is set
  • [CONJS-58] parse Query when receiving LOAD LOCAL INFILE, to prevent man in the middle attack
  • [CONJS-62] support named timezones and daylight savings time
  • [CONJS-63] add type definitions for typescript
  • [CONJS-64] handle Error packet during resultset to permit query timeout with SET STATEMENT max_statement_time= FOR
  • [CONJS-66] SET datatype handling (returning array)
  • [CONJS-67] Changing user does not takes in account connector internal state (transaction status)

Pool improvement

New Options

option description type default
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 pool. Recommendation is to use fixed pool, so not setting this value. integer set to connectionLimit value

This permits to set a minimum pool size, meaning that after a period of inactivity, pool will decrease inner number of connection to a minimum number of connection (defined with minimumIdle).
By default, connections not used after idleTimeout (default to 30 minutes) will be discarded, avoiding reaching server @@wait_timeout.

Pool handle connection creation automatically, with now some delayed after failing to establish a connection, to avoid using CPU unnecessary.
Authentication error in pool have now a better handling.