JIRA profiling

Question

Hi,

Can you tell how bad are the results of JIRA profiling?

JIRA: 5.0.4
Oracle Linux, VM, RAM 2Gb, Issues: 240k, projects: 4, users: 500 active (~20 concurrent a day), groups: 20, workflows: 6 active, + 15-20k issues a month

(I started here from slow-queries : https://answers.atlassian.com/questions/11969797)

[868ms] - /jira/secure/IssueNavigator!executeAdvanced.jspa

[66ms] - IssueNavigator.execute()

[18ms] - PermissionManager.getProjectObjects()

[22ms] - Lucene Search [604ms] - IssueTableHtml

another user:

[224ms] - /secure/WorkflowUIDispatcher.jspa

[34ms] - WorkflowUIDispatcher.execute()

[4ms] - PermissionManager.hasPermission()

[5ms] - PermissionManager.hasPermission()

[0ms] - PermissionManager.hasPermission()

[176ms] - SimpleWorkflowAction.execute()

[3ms] - PermissionManager.hasPermission()

[0ms] - IssueIndexManager.reIndex()

[0ms] - IssueIndexManager.reIndexIssueObjects()

[86ms] - IssueIndexManager.reIndex()

[548ms] - /browse/ABC-112835

[472ms] - QuickLinkServlet.service()

[40ms] - ViewIssue.execute()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[11ms] - Updating Pager for viewing issue:ABC-112835

[109ms] - /secure/CommentAssignIssue!default.jspa

[34ms] - CommentAssignIssue.execute()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[0ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[1ms] - PermissionManager.hasPermission()

one more:

[817ms] - /plugins/servlet/streams

[671ms] - /secure/IssueNavigator.jspa

[252ms] - IssueNavigator.execute()

[3674ms] - /browse/ABC-204911

[3621ms] - QuickLinkServlet.service()

[33ms] - ViewIssue.execute()

[3ms] - PermissionManager.hasPermission()

[0ms] - PermissionManager.hasPermission()

[1ms] - PermissionManager.hasPermission()

[0ms] - Updating Pager for viewing issue:ABC-204911

[557ms] - IssueTableHtml

Thank you.

Norman Abramovitz · Answer

https://confluence.atlassian.com/display/ENTERPRISE/JIRA+Sizing+Guide

Your memory is definitely low.

http://blogs.onresolve.com/2009/04/how-to-make-jira-6-12-times-faster/

You should create a some stress tests so you can measure your changes and try out the permission change.

Petr Lazovic · Answer

Hi, Norman

Server that hosts JIRA only: 
Intel(R) Xeon(R) CPU  X7560  @ 2.27GHz
Oracle Linux 6.2 amd64
Apache Tomcat/6.0.32
RAM 2G
JVM: -XX:MaxPermSize=256m -Xms256m -Xmx768m
JRE: 1.6.0_32

JIRA: 5.0.4
Issues: 240k, projects: 4, users: 500 active, groups: 20, workflows: 6 active, + 15-20k issues a month

Norman Abramovitz · Answer

How bad relative to what?   You do not describe the hardware or software setup?  There is no information about how your database is setup.  One data point does not make a comparison possible.    These are 'good' numbers without having any facts behind them.