upgrade query takes too long in DB upgrade to 18.04
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Confirmed
|
High
|
Unassigned |
Bug Description
When upgrading from 17.10 to 18.04, with MySQL 5.7 the upgrade script takes too long to upgrade the event_log table
In queries like
$sql = "UPDATE {event_log} e
if there are too many logs in the table, the sql query will take too long too run. This needs to be improved.
Changed in mahara: | |
status: | New → Confirmed |
importance: | Undecided → High |