📄 ndb_cache_multi.result
字号:
drop table if exists t1, t2;set GLOBAL query_cache_type=on;set GLOBAL query_cache_size=1355776;reset query cache;flush status;set GLOBAL query_cache_type=on;set GLOBAL query_cache_size=1355776;reset query cache;flush status;create table t1 (a int) engine=ndbcluster;create table t2 (a int) engine=ndbcluster;insert into t1 value (2);insert into t2 value (3);select * from t1;a2select * from t2;a3show status like "Qcache_queries_in_cache";Variable_name ValueQcache_queries_in_cache 2show status like "Qcache_inserts";Variable_name ValueQcache_inserts 2show status like "Qcache_hits";Variable_name ValueQcache_hits 0show status like "Qcache_queries_in_cache";Variable_name ValueQcache_queries_in_cache 0show status like "Qcache_inserts";Variable_name ValueQcache_inserts 0show status like "Qcache_hits";Variable_name ValueQcache_hits 0select * from t1;a2show status like "Qcache_queries_in_cache";Variable_name ValueQcache_queries_in_cache 1show status like "Qcache_inserts";Variable_name ValueQcache_inserts 1show status like "Qcache_hits";Variable_name ValueQcache_hits 0update t1 set a=3 where a=2;show status like "Qcache_queries_in_cache";Variable_name ValueQcache_queries_in_cache 2show status like "Qcache_inserts";Variable_name ValueQcache_inserts 2show status like "Qcache_hits";Variable_name ValueQcache_hits 0select * from t1;a3show status like "Qcache_queries_in_cache";Variable_name ValueQcache_queries_in_cache 2show status like "Qcache_inserts";Variable_name ValueQcache_inserts 3show status like "Qcache_hits";Variable_name ValueQcache_hits 0drop table t1, t2;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -