-
Improvement
-
Resolution: Unresolved
-
Minor
-
None
-
2.7
-
None
-
MOODLE_27_STABLE
Turnitin is creating massive DB load in what looks to be its GC process. We see lots of deletes in the form of
DELETE FROM mdl_turnitintool_submissions WHERE submission_objectid=457256626 AND submission_part=2807
|
which performs a full table scan. An index on submission_objectid solves the problem.
It does not appear that turnitintwo has an index on submission_objectid.