Testing Database Access Speed

We have a utility to test database access speed. Use it if your JIRA installation is running slowly, and you suspect the culprit is database access speed (or you want to rule it out).

You run it on the machine that JIRA is running on. You need to know the path to your JDBC driver jar file and to the atlassian-log-analysis-0.1.1.jar file (once you have
downloaded it).

Please note!

This tool only measures retrieval latency of key JIRA database objects. It does not simulate real life activities such as permission checking that may significantly increase processing time. Thus it is not recommended to use this tool as an overall instance performance estimator.

You will need JDK 1.5 or later.

java -cp your/path/to/atlassian-log-analysis-0.1.1.jar:/path/to/your/jdbc-driver.jar \
        com.atlassian.util.benchmark.JIRASQLPerformance \
        username \
        password \
        jdbc-url \
        driver-classname \
        > out.txt

Note that the use of "\" at the end of the line is the way you can break up a long command line across lines.

You will need to fill in the arguments above to the tool. Unfortunately we have not built a user interface for this tool. Note the > out.txt makes the output redirect to a file called out.txt - doing this helps remove the time to write to the console from the time measured to the database.

Here is the exact command line I used to run the tool using an MySQL database on my machine:

java -cp ./atlassian-log-analysis-0.1.1.jar:/home/idaniel/tools/jdbc_drivers/mysql-connector-java-3.1.12-bin.jar \    
        com.atlassian.util.benchmark.JIRASQLPerformance \
        jirauser \
        jirauser \
        'jdbc:mysql://localhost:3306/icfi?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8' \
        com.mysql.jdbc.Driver \
        > out.txt

The program executes a set of queries 1000 times and then writes a summary (at the bottom of the file).
As a means of comparison, here are the summary results for my machine against an MySQL database on my machine.

I am running a Xeon 2.80GHz with 1.5 GBytes of memory.

TOTALS
----    ----    ----    ----    ----
stat    mean    median  min max
----    ----    ----    ----    ----
retrieve-issue  5,338,000   979,000 213,000 46,007,000
get-issue   174,775 93,000  62,000  11,621,000
retrieve-workflow   5,117,153   607,000 341,000 47,738,000
get-workflow    98,996  64,000  40,000  2,962,000
retrieve-custom-field-value 601,093 495,000 316,000 23,082,000
get-custom-field-value  91,246  52,000  37,000  3,453,000
----    ----    ----    ----    ----
All times are in nanoseconds.

Child pages

参考情報