Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-71464

DB reads/writes increased in login submission after landing MDL-71410

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Deferred
    • 3.11
    • None
    • Activity completion

    Description

      Some performance issues have appeared after landing MDL-71410. For instance: https://ci.moodle.org/job/P.00.00%20-%20Attic%20-%20Performance%20comparison%20moodle.git%20vs%20integration.git%20%28master%29/2314/

      Eloy has shared the following information: 

      If the Moodle site hasn't any course, the result is the expected:
      with purged caches I get: "DB reads/writes: 30/0" before and after
       
      With a couple of courses on the site... now I get, in login page:
      623a3d9 : DB reads/writes: 27/0
      00dfc98 : DB reads/writes: 30/0(both executed after admin/cli/purge_caches.php )
       
      So, maybe it depends on the number of courses... but for sure the difference is before/ after MDL-71410.
       
      And it's in the login page... not logged-in, not sure why that page should be triggering anything course-related.

       

      Attachments

        Issue Links

          Activity

            People

              rezaie9 Shamim Rezaie
              sarjona Sara Arjona (@sarjona)
              Sam Marshall, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Raquel Ortega, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours
                  5h