[FOLIO-2039] Research perf related tickets from Q2.1 BugFest Created: 24/May/19  Updated: 03/Jun/20  Resolved: 31/May/19

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Task Priority: P3
Reporter: Hongwei Ji Assignee: Hongwei Ji
Resolution: Done Votes: 0
Labels: performance, platform-backlog
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: Text File slow.log    
Issue links:
Relates
relates to MODINVSTOR-292 Search instances by item.barcode is slow Closed
relates to MODPERMS-57 Improve mod-permission performance Closed
relates to MODUSERS-125 User (sort by group) search slow in 2... Closed
relates to FOLIO-2032 Takes Nearly 7 Seconds to Log Into Bu... Closed
relates to FOLIO-2044 GET tags can take up to 9 seconds to ... Closed
relates to UICIRC-264 Takes a long time to load Settings > ... Closed
relates to UIIN-575 Navigation between Settings sub-pages... Closed
relates to MODAT-45 Improve mod-authtoken performance Closed
relates to FOLIO-2110 Checking BugFest Q2.2 performance Closed
relates to OKAPI-739 Adjust Okapi RES log to display reque... Closed
Sprint: CP: sprint 64
Story Points: 3
Development Team: Core: Platform

 Description   

There was a few performance related tickets opened during Q2.1 BugFest test. For example:
https://folio-org.atlassian.net/browse/UIIN-575
https://folio-org.atlassian.net/browse/FOLIO-2032
https://folio-org.atlassian.net/browse/CIRC-329
https://folio-org.atlassian.net/browse/FOLIO-2044
BTW the Q2.1 BugFest bug dashboard is https://folio-org.atlassian.net/secure/Dashboard.jspa?selectPageId=10610
Research Okapi logs about performance related issues.



 Comments   
Comment by Hongwei Ji [ 24/May/19 ]

I downloaded Okapi log from Monday to Thursday. It is pretty large (1.3G), so I filtered it using 2 seconds threshold. See attached slow.log file in case someone is interested in it.

Comment by Hongwei Ji [ 28/May/19 ]

Here is the break down of the slow entries in the filtered Okapi log (total slow entries is 5816):

  • 60 related to kb-ebsco-java
  • 4 related to circulation
  • 62 related to inventory
  • 99 related to user
  • 2837 related to auth-token
  • 2755 related to permissions
    There are certain storage module related queries that are slow (Array or FK related join for example). But in general we should do something about mod-permissions and authtoken (using local cache for example). In FOLIO-2044 Closed , I did a detailed analysis to show permission related queries caused the slowness.
Comment by Hongwei Ji [ 31/May/19 ]

Created a few tickets for next iteration.

MODINVSTOR-292 Search by item.barcode is slow in Q2.1 Bugfest
MODPERMS-57 Improve mod-permission performance
MODAT-45 Improve mod-authtoken performance
MODUSERS-125 User search slow in 2.1 Bugfest env.
OKAPI-739 Adjust Okapi RES log to display request parameters
Generated at Thu Feb 08 23:17:44 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.