HTF Asked: 2012-05-31 04:09:24 +0800 CST2012-05-31 04:09:24 +0800 CST 2012-05-31 04:09:24 +0800 CST MySQL caching (innodb_buffer_pool_size vs query_cache_*) 772 What's the relation between: innodb_buffer_pool_size and query_cache_* Both are use for caching queries but what's the difference? Can I use both? Thank you mysql cache 2 Answers Voted Best Answer johnshen64 2012-05-31T04:17:48+08:002012-05-31T04:17:48+08:00 Buffer pool is for caching retrieved table and index data in memory, query cache just caches the parsed mysql queries and their results. The former is much larger and usually far more important. Sure you can use both. Richard de Wit 2012-05-31T04:24:42+08:002012-05-31T04:24:42+08:00 innodb_buffer_pool_size = caches the tables for better response times query_cache = for remembering queries to get them faster the next time you execute the same query
Buffer pool is for caching retrieved table and index data in memory, query cache just caches the parsed mysql queries and their results. The former is much larger and usually far more important. Sure you can use both.
innodb_buffer_pool_size = caches the tables for better response times
query_cache = for remembering queries to get them faster the next time you execute the same query