List:General Discussion« Previous MessageNext Message »
From:Morten Date:March 4 2009 3:27pm
Subject:SQL_NO_CACHE
View as plain text  
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