We are running the Moodle-plateform for about 3 months now. We are very happy with it, but we recently had two major problems:
1. Last week, our Moodle-server "lost" all the journal entries from the students. Through phpMyAdmin, I found out, that the Journal-table in Mysql was corrupted. Repairing the mysql-table did bring the student-works up again.
2. Yesterday, our Moodle system needed nearly 3 minutes to show the main-page of several courses. Same thing for the journal-entries. Some days ago, it took less than 2 seconds to parse the same page!
The Moodle Homepage, login, course-listing was quite quick (a bit slower than usually, but one could live with it), but entering a course was sooooo damn long. I monitored the server and saw that the mysql-daemon took 30-40% of the processing power for the 3 Minutes it took to parse for example the journals.
The solution to the second problem was emptying the moodle-cache-files in the mysql-database. The system is now running fine again.
Is there any way to prevent these database-problems? Or do I have to repair tables regularly and empty the cache manually once a week?
Server data:
Xserve G5 (2 * 2 GHz)
2 GB RAM
Moodle is the only app running on it.