<br><br>
<div><span class="gmail_quote">On 7/13/06, <b class="gmail_sendername">Ivan Krstic</b> <<a href="mailto:krstic@solarsail.hcs.harvard.edu">krstic@solarsail.hcs.harvard.edu</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Please use Reply-to-All so your replies get copied to the list.<br><br>howard chen wrote:<br>> i also have thought that, but *SHOW STATUS return *"Qcache_hits = 0",
<br>> seems query cache was not enabled by mysql default installation? ( on<br>> FC5, yum install mysql-server, nothing changed)<br>><br>> i suspect it is related to epoll? but how to verify this?<br><br>The query cache has nothing to do with epoll.
</blockquote>
<div> </div>
<div>i mean if epoll in my FC5 didn't work, but how to verify for this?</div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">It wouldn't be terribly surprising to see mysql outperform memcached on<br>a query this simple, but that doesn't reduce memcached's usefulness in
<br>the slightest. I'd also check to make sure you had persistent<br>connections enabled in your perl script (I don't use the perl client, so<br>I'm not sure what the defaults are like).</blockquote>
<div> </div>
<div>during the loop, the connection to mysql is persistent, memcache also</div></div>