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

backupidsexists and backupidscache could be used more effectively

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Reopened
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.4.5, 2.5
    • Fix Version/s: None
    • Component/s: Backup, Performance
    • Labels:
    • Testing Instructions:
      Hide

      PHPUnit tests on ALL databases.

      Complete each of the following on each supported database;

      • Into an install that has never had MDL-40579's backup restored, restore it and ensure no errors.
      • Restore the same backup as in (1) again into the subject and confirm no errors.
      • Go to Site administration ► Server ► Performance
      • Drop your extra memory limit as low as tolerable (64M if possible)
      • Restore again, confirm no errors.
      • Take each of a simple quiz, resource, database activity, forum
        • Duplicate each one.
        • Confirm the duplicated items is the same as the original and no errors were reported.
      Show
      PHPUnit tests on ALL databases. Complete each of the following on each supported database; Into an install that has never had MDL-40579 's backup restored, restore it and ensure no errors. Restore the same backup as in (1) again into the subject and confirm no errors. Go to Site administration ► Server ► Performance Drop your extra memory limit as low as tolerable (64M if possible) Restore again, confirm no errors. Take each of a simple quiz, resource, database activity, forum Duplicate each one. Confirm the duplicated items is the same as the original and no errors were reported.
    • Affected Branches:
      MOODLE_24_STABLE, MOODLE_25_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      The restore process uses backupidsexists and backupidscache to store the existence and data from the database to reduce overhead when importing. The cache was installed as part of MDL-27120. It is slanted to be replaced by MUC.

      This issue will explore the performance benefit/cost of MUC and also improvements to the way these caches are used to reduce database calls.

      This will provide performance improvements for restore and for activity duplication.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated: