1set default_storage_engine='tokudb'; 2drop table if exists t; 3CREATE TABLE `t` ( 4`num` int(10) unsigned NOT NULL auto_increment, 5`val` varchar(32) DEFAULT NULL, 6PRIMARY KEY (`num`) 7) PARTITION BY RANGE (num) 8(PARTITION p0 VALUES LESS THAN (100000), 9PARTITION p1 VALUES LESS THAN (200000), 10PARTITION p2 VALUES LESS THAN (300000), 11PARTITION p3 VALUES LESS THAN (400000), 12PARTITION p4 VALUES LESS THAN (500000), 13PARTITION p5 VALUES LESS THAN (600000), 14PARTITION p6 VALUES LESS THAN (700000), 15PARTITION p7 VALUES LESS THAN MAXVALUE); 16INSERT INTO t values (null,null); 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; 28INSERT INTO t SELECT null,val FROM t; 29INSERT INTO t SELECT null,val FROM t; 30INSERT INTO t SELECT null,val FROM t; 31INSERT INTO t SELECT null,val FROM t; 32INSERT INTO t SELECT null,val FROM t; 33INSERT INTO t SELECT null,val FROM t; 34INSERT INTO t SELECT null,val FROM t; 35INSERT INTO t SELECT null,val FROM t; 36INSERT INTO t SELECT null,val FROM t; 37SELECT count(*) FROM t; 38count(*) 391048576 40set tokudb_bulk_fetch=ON; 41SELECT count(*) from t; 42count(*) 431048576 44SELECT count(*) from t; 45count(*) 461048576 47SELECT count(*) from t; 48count(*) 491048576 50SELECT count(*) from t; 51count(*) 521048576 53SELECT count(*) from t; 54count(*) 551048576 56SELECT count(*) from t; 57count(*) 581048576 59SELECT count(*) from t; 60count(*) 611048576 62SELECT count(*) from t; 63count(*) 641048576 65SELECT count(*) from t; 66count(*) 671048576 68SELECT count(*) from t; 69count(*) 701048576 71SELECT count(*) from t; 72count(*) 731048576 74SELECT count(*) from t; 75count(*) 761048576 77SELECT count(*) from t; 78count(*) 791048576 80SELECT count(*) from t; 81count(*) 821048576 83SELECT count(*) from t; 84count(*) 851048576 86SELECT count(*) from t; 87count(*) 881048576 89SELECT count(*) from t; 90count(*) 911048576 92SELECT count(*) from t; 93count(*) 941048576 95SELECT count(*) from t; 96count(*) 971048576 98SELECT count(*) from t; 99count(*) 1001048576 101SELECT count(*) from t; 102count(*) 1031048576 104SELECT count(*) from t; 105count(*) 1061048576 107SELECT count(*) from t; 108count(*) 1091048576 110SELECT count(*) from t; 111count(*) 1121048576 113SELECT count(*) from t; 114count(*) 1151048576 116SELECT count(*) from t; 117count(*) 1181048576 119SELECT count(*) from t; 120count(*) 1211048576 122SELECT count(*) from t; 123count(*) 1241048576 125SELECT count(*) from t; 126count(*) 1271048576 128SELECT count(*) from t; 129count(*) 1301048576 131set tokudb_bulk_fetch=OFF; 132SELECT count(*) from t; 133count(*) 1341048576 135SELECT count(*) from t; 136count(*) 1371048576 138SELECT count(*) from t; 139count(*) 1401048576 141SELECT count(*) from t; 142count(*) 1431048576 144SELECT count(*) from t; 145count(*) 1461048576 147SELECT count(*) from t; 148count(*) 1491048576 150SELECT count(*) from t; 151count(*) 1521048576 153SELECT count(*) from t; 154count(*) 1551048576 156SELECT count(*) from t; 157count(*) 1581048576 159SELECT count(*) from t; 160count(*) 1611048576 162SELECT count(*) from t; 163count(*) 1641048576 165SELECT count(*) from t; 166count(*) 1671048576 168SELECT count(*) from t; 169count(*) 1701048576 171SELECT count(*) from t; 172count(*) 1731048576 174SELECT count(*) from t; 175count(*) 1761048576 177SELECT count(*) from t; 178count(*) 1791048576 180SELECT count(*) from t; 181count(*) 1821048576 183SELECT count(*) from t; 184count(*) 1851048576 186SELECT count(*) from t; 187count(*) 1881048576 189SELECT count(*) from t; 190count(*) 1911048576 192SELECT count(*) from t; 193count(*) 1941048576 195SELECT count(*) from t; 196count(*) 1971048576 198SELECT count(*) from t; 199count(*) 2001048576 201SELECT count(*) from t; 202count(*) 2031048576 204SELECT count(*) from t; 205count(*) 2061048576 207SELECT count(*) from t; 208count(*) 2091048576 210SELECT count(*) from t; 211count(*) 2121048576 213SELECT count(*) from t; 214count(*) 2151048576 216SELECT count(*) from t; 217count(*) 2181048576 219SELECT count(*) from t; 220count(*) 2211048576 2221 223set tokudb_bulk_fetch=ON; 224SELECT count(*) from t where num > 700000; 225count(*) 226348576 227SELECT count(*) from t where num > 700000; 228count(*) 229348576 230SELECT count(*) from t where num > 700000; 231count(*) 232348576 233SELECT count(*) from t where num > 700000; 234count(*) 235348576 236SELECT count(*) from t where num > 700000; 237count(*) 238348576 239SELECT count(*) from t where num > 700000; 240count(*) 241348576 242SELECT count(*) from t where num > 700000; 243count(*) 244348576 245SELECT count(*) from t where num > 700000; 246count(*) 247348576 248SELECT count(*) from t where num > 700000; 249count(*) 250348576 251SELECT count(*) from t where num > 700000; 252count(*) 253348576 254SELECT count(*) from t where num > 700000; 255count(*) 256348576 257SELECT count(*) from t where num > 700000; 258count(*) 259348576 260SELECT count(*) from t where num > 700000; 261count(*) 262348576 263SELECT count(*) from t where num > 700000; 264count(*) 265348576 266SELECT count(*) from t where num > 700000; 267count(*) 268348576 269SELECT count(*) from t where num > 700000; 270count(*) 271348576 272SELECT count(*) from t where num > 700000; 273count(*) 274348576 275SELECT count(*) from t where num > 700000; 276count(*) 277348576 278SELECT count(*) from t where num > 700000; 279count(*) 280348576 281SELECT count(*) from t where num > 700000; 282count(*) 283348576 284SELECT count(*) from t where num > 700000; 285count(*) 286348576 287SELECT count(*) from t where num > 700000; 288count(*) 289348576 290SELECT count(*) from t where num > 700000; 291count(*) 292348576 293SELECT count(*) from t where num > 700000; 294count(*) 295348576 296SELECT count(*) from t where num > 700000; 297count(*) 298348576 299SELECT count(*) from t where num > 700000; 300count(*) 301348576 302SELECT count(*) from t where num > 700000; 303count(*) 304348576 305SELECT count(*) from t where num > 700000; 306count(*) 307348576 308SELECT count(*) from t where num > 700000; 309count(*) 310348576 311SELECT count(*) from t where num > 700000; 312count(*) 313348576 314set tokudb_bulk_fetch=OFF; 315SELECT count(*) from t where num > 700000; 316count(*) 317348576 318SELECT count(*) from t where num > 700000; 319count(*) 320348576 321SELECT count(*) from t where num > 700000; 322count(*) 323348576 324SELECT count(*) from t where num > 700000; 325count(*) 326348576 327SELECT count(*) from t where num > 700000; 328count(*) 329348576 330SELECT count(*) from t where num > 700000; 331count(*) 332348576 333SELECT count(*) from t where num > 700000; 334count(*) 335348576 336SELECT count(*) from t where num > 700000; 337count(*) 338348576 339SELECT count(*) from t where num > 700000; 340count(*) 341348576 342SELECT count(*) from t where num > 700000; 343count(*) 344348576 345SELECT count(*) from t where num > 700000; 346count(*) 347348576 348SELECT count(*) from t where num > 700000; 349count(*) 350348576 351SELECT count(*) from t where num > 700000; 352count(*) 353348576 354SELECT count(*) from t where num > 700000; 355count(*) 356348576 357SELECT count(*) from t where num > 700000; 358count(*) 359348576 360SELECT count(*) from t where num > 700000; 361count(*) 362348576 363SELECT count(*) from t where num > 700000; 364count(*) 365348576 366SELECT count(*) from t where num > 700000; 367count(*) 368348576 369SELECT count(*) from t where num > 700000; 370count(*) 371348576 372SELECT count(*) from t where num > 700000; 373count(*) 374348576 375SELECT count(*) from t where num > 700000; 376count(*) 377348576 378SELECT count(*) from t where num > 700000; 379count(*) 380348576 381SELECT count(*) from t where num > 700000; 382count(*) 383348576 384SELECT count(*) from t where num > 700000; 385count(*) 386348576 387SELECT count(*) from t where num > 700000; 388count(*) 389348576 390SELECT count(*) from t where num > 700000; 391count(*) 392348576 393SELECT count(*) from t where num > 700000; 394count(*) 395348576 396SELECT count(*) from t where num > 700000; 397count(*) 398348576 399SELECT count(*) from t where num > 700000; 400count(*) 401348576 402SELECT count(*) from t where num > 700000; 403count(*) 404348576 4051 406drop table t; 407