ndb_cache.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:

MySQL数据库

开发平台:

Visual C++

  1. set GLOBAL query_cache_size=1355776;
  2. reset query cache;
  3. flush status;
  4. drop table if exists t1,t2;
  5. CREATE TABLE t1 (a int) ENGINE=ndbcluster;
  6. CREATE TABLE t2 (a int);
  7. select * from t1;
  8. a
  9. show status like "Qcache_queries_in_cache";
  10. Variable_name Value
  11. Qcache_queries_in_cache 0
  12. show status like "Qcache_inserts";
  13. Variable_name Value
  14. Qcache_inserts 0
  15. show status like "Qcache_hits";
  16. Variable_name Value
  17. Qcache_hits 0
  18. select * from t2;
  19. a
  20. show status like "Qcache_queries_in_cache";
  21. Variable_name Value
  22. Qcache_queries_in_cache 1
  23. show status like "Qcache_inserts";
  24. Variable_name Value
  25. Qcache_inserts 1
  26. show status like "Qcache_hits";
  27. Variable_name Value
  28. Qcache_hits 0
  29. select * from t1;
  30. a
  31. select * from t2;
  32. a
  33. show status like "Qcache_queries_in_cache";
  34. Variable_name Value
  35. Qcache_queries_in_cache 1
  36. show status like "Qcache_inserts";
  37. Variable_name Value
  38. Qcache_inserts 1
  39. show status like "Qcache_hits";
  40. Variable_name Value
  41. Qcache_hits 1
  42. drop table t1, t2;
  43. SET GLOBAL query_cache_size=0;