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
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS foo;
create table foo (a int, b bigint, c int, primary key (a))engine=TokuDB;
insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500),(6,60,600);
select * from foo;
a b c
1 10 100
2 20 200
3 30 300
4 40 400
5 50 500
6 60 600
select a from foo;
a
1
2
3
4
5
6
select * from foo where a > 2;
a b c
3 30 300
4 40 400
5 50 500
6 60 600
select a from foo where a > 2;
a
3
4
5
6
select count(*) from foo;
count(*)
6
alter table foo add index b(b);
select b from foo;
b
10
20
30
40
50
60
explain select * from foo where b > 30;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE foo range b b 9 NULL 3 Using where
select * from foo where b > 30;
a b c
4 40 400
5 50 500
6 60 600
alter table foo drop index b;
alter table foo add index c(c) clustering=yes;
select c from foo;
c
100
200
300
400
500
600
explain select * from foo where c > 500;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE foo range c c 5 NULL 1 Using where; Using index
select * from foo where c > 500;
a b c
6 60 600
drop table foo;
create table foo (a int, b int);
insert into foo values (1,10),(2,20),(3,30),(4,40),(5,50),(6,60);
select * from foo;
a b
1 10
2 20
3 30
4 40
5 50
6 60
select a from foo;
a
1
2
3
4
5
6
select b from foo;
b
10
20
30
40
50
60
select count(*) from foo;
count(*)
6
drop table foo;
create table foo (a int, b varchar(10), c blob, d bigint, e varchar(10), f mediumblob)engine=TokuDB;
insert into foo values(1,"bb","ccccc",100,"eee","fffffffffffffffffffff");
select * from foo;
a b c d e f
1 bb ccccc 100 eee fffffffffffffffffffff
select a,d from foo;
a d
1 100
select b,e from foo;
b e
bb eee
select c,f from foo;
c f
ccccc fffffffffffffffffffff
select d from foo;
d
100
select e from foo;
e
eee
select f from foo;
f
fffffffffffffffffffff
select a from foo;
a
1
select b from foo;
b
bb
select c from foo;
c
ccccc
select b,c,e,f from foo;
b c e f
bb ccccc eee fffffffffffffffffffff
select a,b,d,e from foo;
a b d e
1 bb 100 eee
select a,d,c,f from foo;
a d c f
1 100 ccccc fffffffffffffffffffff
DROP TABLE foo;
|