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
|
# 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");
# We wiped out entire SDI created by Server. This is to avoid server
# SDI interference with memcached inserted SDI. So server complains
# on missing SDI
CALL mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* sdi_delete*");
# 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=11291;
CREATE TABLE t1(c1 VARCHAR(32),
c2 VARCHAR(1024),
primary key(c1))
ENGINE = INNODB;
# Tables must exist before plugin can be started!
--let $memcached_address=127.0.0.1:11291
--source ../include/load_daemon_memcached_expecting_success.inc
# Case 1: Purge before restart of server
# 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 and Delete in SDI table via memcached
--source ../include/sdi_insert_delete.inc
# Finish the purge before restart
SET GLOBAL innodb_fast_shutdown=0;
--source include/restart_mysqld.inc
--let $memcached_check_attempts=20
--let $memcached_expect=success
--source ../include/check_daemon_memcached.inc
# Case 2: Purge after kill & restart
# Insert and Delete in DD_INFO table via memcached
--source ../include/sdi_insert_delete.inc
# Kill and restart
--source include/kill_and_restart_mysqld.inc
--let $memcached_check_attempts=20
--let $memcached_expect=success
--source ../include/check_daemon_memcached.inc
# Finish the purge
SET GLOBAL innodb_fast_shutdown=0;
--source include/restart_mysqld.inc
--let $memcached_check_attempts=20
--let $memcached_expect=success
--source ../include/check_daemon_memcached.inc
# Stop plugin before innodb_memcached configuration
UNINSTALL PLUGIN daemon_memcached;
DROP TABLE t1;
DROP DATABASE innodb_memcache;
|
