ndb_cache.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- -- source include/have_query_cache.inc
- -- source include/have_ndb.inc
- -- source include/not_embedded.inc
- set GLOBAL query_cache_size=1355776;
- reset query cache;
- flush status;
- --disable_warnings
- drop table if exists t1,t2;
- --enable_warnings
- CREATE TABLE t1 (a int) ENGINE=ndbcluster;
- CREATE TABLE t2 (a int);
- select * from t1;
- show status like "Qcache_queries_in_cache";
- show status like "Qcache_inserts";
- show status like "Qcache_hits";
- select * from t2;
- show status like "Qcache_queries_in_cache";
- show status like "Qcache_inserts";
- show status like "Qcache_hits";
- select * from t1;
- select * from t2;
- show status like "Qcache_queries_in_cache";
- show status like "Qcache_inserts";
- show status like "Qcache_hits";
- drop table t1, t2;
- SET GLOBAL query_cache_size=0;
- # End of 4.1 tests