From: Dan Nelson
Date: January 16 2008 6:31am
Subject: Re: Does SQL_NO_CACHE work?
List-Archive: http://lists.mysql.com/mysql/210855
Message-Id: <20080116063132.GG97708@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jan 16), mos said:
> I tried :
> 
> select SQL_NO_CACHE * from table where col1='abc';
> 
> which took 800ms the first time it was executed. The second time it
> was executed it took 0ms. How is that possible if the query is not
> put into the query cache? Should the query take roughly the same
> amount of time?

SQL_NO_CACHE doesn't affect mysql's key cache or the OS's buffer cache. 

-- 
	Dan Nelson
	dnelson@stripped