Mysql缓存集:如何在网站上测试

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.