Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I learned that innodb_buffer_pool_size makes innodb behave like an in memory db. If I give innodb_buffer_pool_size enough ram for the entire db could memcached improve further the performance, or memcached would be unnecessary in such a setup?

share|improve this question
up vote 3 down vote accepted

The InnoDB Buffer Pool is the home of three classes of informational structures

If you make the InnoDB Buffer Pool large enough, then all data you have accessed will essentially stay in RAM. Any data you have never read but finally decided to read will then have data and indexes cached in the InnoDB Buffer Pool. Please read my post : What are the main differences between InnoDB and MyISAM? on how to determine the size of a good InnoDB Buffer Pool.

Given a large enough InnoDB Buffer Pool, I would rule out using memcached.

share|improve this answer
Thanks Rolando! Again, uber massive super answer :) – giorgio79 Mar 14 '13 at 18:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.