There appears to be a bug in the database module in Moodle.

This is only apparent if you upgrade from Moodle 1.8 to Moodle 1.9, like we did.
When a user searches the database the CPU on the server hits 100% and hangs.  The only way to restore activity is to restart the MySQL and Apache processes. Read more »