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

MySQL数据库

开发平台:

Visual C++

  1. set GLOBAL query_cache_size=1355776;
  2. drop database if exists MySQLtesT;
  3. create database MySQLtesT;
  4. create table MySQLtesT.t1 (a int);
  5. select * from MySQLtesT.t1;
  6. a
  7. show status like "Qcache_queries_in_cache";
  8. Variable_name Value
  9. Qcache_queries_in_cache 1
  10. drop database mysqltest;
  11. show status like "Qcache_queries_in_cache";
  12. Variable_name Value
  13. Qcache_queries_in_cache 0
  14. use MySQL;
  15. select * from db;
  16. show status like "Qcache_queries_in_cache";
  17. Variable_name Value
  18. Qcache_queries_in_cache 0
  19. use test;
  20. select * from MySQL.db;
  21. show status like "Qcache_queries_in_cache";
  22. Variable_name Value
  23. Qcache_queries_in_cache 0
  24. set GLOBAL query_cache_size=0;