<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">1. Are there tools that exist to help analyze which queries should be cached?<br>- I would imagine a StatsPack report would be useful. <br><br>2. What exists to monitoring and analyze for cache performance on a daily basis?<br>- DB stats, Memcached stats, as well as local cache stats if they are backed by the remote cache.<br><br>3. What level of effort was required to integrate memcached into the application?<br>- It depends. For us (Rearden Commerce), we also migrated from Apache Commons caches to Ehcache as well as did some code cleanups. But the raw integration wasn't too bad.<br><br>4. What was the support overhead from a time and expertise standpoint to maintain this?<br>-
N/A. We haven't deployed yet, though its been code-complete for a while. I'd doubt it adds much overhead. Mostly just planning for the operations team during releases, etc.<br><br>5. Are there any issues or problems in integrating and deploying the cache that are non-obvious or particularly time consuming?<br>- Depending on the use-case, integration can require a decent chunk of concurrency analysis (particularly regarding how stale data is treated). Also, you should consider what happens when converting expensive select-* operations if the cache servers go down. Such as do you get the missing key values one-by-one (assuming a single cache server went down) or fall-back to the complex query? You probably need to re-optimize these situations if previously a lot of work went into making them perform well.<br><br>6.<br>- <br><br>7. Are there any hardware requirements for the cache servers or specific hardware that
perform much better in a highly loaded environment? (Perhaps specific NICs that do better then others)<br>- I don't know specifics, but you may find <span class="nobr"></span><a href="http://www.amazon.com/Building-Scalable-Web-Sites-applications/dp/0596102356/ref=pd_bbs_sr_1/102-3071273-3180918?ie=UTF8&s=books&qid=1183004638&sr=8-1" title="Visit page outside Confluence" rel="nofollow">Building Scalable Web Sites</a> and <span class="nobr"></span><a href="http://www.amazon.com/Scalable-Internet-Architectures-Developers-Library/dp/067232699X/ref=pd_bbs_2/102-3071273-3180918?ie=UTF8&s=books&qid=1183004638&sr=8-2" title="Visit page outside Confluence" rel="nofollow">Scalable Internet Architectures</a> good references. I've heard that its pretty light on the CPU utilization, but you probably want to optimize the TCP/IP connection for this type of activity.<br><br><br><div style="font-family: times new roman,new
york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Jason Gross <jphgross@gmail.com><br>To: memcached@lists.danga.com<br>Sent: Friday, October 19, 2007 12:19:53 PM<br>Subject: Evaluating Memcached for our site. Looking for advice.<br><br>
I am evaluating memcached for our web farm and wanted to poll this <br>list for some experience in designing, deploying and maintaining it. <br>Specifically I want to analyze the overhead from a development / <br>resource and maintenance standpoint so that I can properly plan this <br>effort. Would anyone on this list be willing to share their <br>experience with deploying memcached?<br><br>The site I am working on is a social networking site that users can <br>upload individual products which other users can comment on, purchase <br>etc. The site is growing quite rapidly and is beginning to show <br>significant slowdowns during peak periods. I have a decent <br>understanding of what memcached provides and feel that its compelling <br>enough to give it a try as there are a significant amount of database <br>queries on each page load. I'd be interested in any feedback but have
<br>some specific questions below of what I am looking for.<br><br>1. Are there tools that exist to help analyze which queries should be <br>cached?<br><br>2. What exists to monitoring and analyze for cache performance on a <br>daily basis?<br><br>3. What level of effort was required to integrate memcached into the <br>application?<br><br>4. What was the support overhead from a time and expertise standpoint <br>to maintain this?<br><br>5. Are there any issues or problems in integrating and deploying the <br>cache that are non-obvious or particularly time consuming?<br><br>7. Are there any hardware requirements for the cache servers or <br>specific hardware that perform much better in a highly loaded <br>environment? (Perhaps specific NICs that do better then others)<br><br>Thanks!<br>-Jason<br></div><br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?
Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>