1
# we are assuming the memcached binary is contained in PATH or
2
# common directories we might expect it to be in
3
--exec sh ../plugin/memcached_query_cache/start_mc.sh stop
4
--exec sh ../plugin/memcached_query_cache/start_mc.sh start
7
DROP TABLE IF EXISTS `t1`;
10
--replace_result $MC_PORT MC_A_PORT
11
set global query_cache_servers= "127.0.0.1:$MC_PORT";
13
CREATE TABLE `t1` (id integer NOT NULL auto_increment primary key, name varchar(20), age int);
14
INSERT INTO `t1` (name, age) values ("leila", 20);
15
INSERT INTO `t1` (name, age) values ("lockman", 2);
16
INSERT INTO `t1` (name, age) values ("ali", 22);
18
set query_cache_enable= ON;
21
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";
22
select query_cache_flush();
23
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";
24
select count(*) from data_dictionary.query_cache_entries d;
26
select count(*) from data_dictionary.query_cache_entries d;
27
select d.schema, d.sql from data_dictionary.query_cache_entries d where d.sql like "select * from t1";
30
--exec sh ../plugin/memcached_query_cache/start_mc.sh stop