1set default_storage_engine='tokudb';
2drop table if exists t;
3CREATE TABLE `t` (
4`num` int(10) unsigned NOT NULL auto_increment,
5`val` varchar(32) DEFAULT NULL,
6PRIMARY KEY (`num`)
7) PARTITION BY RANGE (num)
8(PARTITION p0 VALUES LESS THAN (100000),
9PARTITION p1 VALUES LESS THAN (200000),
10PARTITION p2 VALUES LESS THAN (300000),
11PARTITION p3 VALUES LESS THAN (400000),
12PARTITION p4 VALUES LESS THAN (500000),
13PARTITION p5 VALUES LESS THAN (600000),
14PARTITION p6 VALUES LESS THAN (700000),
15PARTITION p7 VALUES LESS THAN MAXVALUE);
16INSERT INTO t values (null,null);
17INSERT INTO t SELECT null,val FROM t;
18INSERT INTO t SELECT null,val FROM t;
19INSERT INTO t SELECT null,val FROM t;
20INSERT INTO t SELECT null,val FROM t;
21INSERT INTO t SELECT null,val FROM t;
22INSERT INTO t SELECT null,val FROM t;
23INSERT INTO t SELECT null,val FROM t;
24INSERT INTO t SELECT null,val FROM t;
25INSERT INTO t SELECT null,val FROM t;
26INSERT INTO t SELECT null,val FROM t;
27INSERT INTO t SELECT null,val FROM t;
28INSERT INTO t SELECT null,val FROM t;
29INSERT INTO t SELECT null,val FROM t;
30INSERT INTO t SELECT null,val FROM t;
31INSERT INTO t SELECT null,val FROM t;
32INSERT INTO t SELECT null,val FROM t;
33INSERT INTO t SELECT null,val FROM t;
34INSERT INTO t SELECT null,val FROM t;
35INSERT INTO t SELECT null,val FROM t;
36INSERT INTO t SELECT null,val FROM t;
37SELECT count(*) FROM t;
38count(*)
391048576
40set tokudb_bulk_fetch=ON;
41SELECT count(*) from t;
42count(*)
431048576
44SELECT count(*) from t;
45count(*)
461048576
47SELECT count(*) from t;
48count(*)
491048576
50SELECT count(*) from t;
51count(*)
521048576
53SELECT count(*) from t;
54count(*)
551048576
56SELECT count(*) from t;
57count(*)
581048576
59SELECT count(*) from t;
60count(*)
611048576
62SELECT count(*) from t;
63count(*)
641048576
65SELECT count(*) from t;
66count(*)
671048576
68SELECT count(*) from t;
69count(*)
701048576
71SELECT count(*) from t;
72count(*)
731048576
74SELECT count(*) from t;
75count(*)
761048576
77SELECT count(*) from t;
78count(*)
791048576
80SELECT count(*) from t;
81count(*)
821048576
83SELECT count(*) from t;
84count(*)
851048576
86SELECT count(*) from t;
87count(*)
881048576
89SELECT count(*) from t;
90count(*)
911048576
92SELECT count(*) from t;
93count(*)
941048576
95SELECT count(*) from t;
96count(*)
971048576
98SELECT count(*) from t;
99count(*)
1001048576
101SELECT count(*) from t;
102count(*)
1031048576
104SELECT count(*) from t;
105count(*)
1061048576
107SELECT count(*) from t;
108count(*)
1091048576
110SELECT count(*) from t;
111count(*)
1121048576
113SELECT count(*) from t;
114count(*)
1151048576
116SELECT count(*) from t;
117count(*)
1181048576
119SELECT count(*) from t;
120count(*)
1211048576
122SELECT count(*) from t;
123count(*)
1241048576
125SELECT count(*) from t;
126count(*)
1271048576
128SELECT count(*) from t;
129count(*)
1301048576
131set tokudb_bulk_fetch=OFF;
132SELECT count(*) from t;
133count(*)
1341048576
135SELECT count(*) from t;
136count(*)
1371048576
138SELECT count(*) from t;
139count(*)
1401048576
141SELECT count(*) from t;
142count(*)
1431048576
144SELECT count(*) from t;
145count(*)
1461048576
147SELECT count(*) from t;
148count(*)
1491048576
150SELECT count(*) from t;
151count(*)
1521048576
153SELECT count(*) from t;
154count(*)
1551048576
156SELECT count(*) from t;
157count(*)
1581048576
159SELECT count(*) from t;
160count(*)
1611048576
162SELECT count(*) from t;
163count(*)
1641048576
165SELECT count(*) from t;
166count(*)
1671048576
168SELECT count(*) from t;
169count(*)
1701048576
171SELECT count(*) from t;
172count(*)
1731048576
174SELECT count(*) from t;
175count(*)
1761048576
177SELECT count(*) from t;
178count(*)
1791048576
180SELECT count(*) from t;
181count(*)
1821048576
183SELECT count(*) from t;
184count(*)
1851048576
186SELECT count(*) from t;
187count(*)
1881048576
189SELECT count(*) from t;
190count(*)
1911048576
192SELECT count(*) from t;
193count(*)
1941048576
195SELECT count(*) from t;
196count(*)
1971048576
198SELECT count(*) from t;
199count(*)
2001048576
201SELECT count(*) from t;
202count(*)
2031048576
204SELECT count(*) from t;
205count(*)
2061048576
207SELECT count(*) from t;
208count(*)
2091048576
210SELECT count(*) from t;
211count(*)
2121048576
213SELECT count(*) from t;
214count(*)
2151048576
216SELECT count(*) from t;
217count(*)
2181048576
219SELECT count(*) from t;
220count(*)
2211048576
2221
223set tokudb_bulk_fetch=ON;
224SELECT count(*) from t where num > 700000;
225count(*)
226348576
227SELECT count(*) from t where num > 700000;
228count(*)
229348576
230SELECT count(*) from t where num > 700000;
231count(*)
232348576
233SELECT count(*) from t where num > 700000;
234count(*)
235348576
236SELECT count(*) from t where num > 700000;
237count(*)
238348576
239SELECT count(*) from t where num > 700000;
240count(*)
241348576
242SELECT count(*) from t where num > 700000;
243count(*)
244348576
245SELECT count(*) from t where num > 700000;
246count(*)
247348576
248SELECT count(*) from t where num > 700000;
249count(*)
250348576
251SELECT count(*) from t where num > 700000;
252count(*)
253348576
254SELECT count(*) from t where num > 700000;
255count(*)
256348576
257SELECT count(*) from t where num > 700000;
258count(*)
259348576
260SELECT count(*) from t where num > 700000;
261count(*)
262348576
263SELECT count(*) from t where num > 700000;
264count(*)
265348576
266SELECT count(*) from t where num > 700000;
267count(*)
268348576
269SELECT count(*) from t where num > 700000;
270count(*)
271348576
272SELECT count(*) from t where num > 700000;
273count(*)
274348576
275SELECT count(*) from t where num > 700000;
276count(*)
277348576
278SELECT count(*) from t where num > 700000;
279count(*)
280348576
281SELECT count(*) from t where num > 700000;
282count(*)
283348576
284SELECT count(*) from t where num > 700000;
285count(*)
286348576
287SELECT count(*) from t where num > 700000;
288count(*)
289348576
290SELECT count(*) from t where num > 700000;
291count(*)
292348576
293SELECT count(*) from t where num > 700000;
294count(*)
295348576
296SELECT count(*) from t where num > 700000;
297count(*)
298348576
299SELECT count(*) from t where num > 700000;
300count(*)
301348576
302SELECT count(*) from t where num > 700000;
303count(*)
304348576
305SELECT count(*) from t where num > 700000;
306count(*)
307348576
308SELECT count(*) from t where num > 700000;
309count(*)
310348576
311SELECT count(*) from t where num > 700000;
312count(*)
313348576
314set tokudb_bulk_fetch=OFF;
315SELECT count(*) from t where num > 700000;
316count(*)
317348576
318SELECT count(*) from t where num > 700000;
319count(*)
320348576
321SELECT count(*) from t where num > 700000;
322count(*)
323348576
324SELECT count(*) from t where num > 700000;
325count(*)
326348576
327SELECT count(*) from t where num > 700000;
328count(*)
329348576
330SELECT count(*) from t where num > 700000;
331count(*)
332348576
333SELECT count(*) from t where num > 700000;
334count(*)
335348576
336SELECT count(*) from t where num > 700000;
337count(*)
338348576
339SELECT count(*) from t where num > 700000;
340count(*)
341348576
342SELECT count(*) from t where num > 700000;
343count(*)
344348576
345SELECT count(*) from t where num > 700000;
346count(*)
347348576
348SELECT count(*) from t where num > 700000;
349count(*)
350348576
351SELECT count(*) from t where num > 700000;
352count(*)
353348576
354SELECT count(*) from t where num > 700000;
355count(*)
356348576
357SELECT count(*) from t where num > 700000;
358count(*)
359348576
360SELECT count(*) from t where num > 700000;
361count(*)
362348576
363SELECT count(*) from t where num > 700000;
364count(*)
365348576
366SELECT count(*) from t where num > 700000;
367count(*)
368348576
369SELECT count(*) from t where num > 700000;
370count(*)
371348576
372SELECT count(*) from t where num > 700000;
373count(*)
374348576
375SELECT count(*) from t where num > 700000;
376count(*)
377348576
378SELECT count(*) from t where num > 700000;
379count(*)
380348576
381SELECT count(*) from t where num > 700000;
382count(*)
383348576
384SELECT count(*) from t where num > 700000;
385count(*)
386348576
387SELECT count(*) from t where num > 700000;
388count(*)
389348576
390SELECT count(*) from t where num > 700000;
391count(*)
392348576
393SELECT count(*) from t where num > 700000;
394count(*)
395348576
396SELECT count(*) from t where num > 700000;
397count(*)
398348576
399SELECT count(*) from t where num > 700000;
400count(*)
401348576
402SELECT count(*) from t where num > 700000;
403count(*)
404348576
4051
406drop table t;
407