Query Cache

Query Cache

These metrics include the total size of the query cache as well as the number of cache hits and misses for SELECT queries with query cache enabled. They can help monitoring efficient use of the query cache and optimising query performance. 

  • Query Cache: bytes – Total size of the query cache in bytes.
  • Query Cache Hits – Number of times a query result has been found in the query cache (and query computation was avoided). Only updated for SELECT queries with SETTING use_query_cache = 1.
  • Query Cache Misses – Number of times a query result has not been found in the query cache (and required query computation). Only updated for SELECT queries with SETTING use_query_cache = 1.