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