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


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


mysql> SELECT SQL_NO_CACHE name FROM user;

That's all.

 Leave a Reply



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>