List:General Discussion« Previous MessageNext Message »
From:Micah Stevens Date:March 4 2009 4:13pm
Subject:Re: SQL_NO_CACHE
View as plain text  
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)
>
>
>
Thread
SQL_NO_CACHEMorten4 Mar
  • Re: SQL_NO_CACHEMicah Stevens4 Mar
  • Re: SQL_NO_CACHEPerrin Harkins4 Mar
  • Re: SQL_NO_CACHEThomas Spahni4 Mar
    • Re: SQL_NO_CACHEPerrin Harkins4 Mar
      • Re: SQL_NO_CACHEjocelyn fournier4 Mar
        • Re: SQL_NO_CACHEMorten Primdahl4 Mar
          • Re: SQL_NO_CACHEjocelyn fournier4 Mar
            • Re: SQL_NO_CACHEMicah4 Mar
          • Re: SQL_NO_CACHEJocelyn Fournier4 Mar
            • Re: SQL_NO_CACHEMorten Primdahl4 Mar
              • Re: SQL_NO_CACHEJohan De Meersman4 Mar