Debian Codegraph @

mysql-test/suite/memcached/r/memc267_w_batch_5.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 Berlin|Mitte
41 Darmstadt|City
42 SELECT c1,c2,c21 FROM test.t1;
43 c1 c2 c21
44 B Berlin Mitte
45 D Darmstadt City
46 connection mysqltest1;
47 SELECT SLEEP(1);
48 SLEEP(1)
49 0
50 SELECT c1,c2,c21 FROM t1 FOR UPDATE;
51 c1 c2 c21
52 B Berlin Mitte
53 D Darmstadt City
54 ROLLBACK;
55 connection default;
56 Here are the memcached results:
57 München|Perlach
58 Nürnberg|Nord
59 Oldenburg|Friesland
60 SELECT c1,c2,c21 FROM test.t1;
61 c1 c2 c21
62 B Berlin Mitte
63 D Darmstadt City
64 M München Perlach
65 N Nürnberg Nord
66 O Oldenburg Friesland
67 connection mysqltest1;
68 SELECT SLEEP(1);
69 SLEEP(1)
70 0
71 SELECT c1,c2,c21 FROM test.t1 FOR UPDATE;
72 c1 c2 c21
73 B Berlin Mitte
74 D Darmstadt City
75 M München Perlach
76 N Nürnberg Nord
77 O Oldenburg Friesland
78 COMMIT;
79 connection default;
80 Here are the memcached results:
81 SELECT c1,c2,c21 FROM test.t1;
82 c1 c2 c21
83 B Berlin Mitte
84 D Darmstadt City
85 M München Perlach
86 N Nürnberg Nord
87 O Oldenburg Friesland
88 connection mysqltest1;
89 SELECT SLEEP(1);
90 SLEEP(1)
91 0
92 SELECT c1,c2,c21 FROM test.t1 FOR UPDATE;
93 c1 c2 c21
94 B Berlin Mitte
95 D Darmstadt City
96 M München Perlach
97 N Nürnberg Nord
98 O Oldenburg Friesland
99 DROP TABLE test.t1;
100 COMMIT;
101 connection default;
102 disconnect mysqltest1;
103 UNINSTALL PLUGIN daemon_memcached;
104 DROP DATABASE innodb_memcache;
105 DROP USER mysqltest1@localhost;
106 SET @@global.transaction_isolation= @transaction_isolation;
107 SET @@global.autocommit=@auto_commit;
108 SET @@global.lock_wait_timeout=@lock_wait;
109 SET @@global.innodb_lock_wait_timeout=@innodb_lock_wait;