Advertisement
Guest User

Untitled

a guest
Feb 4th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. for test in oltp update_index update_non_index; do
  2. mkdir $test; pushd $test
  3. for i in 50000 25000 10000 5000 2500 1000
  4. #for i in 10
  5. do
  6. sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_table_engine=tokudb --num-threads=16 --oltp-table-size=${i}000 --rand-type=pareto --rand-init=on --report-interval=10 --mysql-host=sbhost --mysql-db=sbtest --max-time=7200 --max-requests=0 prepare
  7. sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_table_engine=tokudb --num-threads=16 --oltp-table-size=${i}000 --rand-type=pareto --rand-init=on --report-interval=10 --mysql-host=sbhost --mysql-db=sbtest --max-time=7200 --max-requests=0 run | tee -a toku.${i}.${test}.ssd.txt
  8. sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_table_engine=tokudb --num-threads=16 --oltp-table-size=${i}000 --rand-type=pareto --rand-init=on --report-interval=10 --mysql-host=sbhost --mysql-db=sbtest --max-time=7200 --max-requests=0 cleanup
  9. done
  10. popd
  11. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement