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