Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.