What is the best configuration settings for DB connection pool for an instance with 1.3 lakh issues?

Question

Hello there, Welcome back from Holidays!! :) We are using JIRA Software Server and we have an almost 122519 issues in our instance. We are facing very frequent slowness in the issue processing and JSD queues, even DB connection pool shows high spikes graph everyday. Please help us to configure the best DB connection pool settings. nn

nn

nn Have A Nice Day! Regards, Sami Ahmed Shaik.

Sami Ahmed Shaik · Answer

Based on our current instance performance, is it OK to set the JVM as follows.

Min: 4096mb

Max: 4096mb

We normally see performance issue when there are spikes in the DB pool as follows,

How can we fix such issues? any idea @Daniel Ebers & @Gonchik Tsymzhitov

Regards,

Sami Ahmed Shaik.

Daniel Ebers · Answer

From the books JVM min memory and JVM max memory should be set to the same value.
Although it is had to tell from the outside you could assess those values further.
A heap that is too large can have negative effects of performance, so, as long as you are not facing out of memory situations I would choose a small value for JVM heap size (min and max) and increase gradually.

Like stated earlier this is a complex issue where many aspects need to be considered. That was only just one sighting.

Which garbage collector do you use?

Gonchik Tsymzhitov · Answer

Hi!

@Sami Ahmed Shaik  did you experiencing the problem?