My benchmark shell script for my custom MySQL benchmarks.

bench_select.sh

echo "This is a benchmark script."
echo "Now prepare for the bench."
echo "Making sampled valid users...."
perl -ne 'print if (rand() < .05)' valid_users.txt > sampled_valid_users.txt
echo "-> Done. now you can see the number of the users."
wc -l sampled_valid_users.txt
echo "-> OK. Above you can see the number of the users."
echo "Now, going to have a bench."

echo "=== C:1, Q/C: 100000 ==="
echo "*** table: t01 ***"
./select.pl -n 1 -r 100000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 1 -r 100000 -d db01 -t t11 -f sampled_valid_users.txt

echo "=== C:5, Q/C: 20000 ==="
echo "*** table: t01 ***"
./select.pl -n 5 -r 20000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 5 -r 20000 -d db01 -t t11 -f sampled_valid_users.txt

echo "=== C:10, Q/C: 10000 ==="
echo "*** table: t01 ***"
./select.pl -n 10 -r 10000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 10 -r 10000 -d db01 -t t11 -f sampled_valid_users.txt

echo "=== C:25, Q/C: 4000 ==="
echo "*** table: t01 ***"
./select.pl -n 25 -r 4000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 25 -r 4000 -d db01 -t t11 -f sampled_valid_users.txt

echo "=== C:50, Q/C: 20000 ==="
echo "*** table: t01 ***"
./select.pl -n 50 -r 2000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 50 -r 2000 -d db01 -t t11 -f sampled_valid_users.txt

echo "=== C:100, Q/C: 1000 ==="
echo "*** table: t01 ***"
./select.pl -n 100 -r 1000 -d db01 -t t01 -f sampled_valid_users.txt
echo "*** table: t11 ***"
./select_t11.pl -n 100 -r 1000 -d db01 -t t11 -f sampled_valid_users.txt

echo "\n\n===== FIN. ===== \n\n"