Very often, Moodle "sticks" during use. If you attempt to log back in and try again, it will "stick" in the same place. However, on another day, the sticking will be elsewhere on the system. When it "sticks", the page can take up to 2 minutes to load.
To following MYSQL command resolves this issue: "RESET MASTER" - this flushes the BINARY files in /var/lib/mysql.
We are running the latest version of Moodle (1.4.4) on SuSE Linux Enterprise Server V8. (Dual PIII-800,2GB RAM, 20GB HDD)
Why does this happen? Is it a Moodle problem, or a problem with our "mysql" config ?