I have this same issue. A sudden on set of spammers signed up and now I can't get into the Users Awaiting Moderation page. It times out every time.
Is there a SQL statement I can use to truncate the table / delete the entries? I don't know the schema to well, so could use some advice.