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<t...@lawbiz.ch> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org