Following are some screen shots of mysql server running on my computer locally....
Following are the queries i ran :
SHOW VARIABLES LIKE '%query_cache%';
SHOW STATUS LIKE '%qcache%';
select * from notes where id = '0002c1ff-d8a1-4cee-a499-448332c914de';
I have attached the result of above queries before and after the select * query execution....
The only change i see in qcache is : Qcache_not_cached was 1 before select execution and after that it is 2.
Which signifies that the select query was not cached...
What could be the reason that this query was not cached...
How can i make the caching available ?