Testing database access speed
JIRA applications appear to be experiencing performance issues. This will be particularly noticeable in the following areas:
Display of issue details and comments
This is a file with a .jar extension. Sometimes Internet Explorer renames these to .zip. If this happens, rename the file to .jar; do not unzip the file.
- Open a terminal window.
Run this command after replacing all the variables with the correct values for your environment from
JIRA_HOME_DIR/dbconfig.xml. The '\' and '^' in the examples are used to break the command across multiple lines.
Here is an example of running the tool with a MySQL database:
The results are placed in the file "db-perf-test.txt". You may see some errors when you run it but you can ignore those unless the output file is empty.
This is what the summary at the end of the output looks like:
We do not have clearly defined "excellent, good, bad" ranges but in a large installation we look for mean values below 20ms for all metrics and below 10ms is ideal. The faster the better.
There are many potential causes for poor database performance. First, check that your DB configuration is correct as per the JIRA documentation. To successfully address DB performance problems it is essential to consult with your database administrator.
As noted above, the tests do not attempt to fully simulate user activity. Below are relevant SQL snippets from the source code. It may also be helpful to log SQL queries from the DB side while running the utility for better insight into what it is measuring.
Other things to check
- DB latency. If no specific tool is available, use ping between the app server and the DB server and average the time of 20 pings.
- Driver version. Make sure it is the latest recommended for your DB version.
- In some environments, it may be helpful to host the DB locally. This mainly applies to installations where the underlying server has plenty of RAM, disk space, and CPU without cutting into JIRA application resources.
Was this helpful?
Thanks for your feedback!