Add path and update records slowness
Bug #1500285 reported by
Robert Lyon
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Mahara |
Won't Fix
|
Medium
|
Unassigned | ||
| 15.04 |
Won't Fix
|
Medium
|
Unassigned | ||
| 15.10 |
Won't Fix
|
Medium
|
Unassigned | ||
| 16.04 |
Won't Fix
|
Medium
|
Unassigned | ||
| 16.10 |
Won't Fix
|
Medium
|
Unassigned | ||
Bug Description
Upgrade Issue 1 - Add path and update records :
This adds a field 'path' to artefact table and thereafter runs a update query to add data. We have around 500K rows and this takes around 94 minutes to upgrade! This can be done in one go without the limit of 200 and it works very well taking around 2-3 minutes!
Few times the upgrade failed due to "mysqli error: [1205: Lock wait timeout exceeded; try restarting transaction]".
This is spun off from Bug #1499568
| Changed in mahara: | |
| milestone: | 16.10.1 → 17.04.0 |
Revision history for this message
| Robert Lyon (robertl-9) wrote | #1 |
| Changed in mahara: | |
| status: | Confirmed → Won't Fix |
| milestone: | 17.04.0 → none |
To post a comment you must log in.
As this upgrade is done once from older systems (older than 9th May 2014) to include the Artefact path field/content it will just be a bit of waiting pain an admin will go through - it is safer to wait rather than have the process crash.
So will mark this as not fix