1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
SET @transaction_isolation= @@global.transaction_isolation;
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
"innodb_only", "innodb_only", "innodb_only");
INSERT INTO config_options VALUES("separator", "|");
INSERT INTO config_options VALUES("table_map_delimiter", ".");
INSERT INTO containers VALUES ("desct1", "test", "t1", "c1", "c2", "c3", "c4", "c5", "PRIMARY");
INSERT INTO containers VALUES ("desct2", "test", "t2", "c1", "c2", "c3", "c4", "c5", "PRIMARY");
INSERT INTO containers VALUES ("desct3", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i1");
INSERT INTO containers VALUES ("desct4", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i2");
INSERT INTO containers VALUES ("desct5", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i3");
INSERT INTO containers VALUES ("desct6", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i4");
use test;
CREATE TABLE t1 (
c1 VARCHAR(32),
c2 VARCHAR(512),
c3 INT,
c4 BIGINT UNSIGNED,
c5 INT,
primary key(c1,c5)
) ENGINE = INNODB;
CREATE TABLE t2 (
c1 VARCHAR(32),
c2 VARCHAR(512),
c3 INT,
c4 BIGINT UNSIGNED,
c5 INT,
primary key(c3)
) ENGINE = INNODB;
CREATE INDEX i1 ON t1(c1);
CREATE UNIQUE INDEX i2 ON t1(c1,c5);
CREATE UNIQUE INDEX i3 ON t1(c5);
CREATE UNIQUE INDEX i4 ON t1(c1);
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
Warnings:
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
DROP TABLE t1,t2;
UNINSTALL PLUGIN daemon_memcached;
DROP DATABASE innodb_memcache;
SET @@global.transaction_isolation= @transaction_isolation;
|
