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) PARTITION BY HASH (num) PARTITIONS 8; 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; 53CREATE TABLE t2 AS SELECT count(*) from t1; 54DROP TABLE t2; 55CREATE TABLE t2 AS SELECT count(*) from t1; 56DROP TABLE t2; 57CREATE TABLE t2 AS SELECT count(*) from t1; 58DROP TABLE t2; 59CREATE TABLE t2 AS SELECT count(*) from t1; 60DROP TABLE t2; 61CREATE TABLE t2 AS SELECT count(*) from t1; 62DROP TABLE t2; 63CREATE TABLE t2 AS SELECT count(*) from t1; 64DROP TABLE t2; 65CREATE TABLE t2 AS SELECT count(*) from t1; 66DROP TABLE t2; 67CREATE TABLE t2 AS SELECT count(*) from t1; 68DROP TABLE t2; 69CREATE TABLE t2 AS SELECT count(*) from t1; 70DROP TABLE t2; 71CREATE TABLE t2 AS SELECT count(*) from t1; 72DROP TABLE t2; 73set tokudb_bulk_fetch=OFF; 74CREATE TABLE t2 AS SELECT count(*) from t1; 75DROP TABLE t2; 76CREATE TABLE t2 AS SELECT count(*) from t1; 77DROP TABLE t2; 78CREATE TABLE t2 AS SELECT count(*) from t1; 79DROP TABLE t2; 80CREATE TABLE t2 AS SELECT count(*) from t1; 81DROP TABLE t2; 82CREATE TABLE t2 AS SELECT count(*) from t1; 83DROP TABLE t2; 84CREATE TABLE t2 AS SELECT count(*) from t1; 85DROP TABLE t2; 86CREATE TABLE t2 AS SELECT count(*) from t1; 87DROP TABLE t2; 88CREATE TABLE t2 AS SELECT count(*) from t1; 89DROP TABLE t2; 90CREATE TABLE t2 AS SELECT count(*) from t1; 91DROP TABLE t2; 92CREATE TABLE t2 AS SELECT count(*) from t1; 93DROP TABLE t2; 94CREATE TABLE t2 AS SELECT count(*) from t1; 95DROP TABLE t2; 96CREATE TABLE t2 AS SELECT count(*) from t1; 97DROP TABLE t2; 98CREATE TABLE t2 AS SELECT count(*) from t1; 99DROP TABLE t2; 100CREATE TABLE t2 AS SELECT count(*) from t1; 101DROP TABLE t2; 102CREATE TABLE t2 AS SELECT count(*) from t1; 103DROP TABLE t2; 104CREATE TABLE t2 AS SELECT count(*) from t1; 105DROP TABLE t2; 106CREATE TABLE t2 AS SELECT count(*) from t1; 107DROP TABLE t2; 108CREATE TABLE t2 AS SELECT count(*) from t1; 109DROP TABLE t2; 110CREATE TABLE t2 AS SELECT count(*) from t1; 111DROP TABLE t2; 112CREATE TABLE t2 AS SELECT count(*) from t1; 113DROP TABLE t2; 1141 115set tokudb_bulk_fetch=ON; 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; 136CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 137DROP TABLE t2; 138CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 139DROP TABLE t2; 140CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 141DROP TABLE t2; 142CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 143DROP TABLE t2; 144CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 145DROP TABLE t2; 146CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 147DROP TABLE t2; 148CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 149DROP TABLE t2; 150CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 151DROP TABLE t2; 152CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 153DROP TABLE t2; 154CREATE TABLE t2 AS SELECT count(*) from t1 where num > 700000; 155DROP TABLE t2; 156set tokudb_bulk_fetch=OFF; 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