1set default_storage_engine='tokudb'; 2drop table if exists t; 3CREATE TABLE `t` (id bigint not null auto_increment primary key, val bigint not null default 0); 4INSERT INTO t (id) values (null); 5INSERT INTO t SELECT null,val FROM t; 6INSERT INTO t SELECT null,val FROM t; 7INSERT INTO t SELECT null,val FROM t; 8INSERT INTO t SELECT null,val FROM t; 9INSERT INTO t SELECT null,val FROM t; 10INSERT INTO t SELECT null,val FROM t; 11INSERT INTO t SELECT null,val FROM t; 12INSERT INTO t SELECT null,val FROM t; 13INSERT INTO t SELECT null,val FROM t; 14INSERT INTO t SELECT null,val FROM t; 15INSERT INTO t SELECT null,val FROM t; 16INSERT INTO t SELECT null,val FROM t; 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; 28SELECT count(*) FROM t; 29count(*) 308388608 31set tokudb_bulk_fetch = ON; 32delete from t where val > 0; 33delete from t where val > 0; 34delete from t where val > 0; 35delete from t where val > 0; 36delete from t where val > 0; 37delete from t where val > 0; 38delete from t where val > 0; 39delete from t where val > 0; 40delete from t where val > 0; 41delete from t where val > 0; 42set tokudb_bulk_fetch = OFF; 43delete from t where val > 0; 44delete from t where val > 0; 45delete from t where val > 0; 46delete from t where val > 0; 47delete from t where val > 0; 48delete from t where val > 0; 49delete from t where val > 0; 50delete from t where val > 0; 51delete from t where val > 0; 52delete from t where val > 0; 531 54drop table t; 55