I saw your Google+ post and thought I might pipe in. Sounds like the act of loading the gradebook is sucking up all the database resources. Is this a very big gradebook with tons of students?
I found a good article on the perils of using "copy to tmp table":
It might be the SET tmp_table_size in the MySQL config needs to be increased.