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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
# Bug#20205934 - ENABLE VALGRIND FOR MEMCACHED TESTS
source include/not_valgrind.inc;
source include/have_memcached_plugin.inc;
# Memcached SDI APIs are enabled only for debug version
source include/have_debug.inc;
# This test uses external $MYSQL client tool to create table
# with large number of columns(999) from a .sql file.
--disable_query_log
CALL mtr.add_suppression("daemon-memcached-w-batch-size': unsigned");
CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
CALL mtr.add_suppression("Warning: MySQL is trying to drop");
# Create the memcached tables
source include/memcache_config.inc;
--enable_query_log
INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
'innodb_only', 'innodb_only', 'innodb_only');
INSERT INTO config_options VALUES('separator', '|');
# describe table for memcache
INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t2', 'test', 't2',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t3', 'test', 't3',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t4', 'test', 't4',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t5', 'test', 't5',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t6', 'test', 't6',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
INSERT INTO containers VALUES ('desc_t7', 'test', 't7',
'c1', 'c2', '0', '0', '0', 'PRIMARY');
USE test;
let MEMCACHED_PORT=11286;
--let $memcached_address=127.0.0.1:11286
SET GLOBAL innodb_file_per_table=OFF;
--source ../include/sdi_create_alter.inc
SET GLOBAL innodb_file_per_table=ON;
--source ../include/sdi_create_alter.inc
--echo # Create compressed table
CREATE TABLE t6 (c1 INT PRIMARY KEY,
c2 VARCHAR(30),
c3 FLOAT,
KEY idx1(c3),
KEY idx2(c2(20)))
ENGINE = INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
# Tables must exist before plugin can be started!
--source ../include/load_daemon_memcached_expecting_success.inc
let TABLE_NAME = t6;
let MEMCACHED_TABLE_MAPPING = desc_t6;
--source ../include/sdi_insert_get_row.inc
DROP TABLE t6;
--echo # Create SDI in General tablespace
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
CREATE TABLE t6 (c1 INT PRIMARY KEY,
c2 VARCHAR(30),
c3 FLOAT,
KEY idx1(c3),
KEY idx2(c2(20)))
ENGINE = INNODB TABLESPACE=ts1;
let TABLE_NAME = t6;
let MEMCACHED_TABLE_MAPPING = desc_t6;
--source ../include/sdi_insert_get_row.inc
DROP TABLE t6;
DROP TABLESPACE ts1;
DROP DATABASE innodb_memcache;
# Stop plugin before innodb_memcached configuration
UNINSTALL PLUGIN daemon_memcached;
SET GLOBAL innodb_file_per_table = default;
|
