re: memcache vs.query_cache

Hi Monty

Thanks for the explanation.
Regards
Revathi R

--- On Fri, 2/24/12, Michael Widenius <[email protected]> wrote:

> From: Michael Widenius <[email protected]>
> Subject: re: memcache vs.query_cache
> To: "Revathi Rangachari" <[email protected]>
> Cc: "Sergei Golubchik" <[email protected]>, [email protected]
> Date: Friday, February 24, 2012, 5:06 PM
> 
> Hi!
> 
> >>>>> "Revathi" == Revathi Rangachari <[email protected]>
> writes:
> 
> Revathi> Hi
> Revathi> (1) If memcache is available  - in an
> apache-php-mysql environment, does enabling or disabling of
> query_cache_type in mysql configuration, matter in improving
> performance? 
> 
> It depends on how memcache is used and how often you
> disregard things
> from it.
> 
> In memcache it's better to store things that doesn't matter
> if it's a
> bit old.
> 
> Query cache is better for things that changes 'relatively
> seldom' (not
> more than once a second) as it's 'never out of date'.
> 
> It's not useful to cache the same kind of data with both
> caches...
> 
> Revathi> (2) If memcache is enabled and also
> query_cache_type is enabled, will both cache mechanism work
> or does one take precedence over the other, in serving
> requests.
> 
> As you normally ask memcache first if a query is there, it
> will take
> precedence.
> 
> Revathi> (2) I just wanted to understand how these
> variables query_cache_type, tmp_table_size,
> max_heap_table_size, memory temporary tables influence each
> other?
> 
> tmp_table_size and max_heap_table_size have nothing to with
> query
> cache. These are just restriction for how much memory that
> MySQL/MariaDB will use for resolving a query.
> 
> Revathi> In a replicated environment where
> query_cache_type is enabled and the tmp_table_size (64MB)
> and max_heap_table_size ( 1GB) the number of memory
> temporary tables created over a period of half-an-hour is
> around 2000.
> 
> This is depending on your queries.
> 
> Revathi> Whereas if query_cache_type is disabled and the
> tmp_table_size(64 MB) and max_heap_table_size 91 GB) the
> number of temporary tables created over a period of
> half-an-hour is around 6000.
> 
> This happens because many of your queries are resolved by
> the query
> cache and thus there is no need to run the query (that
> apparently is
> using temporary tables to resolve the query).
> 
> Revathi> Can anyone please let me know what would be the
> explanation for the above? 
> Revathi> Should I bring down values of tmp_table_size and
> max_heap_table_size?
> 
> No.
> 
> Regards,
> Monty
> 
> -- 
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals
> 
> 

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals