|
楼主 |
发表于 2009-12-30 22:27:47
|
显示全部楼层
December 29, 2009
Optimizations to stats web pages
In preparation for the migration to the new stats db, we have been doing some profiling on the stats db to see where we can get the most speed up. We have found a few items that we're working on to increase speed. The hardware improvement will make the biggest advantage in general, but now is a good time for us to try to get the stats system lean and efficient, since profiling afterwards will be harder (and any efficiencies we can squeeze out will help years from now when the new hardware is underpowered for the new stats load).
So, from the donor perspective, you will at first see the results of some experimenting on our side to improve the throughput (i.e. may be some bugs too), but hopefully there will be some throughput benefits even in the short term.
Finally, we have noticed that there are many web clients pounding our stats system, some doing 10,000 accesses per day and many doing 1,000. These IPs will be banned, so please turn off any scripts you have doing automatic access. "Normal" access is assumed to be up to 50 accesses a day. There's no need to do 1,000 or more and it really bogs down the stats for everyone else.
If you're looking to get access to our stats system, please check out our FAQ entry on this issue.
UPDATE:
We've turned off certain stats page functions dealing with queries relating to the number of CPUs. We have also stepped up the caching of team pages (all team pages are cached for 60 minutes). This will make a major performance win in the stats db and so far is looking to help a lot.
This change is temporary since the cause is clear: our db keeping track of items like specific cpus is way too big, due to the millions of CPUs that have participated in FAH. This won't be a problem with the new servers, so we will just turn on these features after we migrate. For now, turning off this parts of the stats pages will help a lot until we switch over.
大意:
优化统计
我们准备升级统计服务器了。顺便我们将对统计系统做些调整。我们将把每日访问次数高于50次的IP地址封掉。因此会有大部分签名服务会挂掉。 |
评分
-
查看全部评分
|