Skip to content

Instantly share code, notes, and snippets.

@ksemel

ksemel/query-cache.sql

Created May 10, 2014 16:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ksemel/e7ba75e122f5eef641c5 to your computer and use it in GitHub Desktop.
Save ksemel/e7ba75e122f5eef641c5 to your computer and use it in GitHub Desktop.
Download ZIP
Check if the Query Cache is enabled, and in use
Raw
query-cache.sql
# Check Query Cache Status
# is query cache available
SHOW VARIABLES LIKE 'have_query_cache';
# What is the cache set for?
SHOW VARIABLES LIKE 'query%';
# How much is actually used?
SHOW STATUS LIKE 'Qc%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment