Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Test Performance with custom connection properties

Italo Qualisoni [e-Core]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 21, 2020

Hi Community,

I would like to test the positive impact of applying this kb in a data-center environment

https://confluence.atlassian.com/jirakb/using-the-default-oracle-jdbc-fetch-size-may-lead-to-performance-issues-in-jira-1014278793.html

I'm planing to use this test benchmark but I did not find a way to pass the connection property in the JDBC URL in a Oracle database.

I can successfully run below command but I would like to include the connection property defaultRowPrefetch=200 to check if will it improve the database connection.

java -cp ./atlassian-log-analysis-0.1.1.jar:/opt/jira/atlassian-jira-software-7.13.5-standalone/lib/ojdbc8.jar \ 
com.atlassian.util.benchmark.JIRASQLPerformance \
username password 'jdbc:oracle:thin:@//databaseaddress:1521/jiradb' \
oracle.jdbc.OracleDriver \
> current.txt

Thanks in advance

1 answer

1 accepted

1 vote
Answer accepted
Gonchik Tsymzhitov
Community Champion
January 3, 2021

Hi! 

Let's provide a PR to extend the functionality

https://github.com/AUGSpb/atlassian-support-benchmark

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira service management, jsm webinar, ai in jsm, opsgenie integration, incident management, virtual agent, atlassian intelligence, ai-powered service desk, it operations, atlassian learning, service management webinar, team '25 recap

What’s new in Jira Service Management 🤔

Discover how Atlassian is revolutionizing service management with cutting-edge solutions for AI-powered support, HR Service Management, or DevOps connectivity.

Register here ⬇️
AUG Leaders

Atlassian Community Events