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
