Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Mar 022011
 

Disable Query Cache at runtime when querying MySQL database

Answer:

When you want MySQL to execute a SQL statement without looking at the query cache first, you can use the keyword SQL_NO_CACHE

E.g.

mysql> SELECT SQL_NO_CACHE name FROM user;

That's all.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>