Clear MySQL query cache without restarting server

Question

Is there any way to clear mysql query cache without restarting mySQL server

User · Answer

according the documentation  this should do it     RESET QUERY CACHE

User · Answer

In my system  Ubuntu 12 04  I found RESET QUERY CACHE and even restarting mysql server not enough  This was due to memory disc caching  After each query  I clean the disc cache in the terminal     sync  amp  amp  echo 3   sudo tee  proc sys vm drop caches   and then reset the query cache in mysql client   RESET QUERY CACHE

User · Answer

I believe you can use     RESET QUERY CACHE       if the user you re running as has reload rights  Alternatively  you can defragment the query cache via     FLUSH QUERY CACHE    See the Query Cache Status and Maintenance section of the MySQL manual for more information

[mysql] Clear MySQL query cache without restarting server

Examples related to mysql

Examples related to caching