From: Rick James
Date: February 27 2012 6:03pm
Subject: Re: memcache vs.query_cache
List-Archive: http://lists.mysql.com/internals/38463
Message-Id: <4F4BC577.2070400@yahoo-inc.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I would focus on improving the performance of the queries that need tmp 
tables.  Would you like to show us some (together with SHOW CREATE TABLE 
and SHOW TABLE STATUS and EXPLAIN)?

On 2/24/12 3:36 AM, Michael Widenius wrote:
> 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?
>

-- 
Rick James - MySQL Geek