Skip to content

Instantly share code, notes, and snippets.

@kawa-
Created July 25, 2014 08:50
Show Gist options
  • Save kawa-/1c0651a9dca8f2b6bc75 to your computer and use it in GitHub Desktop.
Save kawa-/1c0651a9dca8f2b6bc75 to your computer and use it in GitHub Desktop.
My benchmark shell script for my custom MySQL benchmarks.
echo "This is a benchmark script for insert."
echo "Now, going to have a bench."
num=100000
CLI=1
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
CLI=5
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
CLI=10
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
CLI=25
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
CLI=50
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
CLI=100
QPC=`expr ${num} / ${CLI}`
echo "=== C:${CLI}, Q/C: ${QPC} ==="
php generate_unique_pair.php ${num} > unique_pairs.txt
php generate_unique_pair_t11.php ${num} > unique_pairs_t11.txt
echo "*** table: t01 ***"
./insert_bench.pl -n ${CLI} -d db01 -t t01 -f unique_pairs.txt
echo "*** table: t11 ***"
./insert_bench_t11.pl -n ${CLI} -d db01 -t t11 -f unique_pairs_t11.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment