Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 2.1.1, 2.2
-
Fix Version/s: 2.1.2
-
Labels:
-
Environment:MySQL server version: 5.0.77
-
Database:MySQL
-
Testing Instructions:
-
Workaround:
-
Affected Branches:MOODLE_21_STABLE, MOODLE_22_STABLE
-
Fixed Branches:MOODLE_21_STABLE
-
Pull from Repository:
-
Pull Master Branch:
-
Pull Master Diff URL:
Description
Example: deleting question attempts on large MySQL database can take up to 10 minutes and is wasting database server resources.
Large database in this case means:
question_attempts table – ~ 1.5M rows
question_attempt_steps table – ~ 4M rows
question_attempt_step_data table – ~ 9M rows
The fix described in Workaround makes this action to take less then some seconds.