title: Mysql cache set : How to test on website
body: <p>I executed below query to to set mysql cache, all query executed successfully but how to test what is cached and used in website from this cache.</p>
  
  <pre><code>mysql&gt; SET GLOBAL query_cache_size = 1000000;
  Query OK, 0 rows affected (0.04 sec)
  
  mysql&gt; SHOW VARIABLES LIKE 'query_cache_size';  
  </code></pre>