This article mainly introduces PHP from Memcache read data and then batch write MySQL method, can use Memcache to alleviate the server read and write pressure, and to achieve database data write operation, very practical value, need to refer to the friend.
With Memcache can alleviate PHP and database pressure under the code is to solve the high load database write bottleneck problem, encountered the most practical: when the IP PV UV, the user reached tens of thousands of visits per minute, to record these data, real-time write to the database will be rushed to collapse.
With the following techniques can be solved, as well as user registration, the same time off, a large number of user registration, can be cached once written to the database, the code is as follows
Public Function Cldata () {$memcache _obj = new Memcache; $memcache _obj->connect (' 127.0.0.1 ', ' 11211 '); $all _items = $memcache _obj->getextendedstats (' items '); foreach ($all _items as $option = + $vall) {if (Isset ($all _items[$option [' items ']) {$items = $al l_items[$option [' Items ']; foreach ($items as $number = + $item) {$str = $memcache _obj->getextendedstats (' Cachedump ', $number, 0); $line = $str [$option]; if (Is_array ($line) && count ($line) > 0) {foreach ($line as $key = $value) {$keys [] = $key;}} }}} (count ($keys));//Get to key if (count ($keys) >50) {//number of data bars to write $end = 50; }else{$end =count ($keys); } for ($i =0; $i <= $end; $i + +) {if (!strstr ($keys [$i], ' datadb ')) continue; $KSV = Str_replace (' datadb ', ' ', $keys [$i]); /* $logdata = unserialize (S (' login '. $ksv));//Login Write if (Is_array ($logdata)) {$this->addsuidinlogin ($logdata [0], $logdata [1], $logdata [2],1); }/* $sdata = unserialize (S (' Regadd '. $ksv));//Register Write if (Is_array ($sdata)) {$this->baidu AD ($sdata [0], $sdata [1], $sdata [2], $sdata [3], $sdata [4],1]; } */$regdata = unserialize (S (' datadb '. $ksv)); $ress []= $regdata; S (' datadb '. $KSV, NULL); } $ADDB = M ()->db (66,c (' Db_web_ad '));//Bulk Write AddAll $addb->table (' Mj_ad_count ')->addall ($ress); Echo M ()->getlastsql (); }
Php method for reading data from memcache and then batch writing to MySQL