JIRA 4.0 : Testing Database Access Speed
This page last changed on Jun 18, 2009 by ecausarano.
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
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&useUnicode=true&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). 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. See Also |
![]() |
Document generated by Confluence on Oct 06, 2009 00:26 |