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

Performance regression seen after navigation overhaul is integrated.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.9
    • Fix Version/s: None
    • Component/s: Navigation
    • Labels:
    • Affected Branches:
      MOODLE_29_STABLE

      Description

      While reviewing performance tool, there has been few params which are reliable and showed performance degradation after navigation issue was integrated.

      Results after navigation issue:

      [PERFORMANCE_compare_28stable_vs_masterintegration] $ /bin/sh -xe /tmp/hudson6459540509003621538.sh
      + cd /var/lib/jenkins/scripts
      + ./compare_runs_results.sh
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: dbreads - Frontpage logged -> 5.7% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: dbreads - View course -> 3.23% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: dbreads - View a forum activity -> 5.06% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: dbwrites - All steps data combined -> 52.73% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: dbquerytime - All steps data combined -> 6.85% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - Frontpage not logged -> 1.11% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View course -> 5.42% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View a page activity -> 5.65% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View course again -> 5.42% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View a forum activity -> 6.07% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View a forum discussion -> 5.98% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - Fill a form to reply a forum discussion -> 4.64% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - Send the forum discussion reply -> 2.01% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View course once more -> 4.97% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - View course participants -> 4.68% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: memoryused - Logout -> 1.11% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: filesincluded - All steps data combined -> 8.02% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - increment: sessionsize - All steps data combined -> 4.13% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - View a page activity -> 3.63% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - View course again -> 3.39% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - View a forum discussion -> 1.77% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - Fill a form to reply a forum discussion -> 1.75% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - View course once more -> 3.39% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbreads - View course participants -> 2.74% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: dbwrites - Frontpage logged -> from 106 to 0
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: memoryused - Login -> 13.94% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (7232452 MDL-45774...) - decrease: memoryused - Frontpage logged -> 15.06% better
      

      Results before navigation issue:

      [PERFORMANCE_compare_28stable_vs_masterintegration] $ /bin/sh -xe /tmp/hudson1215613841698204745.sh
      + cd /var/lib/jenkins/scripts
      + ./compare_runs_results.sh
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbreads - View course -> 3.23% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbreads - View a page activity -> 3.63% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbreads - View course again -> 3.39% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbreads - View course once more -> 3.39% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbreads - View course participants -> 2.74% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - decrease: dbwrites - All steps data combined -> 4.03% better
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbreads - View a forum activity -> 5.06% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbwrites - Frontpage logged -> 48.84% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbwrites - View a page activity -> 50.6% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbwrites - View a forum activity -> 50.6% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbwrites - Fill a form to reply a forum discussion -> 50.6% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: dbwrites - View course once more -> 50.6% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: memoryused - All steps data combined -> 2.46% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: filesincluded - All steps data combined -> 8.86% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: sessionsize - Frontpage not logged -> 5% worst
      between before - 28 (8fc43b0 weekly re...) and after - 29 (f3cd162 MDL-49828...) - increment: sessionsize - Logout -> 5% worst
      

      Interesting parameters to look at is dbreads, memoryused and sessionsize.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              rajeshtaneja Rajesh Taneja
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: