Using Memcache with MySQL and PHP

最新推荐文章于 2024-10-07 21:05:54 发布

cherry_hit_tom

最新推荐文章于 2024-10-07 21:05:54 发布

阅读量791

点赞数

CC 4.0 BY-SA版权

分类专栏： php类文章标签： mysql query cache sql function caching

本文链接：https://blog.youkuaiyun.com/tsuliuchao/article/details/6432907

php类专栏收录该内容

93 篇文章

订阅专栏

本文介绍了一种通过Memcache缓存技术来提高MySQL查询效率的方法。具体实现包括连接到Memcache服务器、定义获取和设置缓存的函数，并提供了一个缓存版的mysql_query函数。此外，还对比了使用前后查询速度的显著变化。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php # Connect to memcache: global $memcache; $memcache = new Memcache; # Gets key / value pair into memcache ... called by mysql_query_cache() function getCache($key) { global $memcache; return ($memcache) ? $memcache->get($key) : false; } # Puts key / value pair into memcache ... called by mysql_query_cache() function setCache($key,$object,$timeout = 60) { global $memcache; return ($memcache) ? $memcache->set($key,$object,MEMCACHE_COMPRESSED,$timeout) : false; } # Caching version of mysql_query() function mysql_query_cache($sql,$linkIdentifier = false,$timeout = 60) { if (($cache = getCache(md5("mysql_query" . $sql))) !== false) { $cache = false; $r = ($linkIdentifier !== false) ? mysql_query($sql,$linkIdentifier) : mysql_query($sql); if (is_resource($r) && (($rows = mysql_num_rows($r)) !== 0)) { for ($i=0;$i<$rows;$i++) { $fields = mysql_num_fields($r); $row = mysql_fetch_array($r); for ($j=0;$j<$fields;$j++) { if ($i === 0) { $columns[$j] = mysql_field_name($r,$j); } $cache[$i][$columns[$j]] = $row[$j]; } } if (!setCache(md5("mysql_query" . $sql),$cache,$timeout)) { # If we get here, there isn't a memcache daemon running or responding } } } return $cache; } ?>

<?php $sql = " SELECT `dataID`, `dataTitle` FROM `tbldata` WHERE `dataTypeID` BETWEEN 2 AND 2093 AND `dataStatusID` IN (1,2,3,4) AND `dataTitle` LIKE '%something%' ORDER BY `dataDate` DESC LIMIT 10 "; # Before: [without memcache] $rSlowQuery = mysql_query($sql); # $rSlowQuery is a MySQL resource $rows = mysql_num_rows($rSlowQuery); for ($i=0;$i<$rows;$i++) { $dataID = intval(mysql_result($rSlowQuery,$i,"dataID")); $dataTitle = mysql_result($rSlowQuery,$i,"dataTitle"); echo "<a href="/" mce_href="/""/somewhere/$dataID/">$dataTitle</a><br />/n"; } # After: [with memcache] $rSlowQuery = mysql_query_cache($sql); # $rSlowQuery is an array $rows = count($rSlowQuery); for ($i=0;$i<$rows;$i++) { $dataID = intval($rSlowQuery[$i]["dataID"]); $dataTitle = $rSlowQuery[$i]["dataTitle"]; echo "<a href="/" mce_href="/""/somewhere/$dataID/">$dataTitle</a><br />/n"; } ?>