这篇文章主要介绍了php使用redis实现统计缓存mysql压力的方法,涉及php操作mysql数据库及使用redis统计的相关技巧,需要的朋友可以参考下
pconnect('127.0.0.1', 6379); if(isset($_server['http_referer'])){$url_md5 = md5($_server['http_referer']); } $adve_key = 'adve';$adve_key_exists = 'adve_exists'; if(!$redis->exists($adve_key_exists)){$list = $mysql_obj->fetch_array(select * from user_online_adve);if($list){foreach ($list as $key => $value) {$url_hash = md5($value['adve_url']);$adve_hash_key = $adve_key.:.$url_hash;$id = $value['id'];$redis->set($adve_hash_key,$id);$redis->set($adve_key_exists,true);//$redis->hmset($adve_hash_key, array('id' =>$id));//print_r($redis->get($adve_hash_key));}} } $adve_new_key = $adve_key.':'.$url_md5; if($redis->exists($adve_new_key)){$adve_plus = $adve_new_key.:plus ;if(!$redis->exists($adve_plus)){$redis->set($adve_plus,1);}else{$redis->incr($adve_plus);$num = $redis->get($adve_plus);if($num >10){$id = $redis->get($adve_new_key);// insert to sql;$mysql_obj->query(update user_online_adve set adve_num=adve_num+$num where id=$id);$redis->set($adve_plus,1);}} } header('http/1.0 301 moved permanently'); header('location: https://itunes.apple.com/cn/app/san-guo-zhi15-ba-wangno-da-lu/id694974270?mt=8');/* if(){$adve_plus = $adve_key.:plus ;if($redis->exists($adve_plus)){$redis->incr($adve_plus);}else{$redis->set($adve_plus,1);}echo $redis->get($adve_plus); } foreach ($list as $key => $value) {$url_hash = md5($value['adve_url']);$id = $value['id'];$adve_num = $value['adve_num'];$adve_plus = $adve_key.:plus ;if($redis->exists($adve_plus)){$redis->incr($adve_plus);}else{$redis->set($adve_plus,1);}echo $redis->get($adve_plus);//if($redis->)//$redis->hmset($adve_key, array('id' =>$id, 'adve_num'=>$adve_num));//print_r($redis->hmget(adve:$url_hash, array('adve_num'))); }print_r($list);*/