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

task bump_submission_for_stale_conversions causes huge performance issue on large site

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.11.11, 4.1
    • Assignment, Files API
    • None
    • MOODLE_311_STABLE, MOODLE_401_STABLE

      Essentially, this operation knocked our site completely offline. 

      Attached screenshot shows 'explain' for main query.

      Our files table contains over 12 million rows and is being searched more than once with no index. As the files table is critical, locking the table for the time needed to do this effectively destroys the site. DB connections max out and require a manual restart. 

        1. Screenshot 2022-12-22 at 08.44.55.png
          Screenshot 2022-12-22 at 08.44.55.png
          193 kB

            Unassigned Unassigned
            howardsmiller Howard Miller
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.