drop table if exists t1; set GLOBAL query_cache_type=on; set GLOBAL query_cache_size=1355776; reset query cache; flush status; CREATE TABLE t1 ( pk int not null primary key, a int, b int not null, c varchar(20)) ENGINE=ndbcluster; insert into t1 value (1, 2, 3, 'First row'); select * from t1; pk a b c 1 2 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 select * from t1; pk a b c 1 2 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 update t1 set a=3 where pk=1; select * from t1; pk a b c 1 3 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 insert into t1 value (2, 7, 8, 'Second row'); insert into t1 value (4, 5, 6, 'Fourth row'); select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 3 show status like "Qcache_hits"; Variable_name Value Qcache_hits 1 select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 2 show status like "Qcache_hits"; Variable_name Value Qcache_hits 2 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 3 delete from t1 where c='Fourth row'; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 3 use test; select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row select * from t1 where b=3; pk a b c 1 3 3 First row show status like "Qcache_hits"; Variable_name Value Qcache_hits 4 update t1 set a=4 where b=3; use test; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 5 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 begin; update t1 set a=5 where pk=1; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 7 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 8 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 commit; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 8 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 9 show status like "Qcache_hits"; Variable_name Value Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 show status like "Qcache_inserts"; Variable_name Value Qcache_inserts 9 show status like "Qcache_hits"; Variable_name Value Qcache_hits 8 drop table t1; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 SET GLOBAL query_cache_size=0;