tokudb-desc-icp-iibench

ps version: 5.7.15-7-log
2tables ~25150327 records per table

Table: purchases_index0
Create Table: CREATE TABLE `purchases_index0` (
  `transactionid` bigint(20) NOT NULL AUTO_INCREMENT,
  `dateandtime` datetime DEFAULT NULL,
  `cashregisterid` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `price` float NOT NULL,
  `data` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`transactionid`),
  KEY `pdc` (`price`,`dateandtime`,`customerid`)
) ENGINE=TokuDB 

Range:
select price,dateandtime,customerid from purchases_index%d force index (pdc) where (price>=%.2f) order by price,dateandtime,customerid DESC/ASC limit 10

ASC:
./bin/benchyou  --mysql-host=192.168.0.3  --mysql-user=sbtest --mysql-password=sbtest --ssh-user=benchyou --ssh-password=benchyou  --oltp-tables-count=2 --write-threads=0 --read-threads=128 --max-time=600 --mysql-range-order=ASC --bench-mode=iibench range
time            thds       tps     wtps    rtps    rio    rio/op   wio    wio/op    rMB     rKB/op    wMB     wKB/op   cpu/op  
[85s]        [r:128,w:0]  70294    0       70294   0      0.00     2      0.00      0.00    0.00      0.02    0.00     1.08 

DESC:
./bin/benchyou  --mysql-host=192.168.0.3  --mysql-user=sbtest --mysql-password=sbtest --ssh-user=benchyou --ssh-password=benchyou  --oltp-tables-count=64 --write-threads=0 --read-threads=128 --max-time=60 range --mysql-range-order=DESC
time            thds       tps     wtps    rtps    rio    rio/op   wio    wio/op    rMB     rKB/op    wMB     wKB/op   cpu/op   
[74s]        [r:128,w:0]  1        0       1       0      0.00     0      0.00      0.00    0.00      0.00    0.00     4278.00 

show processlist:
| 50378 | sbtest | 192.168.0.7:53560 | sbtest | Query            |      42 | Queried about 7750000 rows                                    | select price,dateandtime,customerid from purchases_index0 force index (pdc) where (price>=35.50) ord