JIRA profiling

[Petr Lazovic]

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()

[4ms] - PermissionManager.hasPermission()

[5ms] - PermissionManager.hasPermission()

[5ms] - PermissionManager.hasPermission()

[0ms] - PermissionManager.hasPermission()

[176ms] - SimpleWorkflowAction.execute()

[3ms] - PermissionManager.hasPermission()

[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()

[3ms] - PermissionManager.hasPermission()

[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()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[0ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[2ms] - PermissionManager.hasPermission()

[3ms] - PermissionManager.hasPermission()

[3ms] - 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()

[1ms] - PermissionManager.hasPermission()

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

[557ms] - IssueTableHtml

Thank you.

[Norman Abramovitz]

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]

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]

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.