Debian Codegraph @

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

raw
1 SET @auto_commit= @@global.autocommit;
2 SET @innodb_lock_wait_timeout_old=@@global.innodb_lock_wait_timeout;
3 SET @@global.innodb_lock_wait_timeout=1;
4 SET @lock_wait_timeout_old=@@global.lock_wait_timeout;
5 SET @@global.lock_wait_timeout=1;
6 SET @@global.autocommit=0;
7 SET @transaction_isolation= @@global.transaction_isolation;
8 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
9 SET @wait= @@global.wait_timeout;
10 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
11 "innodb_only", "innodb_only", "innodb_only");
12 INSERT INTO config_options VALUES("separator", "|");
13 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
14 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
15 CREATE USER mysqltest1@localhost;
16 COMMIT;
17 connect mysqltest1,localhost,mysqltest1,,;
18 connection mysqltest1;
19 USE test;
20 DROP TABLE IF EXISTS t1;
21 CREATE TABLE t1 (c1 VARCHAR(32),
22 c2 VARCHAR(1024),
23 c21 VARCHAR(1024),
24 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
25 ENGINE = INNODB;
26 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
27 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
28 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
29 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
30 COMMIT;
31 connection default;
32 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
33 Warnings:
34 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
35 SELECT @@global.daemon_memcached_r_batch_size;
36 @@global.daemon_memcached_r_batch_size
37 6
38 SET @@global.daemon_memcached_r_batch_size=100;
39 ERROR HY000: Variable 'daemon_memcached_r_batch_size' is a read only variable
40 connection mysqltest1;
41 SELECT c1,c2,c21 FROM t1;
42 c1 c2 c21
43 B Berlin Mitte
44 C Cottbus West
45 D Darmstadt City
46 H Hamburg Norderstedt
47 COMMIT;
48 connection default;
49 Here are the memcached results:
50 Berlin|Mitte
51 Berlin|Mitte
52 Berlin|Mitte
53 Cottbus|West
54 Berlin|Mitte
55 Cottbus|West
56 SELECT c1,c2,c21 FROM test.t1;
57 c1 c2 c21
58 B Berlin Mitte
59 C Cottbus West
60 D Darmstadt City
61 H Hamburg Norderstedt
62 connection mysqltest1;
63 SELECT c1,c2,c21 FROM t1 FOR UPDATE;
64 c1 c2 c21
65 B Berlin Mitte
66 C Cottbus West
67 D Darmstadt City
68 H Hamburg Norderstedt
69 ROLLBACK;
70 connection default;
71 Here are the memcached results:
72 Berlin|Mitte
73 Berlin|Mitte
74 Berlin|Mitte
75 Cottbus|West
76 Berlin|Mitte
77 Cottbus|West
78 Darmstadt|City
79 Darmstadt|City
80 Darmstadt|City
81 Darmstadt|City
82 Darmstadt|City
83 Darmstadt|City
84 SELECT c1,c2,c21 FROM test.t1;
85 c1 c2 c21
86 B Berlin Mitte
87 C Cottbus West
88 D Darmstadt City
89 H Hamburg Norderstedt
90 connection mysqltest1;
91 SELECT c1,c2,c21 FROM test.t1 FOR UPDATE;
92 c1 c2 c21
93 B Berlin Mitte
94 C Cottbus West
95 D Darmstadt City
96 H Hamburg Norderstedt
97 ROLLBACK;
98 connection default;
99 Here are the memcached results:
100 Darmstadt|City
101 Hamburg|Norderstedt
102 Darmstadt|City
103 Hamburg|Norderstedt
104 Darmstadt|City
105 SELECT c1,c2,c21 FROM test.t1;
106 c1 c2 c21
107 B Berlin Mitte
108 C Cottbus West
109 D Darmstadt City
110 H Hamburg Norderstedt
111 connection mysqltest1;
112 DROP TABLE test.t1;
113 COMMIT;
114 connection default;
115 disconnect mysqltest1;
116 UNINSTALL PLUGIN daemon_memcached;
117 DROP DATABASE innodb_memcache;
118 DROP USER mysqltest1@localhost;
119 SET @@global.transaction_isolation= @transaction_isolation;
120 SET @@global.autocommit=@auto_commit;
121 SET @@global.innodb_lock_wait_timeout=@innodb_lock_wait_timeout_old;
122 SET @@global.lock_wait_timeout=@lock_wait_timeout_old;