List:General Discussion« Previous MessageNext Message »
From:jocelyn fournier Date:March 4 2009 4:56pm
Subject:Re: SQL_NO_CACHE
View as plain text  
If SQL_NO_CACHE is specify, the cache will never be used :

The Query Cache behaviour is quite simple, it uses the exact given query 
syntax as a hash to search into the query cache;
it means writing 'select' or 'SELECT' is different. It also means adding 
SQL_NO_CACHE will search in the cache for a different query string, 
which will never be cached :)

   Jocelyn



Le 04/03/2009 17:39, Perrin Harkins a écrit :
> On Wed, Mar 4, 2009 at 11:23 AM, Thomas Spahni<tsp@stripped>  wrote:
>    
>> SQL_NO_CACHE means that the query result is not cached. It does not mean
>> that the cache is not used to answer the query.
>>      
>
> Oh, right, he's looking for this:
>
> SET SESSION query_cache_type=off;
>
> - Perrin
>
>    

Thread
SQL_NO_CACHEMorten4 Mar
  • Re: SQL_NO_CACHEMicah Stevens4 Mar
  • Re: SQL_NO_CACHEPerrin Harkins4 Mar
  • Re: SQL_NO_CACHEThomas Spahni4 Mar
    • Re: SQL_NO_CACHEPerrin Harkins4 Mar
      • Re: SQL_NO_CACHEjocelyn fournier4 Mar
        • Re: SQL_NO_CACHEMorten Primdahl4 Mar
          • Re: SQL_NO_CACHEjocelyn fournier4 Mar
            • Re: SQL_NO_CACHEMicah4 Mar
          • Re: SQL_NO_CACHEJocelyn Fournier4 Mar
            • Re: SQL_NO_CACHEMorten Primdahl4 Mar
              • Re: SQL_NO_CACHEJohan De Meersman4 Mar