List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:January 16 2008 7:00am
Subject:Re: Does SQL_NO_CACHE work?
View as plain text  
learnt more from here.

On Jan 16, 2008 2:31 PM, Dan Nelson <dnelson@stripped> wrote:

> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
Does SQL_NO_CACHE work?mos16 Jan
  • Re: Does SQL_NO_CACHE work?Chris16 Jan
  • Re: Does SQL_NO_CACHE work?Dan Nelson16 Jan
    • Re: Does SQL_NO_CACHE work?Moon's Father16 Jan