Mahara now works fine again ;-)
Greetings from Kassel
Wesley
]]>It has come to our attention that sites that use mysql and have been upgraded from version 1.0 have some tables where the foreign keys and indexes are not fully correct, and this can cause slowness on big sites.
A patch for this has been applied to master branch. https://reviews.mahara.org/#/c/2744/11/htdocs/lib/db/upgrade.php
The tables that need fixing are:
artefact_access_usr
artefact_access_role
artefact_attachment
group
grouptype_roles
view_autocreate_grouptype
You should change your tables to InnoDB (http://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html) and add the missing keys.
That should sort out the slowness problems.
A good way to check what the db structure should be is to install a clean 1.6.6 Mahara and compare the db structure between it and the one you upgraded.
Cheers
Robert
]]>Thanks,
Wesley
]]>