Keep in mind the file system caches too, so it might be working, but the file access is still getting put in memory. You should disable that too if you really want consistent results.
In Linux you can dump the file system cache between each query, I have no clue how to do it in windows or other systems, although Unix stuff is probably similar. -Micah On 03/04/2009 07:27 AM, Morten wrote: > > Hi, I was hoping that using SQL_NO_CACHE would help me bypass the > query cache, but judging from the below it doesn't. What can I do to > avoid the query cache? > > Thanks. > > Morten > > > mysql> select count(*) from users where email = 'hello'; > +----------+ > | count(*) | > +----------+ > | 0 | > +----------+ > 1 row in set (7.22 sec) > > mysql> select count(*) from users where email = 'hello'; > +----------+ > | count(*) | > +----------+ > | 0 | > +----------+ > 1 row in set (0.45 sec) > > mysql> select count(*) from users where email = 'hello'; > +----------+ > | count(*) | > +----------+ > | 0 | > +----------+ > 1 row in set (0.45 sec) > > mysql> select SQL_NO_CACHE count(*) from users where email = 'hello'; > +----------+ > | count(*) | > +----------+ > | 0 | > +----------+ > 1 row in set (0.43 sec) > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
