reindex the a issue is slow in JSM

[红旗公]

We use JSM, 9.4.26

Recently, we have found that modifying issues takes a very long time to execute.

Our system currently has 250 custom fields, 300000 issues, and 100 JSM projects.

Here are our main configuration parameters

• -Xms64g -Xmx64g
• -XX:InitialCodeCacheSize=32m
• -XX:ReservedCodeCacheSize=512m
• JVM_SUPPORT_RECOMMENDED_ARGS="-server -XX:+UseG1GC
• -XX:+UnlockDiagnosticVMOptions
• -XX:InitiatingHeapOccupancyPercent=35
• -XX:ConcGCThreads=20
• -XX:+HeapDumpOnOutOfMemoryError
• -XX:G1ReservePercent=20
• -Djava.net.preferIPv4Stack=true -XX:MetaspaceSize=4096m

We see the logs in the profiler

2024-09-23 12:00:05,910 | catalina-exec-247 | 720x2260938x8 | seven| 1r5llla

[1720.5ms] - DefaultIssueService.update(STANDARDJSD-2588)

 [363.7ms] - DefaultIssueManager.reIndexIssues

  [362.4ms] - DefaultIssueIndexer.perform()
 

2024-09-23 12:00:25,686 | catalina-exec-124 | 720x2261071x14 | tanxsa-h | 1siv1s

[5995.0ms] - SearchResource.doRequestSearch(, null, null, GCCPSCFK-58005, null)

 [5994.9ms] - DefaultRefinedSearchManager.requestSearch()

  [344.2ms] - DefaultRefinedSearchManager.getCustomerSearchQuery(tanx-h, null, null, GCCPSCFK-58005, null)

  [5650.6ms] - DefaultRefinedSearchManager.getCustomerIssues()

   [5650.5ms] - Lucene Query

    [5650.3ms] - Lucene Search

     [5626.6ms] - Permission Query

     [10.0ms] - Create Query

     [12.6ms] - Run Search

we use the bellow the apps,but we into the save model , but is same.

How to optimize the configuration?

[红旗公]

more logs

2024-09-23 12:00:04,794 | catalina-exec-192 | 720x2260955x8 | anonymous | -

[51.2ms] - DefaultRefinedPermissionManager.isUserSomeFormOfAdmin(null)

 [51.1ms] - DefaultStructureManager.getStructures(SITE)

2024-09-23 12:00:05,910 | catalina-exec-247 | 720x2260938x8 | jiangzh | 1r5llla

[1720.5ms] - DefaultIssueService.update(STANDARDJSD-2588)

 [363.7ms] - DefaultIssueManager.reIndexIssues

  [362.4ms] - DefaultIssueIndexer.perform()

2024-09-23 12:00:25,686 | catalina-exec-124 | 720x2261071x14 | tanx-h | 1siv1s

[5995.0ms] - SearchResource.doRequestSearch(, null, null, GCCPSCFK-58005, null)

 [5994.9ms] - DefaultRefinedSearchManager.requestSearch()

  [344.2ms] - DefaultRefinedSearchManager.getCustomerSearchQuery(tanx-h, null, null, GCCPSCFK-58005, null)

  [5650.6ms] - DefaultRefinedSearchManager.getCustomerIssues()

   [5650.5ms] - Lucene Query

    [5650.3ms] - Lucene Search

     [5626.6ms] - Permission Query

     [10.0ms] - Create Query

     [12.6ms] - Run Search

[6522.4ms] - SearchResource.doRequestSearch(, null, null, GCCPSCFK-69203, null)

 [6522.4ms] - DefaultRefinedSearchManager.requestSearch()

  [127.7ms] - DefaultRefinedSearchManager.getCustomerSearchQuery(tanx-h, null, null, GCCPSCFK-69203, null)

  [6394.5ms] - DefaultRefinedSearchManager.getCustomerIssues()

   [6394.4ms] - Lucene Query

    [6394.2ms] - Lucene Search

     [6161.0ms] - Permission Query

     [219.6ms] - Create Query

     [12.3ms] - Run Search

2024-09-23 12:00:30,921 | catalina-exec-216 | 720x2261152x13 | lhltxuhd | fbju4e

[5268.3ms] - SearchResource.doRequestSearch(, null, null, DSJC-84437, null)

 [5268.2ms] - DefaultRefinedSearchManager.requestSearch()

  [100.6ms] - DefaultRefinedSearchManager.getCustomerSearchQuery(lhltxuhd, null, null, DSJC-84437, null)

  [5128.9ms] - DefaultRefinedSearchManager.getCustomerIssues()

   [5128.7ms] - Lucene Query

    [5128.4ms] - Lucene Search

     [5102.9ms] - Permission Query

     [12.0ms] - Create Query

     [12.6ms] - Run Search

2024-09-23 12:00:32,967 | catalina-exec-99 | 720x2261154x13 | tanx-h | 1siv1s

[7233.8ms] - SearchResource.doRequestSearch(, null, null, GCCPSCFK-58005, null)

 [7233.8ms] - DefaultRefinedSearchManager.requestSearch()

  [117.6ms] - DefaultRefinedSearchManager.getCustomerSearchQuery(tanx-h, null, null, GCCPSCFK-58005, null)

  [7115.9ms] - DefaultRefinedSearchManager.getCustomerIssues()

   [7115.9ms] - Lucene Query

    [7115.6ms] - Lucene Search

     [7084.7ms] - Permission Query

     [17.2ms] - Create Query

     [12.6ms] - Run Search