<br><br>
<div><span class="gmail_quote">On 7/13/06, <b class="gmail_sendername">Jamie McCarthy</b> <<a href="mailto:jamie@mccarthy.vg">jamie@mccarthy.vg</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">MySQL is a centralized bottleneck, is hard/expensive to add<br>performance to, and has highly nonlinear performance
<br>characteristics. Memcached is decentralized, cheap/easy to add<br>performance to, and runs very close to O(1).<br><br>So the big win for memcached is not that it is faster than mysql,<br>but that it takes load off mysql.
<br><br>If you can move 1000 simple queries per second from your (expensive)<br>mysql replicator slave network to your (cheap) memcached network,<br>then even if those queries run slightly slower (which I doubt), you<br>will be ahead. Your mysqls are freed up to do the complex queries
<br>only they can do, they will run those lengthy queries faster which<br>will be a net gain in performance for your application, and they<br>will have more breathing room before the load wedges them up and<br>effectively takes your whole application down.
<br><br>Is there an FAQ yet? I nominate this as one entry :)<br>--<br>Jamie McCarthy<br><a href="http://mccarthy.vg/">http://mccarthy.vg/</a><br><a href="mailto:jamie@mccarthy.vg">jamie@mccarthy.vg</a><br></blockquote></div>
<div> </div>
<div> </div>
<div>Hi all,</div>
<div> </div>
<div>I think no people questioning about the practical use of Memcahed (we all know about it, otherwise there is no point in sending to this ML), but just consider the followings...</div>
<div> </div>
<div>1. MySQL is a complete, heavy, bulky DBMS, in the above example, in every loop, the script prepare the SQL statement, retrieve data from disk (prepare statement can't have query cache!!), and it is still faster then mencached where data are being stored in memory, and we believed that memcached is an optimized, lightweight server.
</div>
<div> </div>
<div>2. If the bottom-neck is due to the Perl Client, then, are there any faster client (written in C) for memcached? People not aware of this slow down or they just satisfied with this?</div>
<div> </div>
<div>the purpose of my email is want to help memcached be a better software, no to challenge its usefulness...</div>
<div> </div>
<div> </div>
<div>Regards,</div>
<div>Howa <br> </div>