Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. * QPS by #threads, QPS is from "read/write requests:" line
  2. * Uses sysbench 0.5, oltp.lua
  3. * host has 48 HW threads, 24 CPU cores
  4. * sysbench client used glibc malloc
  5. * database cached all tables
  6. * rx.aug5 is MyRocks built on August 5, rx.sep27 is MyRocks built on Sep 27, in.5626 is InnoDB in upstream 5.6.26
  7.  
  8. read-only
  9. 1 2 4 8 16 24 32 40 48 64 80 96 128
  10. 5078 10938 23257 52420 107187 148588 173040 194901 212838 215344 216134 217699 217674 rx.aug5
  11. 5041 10838 23165 51401 106353 147289 171515 193842 210933 214551 213517 215154 215739 rx.sep27
  12. 5368 11226 23263 53355 107630 147906 170842 194908 212603 207564 192938 182113 151725 in.5626
  13.  
  14. read-write
  15. 1 2 4 8 16 24 32 40 48 64 80 96 128
  16. 5163 10329 20230 43145 91236 124595 144620 156740 156073 158747 159300 158835 159244 rx.aug5
  17. 5143 10268 20141 42767 91050 125118 141703 156543 157386 156080 157728 157465 156817 rx.sep27
  18. 5606 11739 25207 55188 106929 143856 168702 187058 191080 180099 173400 168259 152711 in.5626
  19.  
  20. Command line pattern is first run read-only, then run read-write...
  21.  
  22. for nt in 1 2 4 8 16 24 32 40 48 64 80 96 128; do
  23. sysbench --test=tests/db/oltp.lua --db-driver=mysql --mysql-engine-trx=yes --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-table-engine=innodb --oltp-table-size=1000000 --oltp-tables-count=8 --num-threads=$nt --max-requests=0 --max-time=180 --oltp-read-only=on run
  24. done
  25.  
  26. for nt in 1 2 4 8 16 24 32 40 48 64 80 96 128; do
  27. sysbench --test=tests/db/oltp.lua --db-driver=mysql --mysql-engine-trx=yes --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-table-engine=innodb --oltp-table-size=1000000 --oltp-tables-count=8 --num-threads=$nt --max-requests=0 --max-time=300 --oltp-read-only=off run
  28. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement