0005641: Increase default db.pool.max.active connections to match what is needed for http.concurrent.workers.max - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0005641	SymmetricDS	Improvement	public	2022-12-23 14:28	2023-10-03 23:00

Reporter	pmarzullo	Assigned To	pmarzullo
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.15.0
Target Version	3.15.0	Fixed in Version	3.15.0

Summary	0005641: Increase default db.pool.max.active connections to match what is needed for http.concurrent.workers.max
Description	The accepted engineered values for http.concurrent.workers.max value and the db.pool.max.active value is: db.pool.max.active = (http.concurrent.workers.max * 2) + 10 This is to handle a push and pool per concurrent worker (http.concurrent.workers.max * 2) plus 10 extraneous database connections to handle routing, extract, and other things. Since http.concurrent.workers.max value is defaulted to 20, the db.pool.max.active value should be increased to 50.
Tags	configuration

SymmetricDS: 3.15 f4da6223 2022-12-23 14:29:47 pmarzullo Details Diff	0005641: Increase default db.pool.max.active connections to match what is needed for http.concurrent.workers.max		Affected Issues 0005641
	mod - symmetric-core/src/main/resources/symmetric-default.properties		Diff File

Date Modified	Username	Field	Change
2022-12-23 14:28	pmarzullo	New Issue
2022-12-23 14:28	pmarzullo	Status	new => assigned
2022-12-23 14:28	pmarzullo	Assigned To	=> pmarzullo
2022-12-23 14:28	pmarzullo	Tag Attached: configuration
2022-12-27 17:28	pmarzullo	Status	assigned => resolved
2022-12-27 17:28	pmarzullo	Resolution	open => fixed
2022-12-27 17:28	pmarzullo	Fixed in Version	=> 3.15.0
2023-10-01 23:46	admin	Status	resolved => closed
2023-10-03 23:00	pmarzullo	Changeset attached	=> SymmetricDS 3.15 f4da6223