Details
-
Suggestion
-
Resolution: Fixed
-
None
Description
NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.
The pool-test-on-borrow parameter should be set to false by default on the JIRA Configuration Tool and on the JIRA Setup Wizard.
As highlighted on JRA-38750, the default value for this parameter on Apache DBCP is true.
Impact:
Every time a DB connection is borrowed from the pool the validation query will be executed, unless this parameter is explicitly set to false.
For customers running large instances this might impact their database performance as they might have hundreds of requests to the pool per second, and the validation query will be executed before every one of them.
- <pool-test-on-borrow>false</pool-test-on-borrow>
Attachments
Issue Links
- is related to
-
JRASERVER-30909 Please enable the validationQuery by default
- Closed
- relates to
-
JRACLOUD-38751 The DBCP pool-test-on-borrow parameter should explicitly be set to false on the dbconfig.xml file
- Closed
-
JRASERVER-38750 Review all DB configuration documents regarding the Test On Borrow parameter
- Closed
- was cloned as
-
JDEV-31321 Loading...