Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-39254

refreshAuthzGroup is inefficient and can cause high load

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 11.0
    • Component/s: Kernel
    • Labels:
    • Previous Issue Keys:
      KNL-1325

      Description

      The method in DbAuthzGroupService.refreshAuthzGroup() can add a lot of pressure to a database especially for systems that use course management api to maintain enrollment information.

      KNL-1304 would have refreshing authz groups be disabled which would cause other issues with realms that have been updated but not used.

      There is another approach first fostered by John Bush and later improved upon which is to make refreshAuthzGroups to be more efficient and reduce the load on a database. This has been in production for Asahi Net clients for a while and we have had good success with it even with sakai system that has 14K active sessions.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ern Earle R Nietzel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code