Very slow login Moodle
February 8, 2008 – 12:07got complaints that login to Moodle was very slow. Might be related to missing indexes on some tables.
Coolness: I didn’t know but there is a function in Moodle to check for missing indexes: misc -> XMLDB editor . Checks tables for missing indexes and generates SQL to repair. Turned out that the whole install was fckd up. Loooots of indexes missing. Repaired indexes in SQL command line interface.
Check this post for tips.
Also checked missing indexes in other moodle installs.
Sorry, comments for this entry are closed at this time.