MySQL Forums
Forum List  »  Memory Storage Engine

Re: engine=memory versus query_cache
Posted by: Ingo Strüwing
Date: April 03, 2006 04:49AM

Bodo Fritsche wrote:
...
> The documentation and my runtime information says
> that query_cache_size is defaulted by "0" meaning
> that although query_cache_type ="ON" there is no
> query_caching until query_cache_size and
> query_cache_limit is set.

Yes. It seems like I misinterpreted the docs.

...
> Am I right?: This means that the above mentioned
> memory-table will put a relatively high activity
> (in terms of deleting the table from the
> query_cache) on the query_cache because its fields
> will be updated so often.

Yes. I think so. But if a query is deleted, (almost) nothing needs to be done for the next update. Unless you did a select in between.

> I would have expected that mySQL recognizes that
> if a table is memory, it excludes it from
> query_caching.

Memory tables are not so different from other tables with well filled caches. The purpose of the query cache is not just to save I/O, but also to save computing efforts (e.g for complicated joins). If you have simple statements only, the query cache might not help you much anyway.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
10614
March 30, 2006 11:46AM
Re: engine=memory versus query_cache
4979
April 03, 2006 04:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.