汉网现在是
windows 16G 内存的服务器,因为开启了板块的主题相关功能导致CPU经常飙到100%,后来看到是版块主题相关功能查的太频繁了,而且还强制使用idex_postdate索引,现在将这部分查询到的数据缓存到Memcached里边,10分钟再查询一次。代码修改如下:
打开read.php文件,找到:
- function threadrelated ($relatedcon) {
- .......
- }
上方添加代码:
- //主题相关数据缓存到Memcached by rickyleo
- function threadrelatedOptimize ($relatedcon){
- global $fid;
- $relatedb = array();
-
- if (Perf::checkMemcache()) {
- $_cacheService = Perf::getCacheService();
- $relatedb = $_cacheService->get('relatedb_'.$fid);
- }
- if(!Perf::checkMemcache() || !$relatedb){
- $relatedb = threadrelated($relatedcon);
- Perf::checkMemcache() && $_cacheService->set('relatedb_'.$fid, $relatedb, 600);
- }
-
- return $relatedb;
- }
- //end
找到:
- $relatedb = threadrelated($forumset['relatedcon']);
替换成:
- $relatedb = threadrelatedOptimize($forumset['relatedcon']);//rickyleo