MySQL Caching Tips

A few helpful reminders for mysql caching (or cache-disabling) commands.

RESET QUERY CACHE;
FLUSH QUERY CACHE;
SHOW VARIABLES LIKE 'have_query_cache';
SHOW STATUS LIKE 'Qcache%';
SET SESSION query_cache_type=0;
SELECT
SQL_NO_CACHE
post_id
FROM {table_name}

Comments Off on MySQL Caching Tips

Categories Random