learnt more from here. On Jan 16, 2008 2:31 PM, Dan Nelson <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn