Debian Codegraph @

mysql-test/suite/memcached/r/memc288_set_sdi.result

raw
1 INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
2 'innodb_only', 'innodb_only', 'innodb_only');
3 INSERT INTO config_options VALUES('separator', '|');
4 INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
5 'c1', 'c2', '0', '0', '0', 'PRIMARY');
6 USE test;
7 # Case 1. Test with uncompressed tables;
8 SET DEBUG = '+d, skip_sdi';
9 CREATE TABLE t1(c1 VARCHAR(32),
10 c2 VARCHAR(1024),
11 primary key(c1))
12 ENGINE = INNODB;
13 SET DEBUG = '-d, skip_sdi';
14 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
15 Warnings:
16 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
17 1. Insert Small data
18 2. Insert Large data. Will be stored in external pages
19 3. Move off-page to in-page
20 4. Move in-page to off-page
21 5. Insert 1000 rows and delete
22 SET DEBUG = '+d, skip_sdi';
23 DROP TABLE t1;
24 SET DEBUG = '-d, skip_sdi';
25 # Case 2. Test with Compressed tables
26 SET DEBUG = '+d, skip_sdi';
27 CREATE TABLE t1(c1 VARCHAR(32),
28 c2 VARCHAR(1024),
29 primary key(c1))
30 ENGINE = INNODB KEY_BLOCK_SIZE=1 ROW_FORMAT=COMPRESSED;
31 SET DEBUG = '-d, skip_sdi';
32 1. Insert Small data
33 2. Insert Large data. Will be stored in external pages
34 3. Move off-page to in-page
35 4. Move in-page to off-page
36 5. Insert 1000 rows and delete
37 SET DEBUG = '+d, skip_sdi';
38 DROP TABLE t1;
39 SET DEBUG = '-d, skip_sdi';
40 # Case 3. Test with General tablespaces
41 SET DEBUG = '+d, skip_sdi';
42 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
43 CREATE TABLE t1(c1 VARCHAR(32),
44 c2 VARCHAR(1024),
45 primary key(c1))
46 ENGINE = INNODB TABLESPACE=ts1;
47 SET DEBUG = '-d, skip_sdi';
48 1. Insert Small data
49 2. Insert Large data. Will be stored in external pages
50 3. Move off-page to in-page
51 4. Move in-page to off-page
52 5. Insert 1000 rows and delete
53 SET DEBUG = '+d, skip_sdi';
54 DROP TABLE t1;
55 DROP TABLESPACE ts1;
56 SET DEBUG = '-d, skip_sdi';
57 UNINSTALL PLUGIN daemon_memcached;
58 DROP DATABASE innodb_memcache;