Skip to content

Instantly share code, notes, and snippets.

@fipar
Created February 4, 2016 11:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fipar/e1d3a966201eeccf0ed9 to your computer and use it in GitHub Desktop.
Save fipar/e1d3a966201eeccf0ed9 to your computer and use it in GitHub Desktop.
for test in oltp update_index update_non_index; do
mkdir $test; pushd $test
for i in 50000 25000 10000 5000 2500 1000
#for i in 10
do
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
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
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
done
popd
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment