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