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
>
>
