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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.