Debian Codegraph @

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

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