Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- * QPS by #threads, QPS is from "read/write requests:" line
- * Uses sysbench 0.5, oltp.lua
- * host has 48 HW threads, 24 CPU cores
- * sysbench client used glibc malloc
- * database cached all tables
- * 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
- read-only
- 1 2 4 8 16 24 32 40 48 64 80 96 128
- 5078 10938 23257 52420 107187 148588 173040 194901 212838 215344 216134 217699 217674 rx.aug5
- 5041 10838 23165 51401 106353 147289 171515 193842 210933 214551 213517 215154 215739 rx.sep27
- 5368 11226 23263 53355 107630 147906 170842 194908 212603 207564 192938 182113 151725 in.5626
- read-write
- 1 2 4 8 16 24 32 40 48 64 80 96 128
- 5163 10329 20230 43145 91236 124595 144620 156740 156073 158747 159300 158835 159244 rx.aug5
- 5143 10268 20141 42767 91050 125118 141703 156543 157386 156080 157728 157465 156817 rx.sep27
- 5606 11739 25207 55188 106929 143856 168702 187058 191080 180099 173400 168259 152711 in.5626
- Command line pattern is first run read-only, then run read-write...
- for nt in 1 2 4 8 16 24 32 40 48 64 80 96 128; do
- 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
- done
- for nt in 1 2 4 8 16 24 32 40 48 64 80 96 128; do
- 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
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement