drop table if exists t1, t2, t3; flush status; set autocommit=0; create table t1 (a int not null) type=innodb; insert into t1 values (1),(2),(3); select * from t1; a 1 2 3 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 drop table t1; commit; set autocommit=1; begin; create table t1 (a int not null) type=innodb; insert into t1 values (1),(2),(3); select * from t1; a 1 2 3 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 drop table t1; commit; create table t1 (a int not null) type=innodb; create table t2 (a int not null) type=innodb; create table t3 (a int not null) type=innodb; insert into t1 values (1),(2); insert into t2 values (1),(2); insert into t3 values (1),(2); select * from t1; a 1 2 select * from t2; a 1 2 select * from t3; a 1 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 3 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 begin; select * from t1; a 1 2 select * from t2; a 1 2 select * from t3; a 1 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 3 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 insert into t1 values (3); insert into t2 values (3); insert into t1 values (4); select * from t1; a 1 2 3 4 select * from t2; a 1 2 3 select * from t3; a 1 2 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 3 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 commit; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 drop table if exists t1; CREATE TABLE t1 (id int(11) NOT NULL auto_increment, PRIMARY KEY (id)) TYPE=InnoDB; select count(*) from t1; count(*) 0 insert into t1 (id) values (0); select count(*) from t1; count(*) 1 drop table t1;