1set default_storage_engine='tokudb';
2drop table if exists t1,t2;
3CREATE TABLE `t1` (
4`num` int(10) unsigned auto_increment NOT NULL,
5`val` varchar(32) DEFAULT NULL,
6PRIMARY KEY (`num`)
7);
8INSERT INTO t1 values (null,null);
9INSERT INTO t1 SELECT null,val FROM t1;
10INSERT INTO t1 SELECT null,val FROM t1;
11INSERT INTO t1 SELECT null,val FROM t1;
12INSERT INTO t1 SELECT null,val FROM t1;
13INSERT INTO t1 SELECT null,val FROM t1;
14INSERT INTO t1 SELECT null,val FROM t1;
15INSERT INTO t1 SELECT null,val FROM t1;
16INSERT INTO t1 SELECT null,val FROM t1;
17INSERT INTO t1 SELECT null,val FROM t1;
18INSERT INTO t1 SELECT null,val FROM t1;
19INSERT INTO t1 SELECT null,val FROM t1;
20INSERT INTO t1 SELECT null,val FROM t1;
21INSERT INTO t1 SELECT null,val FROM t1;
22INSERT INTO t1 SELECT null,val FROM t1;
23INSERT INTO t1 SELECT null,val FROM t1;
24INSERT INTO t1 SELECT null,val FROM t1;
25INSERT INTO t1 SELECT null,val FROM t1;
26INSERT INTO t1 SELECT null,val FROM t1;
27INSERT INTO t1 SELECT null,val FROM t1;
28INSERT INTO t1 SELECT null,val FROM t1;
29SELECT count(*) FROM t1;
30count(*)
311048576
32set tokudb_bulk_fetch=ON;
33CREATE TABLE t2 AS SELECT count(*) from t1;
34DROP TABLE t2;
35CREATE TABLE t2 AS SELECT count(*) from t1;
36DROP TABLE t2;
37CREATE TABLE t2 AS SELECT count(*) from t1;
38DROP TABLE t2;
39CREATE TABLE t2 AS SELECT count(*) from t1;
40DROP TABLE t2;
41CREATE TABLE t2 AS SELECT count(*) from t1;
42DROP TABLE t2;
43CREATE TABLE t2 AS SELECT count(*) from t1;
44DROP TABLE t2;
45CREATE TABLE t2 AS SELECT count(*) from t1;
46DROP TABLE t2;
47CREATE TABLE t2 AS SELECT count(*) from t1;
48DROP TABLE t2;
49CREATE TABLE t2 AS SELECT count(*) from t1;
50DROP TABLE t2;
51CREATE TABLE t2 AS SELECT count(*) from t1;
52DROP TABLE t2;
53set tokudb_bulk_fetch=OFF;
54CREATE TABLE t2 AS SELECT count(*) from t1;
55DROP TABLE t2;
56CREATE TABLE t2 AS SELECT count(*) from t1;
57DROP TABLE t2;
58CREATE TABLE t2 AS SELECT count(*) from t1;
59DROP TABLE t2;
60CREATE TABLE t2 AS SELECT count(*) from t1;
61DROP TABLE t2;
62CREATE TABLE t2 AS SELECT count(*) from t1;
63DROP TABLE t2;
64CREATE TABLE t2 AS SELECT count(*) from t1;
65DROP TABLE t2;
66CREATE TABLE t2 AS SELECT count(*) from t1;
67DROP TABLE t2;
68CREATE TABLE t2 AS SELECT count(*) from t1;
69DROP TABLE t2;
70CREATE TABLE t2 AS SELECT count(*) from t1;
71DROP TABLE t2;
72CREATE TABLE t2 AS SELECT count(*) from t1;
73DROP TABLE t2;
741
75set tokudb_bulk_fetch=ON;
76CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
77DROP TABLE t2;
78CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
79DROP TABLE t2;
80CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
81DROP TABLE t2;
82CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
83DROP TABLE t2;
84CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
85DROP TABLE t2;
86CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
87DROP TABLE t2;
88CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
89DROP TABLE t2;
90CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
91DROP TABLE t2;
92CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
93DROP TABLE t2;
94CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
95DROP TABLE t2;
96CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
97DROP TABLE t2;
98CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
99DROP TABLE t2;
100CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
101DROP TABLE t2;
102CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
103DROP TABLE t2;
104CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
105DROP TABLE t2;
106CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
107DROP TABLE t2;
108CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
109DROP TABLE t2;
110CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
111DROP TABLE t2;
112CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
113DROP TABLE t2;
114CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
115DROP TABLE t2;
116CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
117DROP TABLE t2;
118CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
119DROP TABLE t2;
120CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
121DROP TABLE t2;
122CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
123DROP TABLE t2;
124CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
125DROP TABLE t2;
126CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
127DROP TABLE t2;
128CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
129DROP TABLE t2;
130CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
131DROP TABLE t2;
132CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
133DROP TABLE t2;
134CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
135DROP TABLE t2;
136set tokudb_bulk_fetch=OFF;
137CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
138DROP TABLE t2;
139CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
140DROP TABLE t2;
141CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
142DROP TABLE t2;
143CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
144DROP TABLE t2;
145CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
146DROP TABLE t2;
147CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
148DROP TABLE t2;
149CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
150DROP TABLE t2;
151CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
152DROP TABLE t2;
153CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
154DROP TABLE t2;
155CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
156DROP TABLE t2;
157CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
158DROP TABLE t2;
159CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
160DROP TABLE t2;
161CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
162DROP TABLE t2;
163CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
164DROP TABLE t2;
165CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
166DROP TABLE t2;
167CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
168DROP TABLE t2;
169CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
170DROP TABLE t2;
171CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
172DROP TABLE t2;
173CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
174DROP TABLE t2;
175CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
176DROP TABLE t2;
177CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
178DROP TABLE t2;
179CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
180DROP TABLE t2;
181CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
182DROP TABLE t2;
183CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
184DROP TABLE t2;
185CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
186DROP TABLE t2;
187CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
188DROP TABLE t2;
189CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
190DROP TABLE t2;
191CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
192DROP TABLE t2;
193CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
194DROP TABLE t2;
195CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000;
196DROP TABLE t2;
1971
198drop table t1;
199