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
