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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
SET @transaction_isolation= @@global.transaction_isolation;
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
"innodb_only", "innodb_only", "innodb_only");
INSERT INTO config_options VALUES("separator", "|");
INSERT INTO containers VALUES ("desc_t1", "test", "t1",
"c1", "c2,c21,c22,c23,c24,c25", "c3", "c4", "c5", "PRIMARY");
USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 VARCHAR(32),
c2 VARCHAR(40),
c21 VARCHAR(40),
c22 VARCHAR(40),
c23 VARCHAR(40),
c24 VARCHAR(40),
c25 VARCHAR(40),
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
ENGINE = INNODB DEFAULT CHARSET UTF8;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
INSERT INTO t1 VALUES ('M', 'München', 'Süd', '4', 'ÜÖÄßüöä', '4567', '2012', 0, 0, 0);
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
Warnings:
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` varchar(32) NOT NULL,
`c2` varchar(40) DEFAULT NULL,
`c21` varchar(40) DEFAULT NULL,
`c22` varchar(40) DEFAULT NULL,
`c23` varchar(40) DEFAULT NULL,
`c24` varchar(40) DEFAULT NULL,
`c25` varchar(40) DEFAULT NULL,
`c3` int DEFAULT NULL,
`c4` bigint unsigned DEFAULT NULL,
`c5` int DEFAULT NULL,
PRIMARY KEY (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
Here are the memcached results with D,B,M,C:
Darmstadt|City|1|dddddddddddddd|1234|2012
Berlin|Mitte|2|bbbbbbbbbbbbbb|2345|2012
München|Süd|4|ÜÖÄßüöä|4567|2012
Cottbus|West|3|cccccccccccccc|3456|2012
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
Here are the memcached results after set:
Ülzen|City|5|üöäßÜÖÄ|5678|2012
Beijing|City|6|fffffffff|6789|2012
Shanghai|City|7|fffffffff|7890|2012
Wuhan|City|8|eeeeeeeee|8901|2012
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
Shanghai City 7 fffffffff 7890 2012
01234567890123456789012345678901 Wuhan City 8 eeeeeeeee 8901 2012
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
_ Beijing City 6 fffffffff 6789 2012
Ü Ülzen City 5 üöäßÜÖÄ 5678 2012
DROP TABLE t1;
UNINSTALL PLUGIN daemon_memcached;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 CHAR(32),
c2 CHAR(40),
c21 CHAR(40),
c22 CHAR(40),
c23 CHAR(40),
c24 CHAR(40),
c25 CHAR(40),
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
ENGINE = INNODB DEFAULT CHARSET UTF8;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
INSERT INTO t1 VALUES ('M', 'München', 'Süd', '4', 'ÜÖÄßüöä', '4567', '2012', 0, 0, 0);
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
Warnings:
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` char(32) NOT NULL,
`c2` char(40) DEFAULT NULL,
`c21` char(40) DEFAULT NULL,
`c22` char(40) DEFAULT NULL,
`c23` char(40) DEFAULT NULL,
`c24` char(40) DEFAULT NULL,
`c25` char(40) DEFAULT NULL,
`c3` int DEFAULT NULL,
`c4` bigint unsigned DEFAULT NULL,
`c5` int DEFAULT NULL,
PRIMARY KEY (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
Here are the memcached results with D,B,M,C:
Darmstadt |City |1 |dddddddddddddd |1234 |2012
Berlin |Mitte |2 |bbbbbbbbbbbbbb |2345 |2012
München |Süd |4 |ÜÖÄßüöä |4567 |2012
Cottbus |West |3 |cccccccccccccc |3456 |2012
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
Here are the memcached results after set:
Ülzen |City |5 |üöäßÜÖÄ |5678 |2012
Beijing |City |6 |fffffffff |6789 |2012
Shanghai |City |7 |fffffffff |7890 |2012
Wuhan |City |8 |eeeeeeeee |8901 |2012
SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
c1 c2 c21 c22 c23 c24 c25
Shanghai City 7 fffffffff 7890 2012
01234567890123456789012345678901 Wuhan City 8 eeeeeeeee 8901 2012
B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
C Cottbus West 3 cccccccccccccc 3456 2012
D Darmstadt City 1 dddddddddddddd 1234 2012
M München Süd 4 ÜÖÄßüöä 4567 2012
_ Beijing City 6 fffffffff 6789 2012
Ü Ülzen City 5 üöäßÜÖÄ 5678 2012
DROP TABLE t1;
UNINSTALL PLUGIN daemon_memcached;
DROP DATABASE innodb_memcache;
SET @@global.transaction_isolation= @transaction_isolation;
|
