1
DROP TABLE IF EXISTS `t1`;
2
set global query_cache_servers= "127.0.0.1:$MC_PORT";
3
CREATE TABLE `t1` (id integer NOT NULL auto_increment primary key, name varchar(20), age int);
4
INSERT INTO `t1` (name, age) values ("leila", 20);
5
INSERT INTO `t1` (name, age) values ("lockman", 2);
6
INSERT INTO `t1` (name, age) values ("ali", 22);
7
set query_cache_enable= ON;
18
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";
21
select query_cache_flush();
24
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";
26
select count(*) from data_dictionary.query_cache_entries d;
34
select count(*) from data_dictionary.query_cache_entries d;
37
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";