mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
12 lines
351 B
Text
12 lines
351 B
Text
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;
|