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 TEMPORARY TABLE t2 AS SELECT count(*) from t1;
34DROP TABLE t2;
35CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
36DROP TABLE t2;
37CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
38DROP TABLE t2;
39CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
40DROP TABLE t2;
41CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
42DROP TABLE t2;
43CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
44DROP TABLE t2;
45CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
46DROP TABLE t2;
47CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
48DROP TABLE t2;
49CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
50DROP TABLE t2;
51CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
52DROP TABLE t2;
53set tokudb_bulk_fetch=OFF;
54CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
55DROP TABLE t2;
56CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
57DROP TABLE t2;
58CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
59DROP TABLE t2;
60CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
61DROP TABLE t2;
62CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
63DROP TABLE t2;
64CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
65DROP TABLE t2;
66CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
67DROP TABLE t2;
68CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
69DROP TABLE t2;
70CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
71DROP TABLE t2;
72CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1;
73DROP TABLE t2;
741
75set tokudb_bulk_fetch=ON;
76CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
77DROP TABLE t2;
78CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
79DROP TABLE t2;
80CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
81DROP TABLE t2;
82CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
83DROP TABLE t2;
84CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
85DROP TABLE t2;
86CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
87DROP TABLE t2;
88CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
89DROP TABLE t2;
90CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
91DROP TABLE t2;
92CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
93DROP TABLE t2;
94CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
95DROP TABLE t2;
96CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
97DROP TABLE t2;
98CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
99DROP TABLE t2;
100CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
101DROP TABLE t2;
102CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
103DROP TABLE t2;
104CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
105DROP TABLE t2;
106CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
107DROP TABLE t2;
108CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
109DROP TABLE t2;
110CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
111DROP TABLE t2;
112CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
113DROP TABLE t2;
114CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
115DROP TABLE t2;
116CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
117DROP TABLE t2;
118CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
119DROP TABLE t2;
120CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
121DROP TABLE t2;
122CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
123DROP TABLE t2;
124CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
125DROP TABLE t2;
126CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
127DROP TABLE t2;
128CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
129DROP TABLE t2;
130CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
131DROP TABLE t2;
132CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
133DROP TABLE t2;
134CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
135DROP TABLE t2;
136set tokudb_bulk_fetch=OFF;
137CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
138DROP TABLE t2;
139CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
140DROP TABLE t2;
141CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
142DROP TABLE t2;
143CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
144DROP TABLE t2;
145CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
146DROP TABLE t2;
147CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
148DROP TABLE t2;
149CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
150DROP TABLE t2;
151CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
152DROP TABLE t2;
153CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
154DROP TABLE t2;
155CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
156DROP TABLE t2;
157CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
158DROP TABLE t2;
159CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
160DROP TABLE t2;
161CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
162DROP TABLE t2;
163CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
164DROP TABLE t2;
165CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
166DROP TABLE t2;
167CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
168DROP TABLE t2;
169CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
170DROP TABLE t2;
171CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
172DROP TABLE t2;
173CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
174DROP TABLE t2;
175CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
176DROP TABLE t2;
177CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
178DROP TABLE t2;
179CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
180DROP TABLE t2;
181CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
182DROP TABLE t2;
183CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
184DROP TABLE t2;
185CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
186DROP TABLE t2;
187CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
188DROP TABLE t2;
189CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
190DROP TABLE t2;
191CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
192DROP TABLE t2;
193CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
194DROP TABLE t2;
195CREATE TEMPORARY TABLE t2 AS SELECT count(*) from t1 where num > 700000;
196DROP TABLE t2;
1971
198drop table t1;
199