lowercase_table_qcache.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- set GLOBAL query_cache_size=1355776;
- drop database if exists MySQLtesT;
- create database MySQLtesT;
- create table MySQLtesT.t1 (a int);
- select * from MySQLtesT.t1;
- a
- show status like "Qcache_queries_in_cache";
- Variable_name Value
- Qcache_queries_in_cache 1
- drop database mysqltest;
- show status like "Qcache_queries_in_cache";
- Variable_name Value
- Qcache_queries_in_cache 0
- use MySQL;
- select * from db;
- show status like "Qcache_queries_in_cache";
- Variable_name Value
- Qcache_queries_in_cache 0
- use test;
- select * from MySQL.db;
- show status like "Qcache_queries_in_cache";
- Variable_name Value
- Qcache_queries_in_cache 0
- set GLOBAL query_cache_size=0;