title: Same Mysql Server Cache settings on two different servers, but different result
body: <p>I have 2 VPS running MYSQL 5.6 as a DB Server, and both have the cache enabled with the below settings </p>
  
  <pre><code>have_query_cache = YES
  query_cache_type = ON
  query_cache_size = 16777216
  query_cache_limit = 1048576   
  query_cache_min_res_unit = 4096
  query_cache_wlock_invalidate = OFF
  </code></pre>
  
  <p>Normally cache is working on both servers but interestingly there is 1 query that caches on one of the servers but could not on 2nd server. </p>
  
  <p>Need to understand what i am missing in the configurations etc. </p>