57 lines
1.7 KiB
Plaintext
57 lines
1.7 KiB
Plaintext
INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
|
|
'innodb_only', 'innodb_only', 'innodb_only');
|
|
INSERT INTO config_options VALUES('separator', '|');
|
|
INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
|
|
'c1', 'c2', '0', '0', '0', 'PRIMARY');
|
|
USE test;
|
|
# Case 1. Test with uncompressed tables;
|
|
SET DEBUG = '+d, skip_sdi';
|
|
CREATE TABLE t1(c1 VARCHAR(32),
|
|
c2 VARCHAR(1024),
|
|
primary key(c1))
|
|
ENGINE = INNODB;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
|
|
1. Insert Small data
|
|
2. Insert Large data. Will be stored in external pages
|
|
3. Move off-page to in-page
|
|
4. Move in-page to off-page
|
|
5. Insert 1000 rows and delete
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
# Case 2. Test with Compressed tables
|
|
SET DEBUG = '+d, skip_sdi';
|
|
CREATE TABLE t1(c1 VARCHAR(32),
|
|
c2 VARCHAR(1024),
|
|
primary key(c1))
|
|
ENGINE = INNODB KEY_BLOCK_SIZE=1 ROW_FORMAT=COMPRESSED;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
1. Insert Small data
|
|
2. Insert Large data. Will be stored in external pages
|
|
3. Move off-page to in-page
|
|
4. Move in-page to off-page
|
|
5. Insert 1000 rows and delete
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
# Case 3. Test with General tablespaces
|
|
SET DEBUG = '+d, skip_sdi';
|
|
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
|
|
CREATE TABLE t1(c1 VARCHAR(32),
|
|
c2 VARCHAR(1024),
|
|
primary key(c1))
|
|
ENGINE = INNODB TABLESPACE=ts1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
1. Insert Small data
|
|
2. Insert Large data. Will be stored in external pages
|
|
3. Move off-page to in-page
|
|
4. Move in-page to off-page
|
|
5. Insert 1000 rows and delete
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
DROP TABLESPACE ts1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
UNINSTALL PLUGIN daemon_memcached;
|
|
DROP DATABASE innodb_memcache;
|