if your JIRA installation is running slowly, and you suspect the culprit is database access speed (or you want to rule it out), you can test your database access speed.
You will need JDK 1.5 or later.
This is a file with a .jar extension. Sometimes IE renames these to .zip. If this is the case, rename the file to .jar; do not unzip the file.
- Open a terminal window (in Windows, go to
Start >> Run >> type in 'cmd')
Note that the use of "\" at the end of the line is the way you can break up a long command line across lines.
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.
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.
Here is a sample to run the tool using an MySQL database: