Advertisement
Guest User

Untitled

a guest
May 13th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. Command line used for benchmarking:
  2.  
  3. ./sysbench --batch --batch-delay=10 --test=oltp --mysql-host=172.31.23.147 \
  4. --mysql-port=3308 --mysql-user=root --mysql-password=pwd --mysql-db=test \
  5. --oltp-table-size=20000000 --max-time=180 --max-requests=0 \
  6. --mysql-table-engine=rocksdb --db-ps-mode=disable --mysql-engine-trx=yes \
  7. --oltp-table-name=sbtest1 --oltp-read-only \
  8. --oltp-skip-trx --oltp-test-mode=simple --oltp-point-select-all-cols \
  9. --oltp-secondary --oltp-auto-inc=off --oltp-dist-type=uniform \
  10. --oltp-connect-delay=0 --percentile=99 --seed-rng=1460080700 --num-threads=8 run
  11.  
  12. - InnoDB, created with the above sysbench call, innodb_buffer_pool_size=8G
  13. (the datadir was ~5.1G)
  14. - InnoDB, created with the above sysbench call, innodb_buffer_pool_size=8G,
  15. and oltp-secondary=false (the datadir was ~4.7G)
  16.  
  17. - MyRocks, created with the above sysbench call, default settings
  18. (the datadir was ~4.7G)
  19. - MyRocks, created with the above sysbench call, default settings
  20. and oltp-secondary=false (the datadir was ~4.1G)
  21.  
  22. Initially I was getting about 2500 QPS with MyRocks.
  23. the time was spent in reading from disk, so I've increased
  24. rocksdb_block_cache_size=10G, and then it got faster.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement