92 lines
2.6 KiB
Plaintext
92 lines
2.6 KiB
Plaintext
# 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;
|
|
|
|
--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');
|
|
|
|
USE test;
|
|
let MEMCACHED_PORT=11288;
|
|
|
|
--echo # 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';
|
|
|
|
# Tables must exist before plugin can be started!
|
|
--let $memcached_address=127.0.0.1:11288
|
|
--source ../include/load_daemon_memcached_expecting_success.inc
|
|
|
|
# Clear the current SDI in table
|
|
--let MEMCACHED_TABLE_MAPPING = desc_t1
|
|
--source ../include/sdi_drop_index.inc
|
|
--source ../include/sdi_create_index.inc
|
|
|
|
# Insert into SDI tables via memcached
|
|
--source ../include/sdi_insert_delete.inc
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
|
|
--echo # 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';
|
|
|
|
# Clear the current SDI in table
|
|
--source ../include/sdi_drop_index.inc
|
|
--source ../include/sdi_create_index.inc
|
|
|
|
# Insert into SDI tables via memcached
|
|
--source ../include/sdi_insert_delete.inc
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
|
|
--echo # 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';
|
|
|
|
# Clear the current SDI in table
|
|
--source ../include/sdi_drop_index.inc
|
|
--source ../include/sdi_create_index.inc
|
|
|
|
--source ../include/sdi_insert_delete.inc
|
|
|
|
SET DEBUG = '+d, skip_sdi';
|
|
DROP TABLE t1;
|
|
DROP TABLESPACE ts1;
|
|
SET DEBUG = '-d, skip_sdi';
|
|
|
|
# Stop plugin before innodb_memcached configuration
|
|
UNINSTALL PLUGIN daemon_memcached;
|
|
DROP DATABASE innodb_memcache;
|