ndb_cache.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- set GLOBAL query_cache_size=1355776;
- reset query cache;
- flush status;
- drop table if exists t1,t2;
- CREATE TABLE t1 (a int) ENGINE=ndbcluster;
- CREATE TABLE t2 (a int);
- select * from t1;
- a
- 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 0
- show status like "Qcache_hits";
- Variable_name Value
- Qcache_hits 0
- select * from t2;
- a
- 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;
- a
- select * from t2;
- a
- 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 1
- drop table t1, t2;
- SET GLOBAL query_cache_size=0;