UPDATE, 2007/11/30 09:53 PM EST:
It seems that the slowness problem is caused by the merge tables. MySQL 5.1 has partitioning, so once 5.1 is stable, we will upgrade to it and switch to partitioned tables instead. That should fix the slowness. The ranks problem will be fixed after we fix the slowness problem.