How to list cached queries in MySQL? (Qcache_queries_in_cache)
If You enable a Session Specific variable profiling
SET SESSION PROFILING=on;show profiles;Now by checking show profile for query your query_id;
mysql> show profile for query 2;+--------------------------------+----------+| Status | Duration |+--------------------------------+----------+| starting | 0.000017 || checking query cache for query | 0.000005 || checking privileges on cached | 0.000003 || sending cached result to clien | 0.000005 || logging slow query | 0.000002 || cleaning up | 0.000001 |+--------------------------------+----------+By checking the status column you can see whether the queries cached.
But this is only a session specific you have enable profiling for each session.