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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
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';
Warnings:
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
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;
|
