Database tuning for Jira

 To tune the database of JIRA, please make changes in the following parameters :

1. Change/Add the values for following tags in dbconfig.xml file of JIRA :
   • <pool-min-size>
   • <pool-max-size>
   • <pool-max-wait>
   • <pool-initial-size>
   • <pool-max-idle>
2. Set max_connection parameter in respective database.

Note: Value for max connection will be based on the number of JIRA users.

After making these changes, restart database service and JIRA service.

Refer the section Connection pool setting for tuning database connections.