Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ps version: 5.7.15-7-log
- ------------------------------------------------------------------------
- 64tables ~2million records per table
- Table: benchyou1
- Create Table: CREATE TABLE `benchyou1` (
- `id` bigint(20) unsigned NOT NULL,
- `k` bigint(20) unsigned NOT NULL DEFAULT '0',
- `c` char(120) NOT NULL DEFAULT '',
- `pad` char(60) NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `k_1` (`k`)
- ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- ------------------------------------------------------------------------
- Range:
- SELECT * FROM benchyou WHERE id bewteen lower-random and upper-random ORDER BY id desc limit 100;
- ------------------------------------------------------------------------
- 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
- -----------------------------------------------------------------------------------avg---------------------------------------------------------------------------------------------
- time tps wtps rtps rio rio/op wio wio/op rMB rKB/op wMB wKB/op cpu/op w-rsp(ms) r-rsp(ms)
- [60s] 1703 0 1703 269 0.16 0 0.00 9.26 0.09 0.00 0.00 0.00 [avg:NaN,min:0.00,max:0.00] [avg:1.25,min:0.00,max:711.55]
- ------------------------------------------------------------------------
- ASC:
- ./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=ASC
- -----------------------------------------------------------------------------------avg---------------------------------------------------------------------------------------------
- time tps wtps rtps rio rio/op wio wio/op rMB rKB/op wMB wKB/op cpu/op w-rsp(ms) r-rsp(ms)
- [60s] 1347 0 1347 195 0.15 0 0.00 6.67 0.08 0.00 0.00 0.00 [avg:NaN,min:0.00,max:0.00] [avg:1.58,min:0.00,max:909.56]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement