On RedHat 7.1 64-bit- Moodle 3.4.x, PhP 7.1 and MySQL 5.7.x community edition.
The app server has about 24 gbs and db has about 32 gbs.
Some users say that moodle is excruciating slow (I don't see it) and because we are running cron every 30 mins, could that be a factor.
It almost always seem to be during quiz time. Would re-indexing the entire database or just quiz tables, help to improve performance?
I noticed that we have 2 missing indexes and 66 foreign key violations. By fixing those, would it:
- Compromise the records of existing content or data in a course and cause the course to not work any more?
- Would it speed up the performance?
- How do I reindex and fix these foreign key violations?
The SQL slow log seems to be more cron oriented processes...