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.
mysql> SET GLOBAL query_cache_size = 1000000;
Query OK, 0 rows affected (0.04 sec)
mysql> SHOW VARIABLES LIKE 'query_cache_size';
When your query_cache_type
variable is also set to ON
, you can check via
SHOW STATUS LIKE 'Qcache%';
Qcache_hits
tells you, if a query was read from cache, Qcache_inserts
if a query was put into cache, Qcache_not_cached
which queries were not cached.