What is the impact of configuring Jira Server to have a large amount of connection pools 150+

Charlie Bolante_4b9w2e

I was wondering if there was any impact to the Jira server or the database server if we were to configured the dbconfig.xml setting to have a max-connection-pool of 150+ or more.

 

We have been having some performance issues where the connection pool is maxing out, but not as frequently to have a discernible pattern. If I were to configure the connection pool to be really high 150+ what would be the impact on the Jira server or database server.

Edwin Kyalangalilwa

Hi @Charlie Bolante,

Yes this is possible. The database would have to be configured to allow that much connections.

If there are other databases on the same server as Jira, then it's recommended that you move Jira's database to it's own server. So applications are not fighting over connections.