blob: a46bad2dbdcf7a7bf624f66831abb16e47673c7e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
set global query_cache_size= 16*1024*1024;
set global query_cache_type= 1;
create table t1 (i int) engine=innodb;
create table t2 (i int) engine=federated
CONNECTION="mysql://root@localhost:MASTER_MYPORT/test/t1";
select * from t2;
i
# restart
drop table t2;
drop table t1;
set global query_cache_type= default;
set global query_cache_size= default;
|
