問題

Slow performance is observed when user is browsing users in attempt to populate 'Request participants' field.

診断

環境

• JIRA 7.5.4 with JSD 3.8.5

• Database : mySQL 5.7.11

• 81684 users in JIRA internal directory (no external LDAP)

Diagnostic Steps

• With SQL logging enabled in JIRA, we observed a single search yields around 2968 searches against cwd_users database table, example:

  atlassian-jira.log

  2018-05-01 16:12:46,837 http-nio-8080-exec-25 admin 972x326x4 admin /rest/servicedesk/1/servicedesk/sd-user-search/participants 1414ms "SELECT ID, directory_id, user_name, lower_user_name, active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, CREDENTIAL, deleted_externally, EXTERNAL_ID FROM cwd_user WHERE (directory_id='1') AND (lower_user_name IN ('<500_users...>) )"

原因

The SQL queries against cwd_user database table were invoked when LazyOfBizUserCache is used.

The following log message, confirmed the use of LazyOfBizUserCache:

2018-04-12 22:16:17,027 JIRA-Bootstrap INFO [c.a.j.c.embedded.ofbiz.OfBizUserDao] Using lazy user cache

ソリューション

Update JIRA to use full user cache:

1. Update <JIRA_HOME>/jira-config.properties (create the file if it's not found) with the following:

   jira.fullUserCache=true

2. Restart JIRA application