Advertisement
Guest User

Untitled

a guest
Nov 28th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.22 KB | None | 0 0
  1. ps version: 5.7.15-7-log
  2.  
  3. ------------------------------------------------------------------------
  4. 64tables ~2million records per table
  5. Table: benchyou1
  6. Create Table: CREATE TABLE `benchyou1` (
  7. `id` bigint(20) unsigned NOT NULL,
  8. `k` bigint(20) unsigned NOT NULL DEFAULT '0',
  9. `c` char(120) NOT NULL DEFAULT '',
  10. `pad` char(60) NOT NULL DEFAULT '',
  11. PRIMARY KEY (`id`),
  12. KEY `k_1` (`k`)
  13. ) ENGINE=TokuDB DEFAULT CHARSET=latin1
  14.  
  15. ------------------------------------------------------------------------
  16. Range:
  17. SELECT * FROM benchyou WHERE id bewteen lower-random and upper-random ORDER BY id desc limit 100;
  18.  
  19. ------------------------------------------------------------------------
  20. DESC:
  21. ./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
  22. -----------------------------------------------------------------------------------avg---------------------------------------------------------------------------------------------
  23. time tps wtps rtps rio rio/op wio wio/op rMB rKB/op wMB wKB/op cpu/op w-rsp(ms) r-rsp(ms)
  24. [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]
  25.  
  26. ------------------------------------------------------------------------
  27. ASC:
  28. ./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
  29. -----------------------------------------------------------------------------------avg---------------------------------------------------------------------------------------------
  30. time tps wtps rtps rio rio/op wio wio/op rMB rKB/op wMB wKB/op cpu/op w-rsp(ms) r-rsp(ms)
  31. [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