Details
-
Bug
-
Resolution: Fixed
-
Major
-
3.0.3, 3.1
-
MOODLE_30_STABLE, MOODLE_31_STABLE
-
MOODLE_30_STABLE
-
MDL-53795-master -
Description
While performing course backups, we noticed it was taking much longer than previously.
After some hunting, we found this to largely be caused by the addition of logstore_standard to the backups (which is a must!), but more specifically, this query:
SELECT * FROM mdl_logstore_standard_log WHERE contextid = $1 |
We quickly discovered there is no index covering contextid on logstore_standard_log.
We manually created such an index on our dataset, and the time to backup 13 example courses went from 160 minutes to 5 minutes (no, that is not a typo).
Attachments
Issue Links
- caused a regression
-
MDL-53986 Exception during upgrade
-
- Closed
-
- duplicates
-
MDL-53933 Slow course backups
-
- Closed
-
- has a non-specific relationship to
-
MDL-46455 Re-introduce backup/restore functionality with new logging system
-
- Closed
-
-
MDL-30799 META: Enable foreign keys in the database schema
-
- Open
-
- has been marked as being related by
-
MDL-53869 SQL query in participation report is not optimised to use the index on logstore_standard_log table
-
- Closed
-