bdb_cache.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- drop table if exists t1, t2, t3;
- flush status;
- set autocommit=0;
- create table t1 (a int not null) engine=bdb;
- 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;
- set autocommit=1;
- create table t1 (a int not null) engine=bdb;
- begin;
- 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;
- create table t1 (a int not null) engine=bdb;
- create table t2 (a int not null) engine=bdb;
- create table t3 (a int not null) engine=bdb;
- 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, t2, t3;