?
Solved

How do I determine the amount of memcached memory I need?

Posted on 2010-11-17
3
Medium Priority
?
465 Views
Last Modified: 2012-05-10
I am on a VPS with 160 MB real memory and 64 MB virtual memory. I run a MySQL database using php.

What is the minimum memory I need for memcached on the VPS? What are the parameters to be taken into consideration when making this decision?
0
Comment
Question by:noobie210
3 Comments
 
LVL 48

Accepted Solution

by:
hernst42 earned 1000 total points
ID: 34153962
Size the memcached so you don't get to many cahce misses. use the memcahced-tool or http://www.php.net/manual/en/memcached.getstats.php to get the information and there look for "evictions". If that number is high the size of your memcache is to small. Or comapre the "bytes" value against your configured memory to use.
0
 
LVL 15

Expert Comment

by:Insoftservice
ID: 34153983
Hi
i would agree with @hernst42.
checkout the load you would be getting on ur website..
for eg  if its payment site .
@hernst42. what do u think if   @noobie210 changes its engine from myisam to heap or other such technique or engine.
0
 

Author Closing Comment

by:noobie210
ID: 34154228
So it is a matter of trial and error after installing memcached. Is there no way of calculating in advance how much memory I will need?

Will increasing memory from 160 MB to 400 MB (with half devoted to mamcached) be enough to begin with? Or will nothing short of a dedicated server do?
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question