39 lines
1.5 KiB
Plaintext
39 lines
1.5 KiB
Plaintext
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';
|
|
DROP TABLE t1,t2;
|
|
UNINSTALL PLUGIN daemon_memcached;
|
|
DROP DATABASE innodb_memcache;
|
|
SET @@global.transaction_isolation= @transaction_isolation;
|