MySQL Performance : Benchmark kit (BMK-kit)
by Dimitri Kravtchuk
The following is a short HOWTO about deployment and use of Benchmark-kit (BMK-kit). The main idea of this kit is to simplify your life in running various MySQL benchmark workloads with less blood and minimal potential errors.
Generally as simple as the following :
$ bash /BMK/sb_exec/sb11-Prepare_50M_8tab-InnoDB.sh 32 # prepare data
$ for users in 1 2 4 8 16 32 64 128 256 512 1024
do
# run OLTP_RW for 5min each load level..
bash /BMK/sb_exec/sb11-OLTP_RW_50M_8tab-uniform-ps-trx.sh $users 300
sleep 15
done
Read more... (35 min remaining to read)
Generally as simple as the following :
$ bash /BMK/sb_exec/sb11-Prepare_50M_8tab-InnoDB.sh 32 # prepare data
$ for users in 1 2 4 8 16 32 64 128 256 512 1024
do
# run OLTP_RW for 5min each load level..
bash /BMK/sb_exec/sb11-OLTP_RW_50M_8tab-uniform-ps-trx.sh $users 300
sleep 15
done
Read more... (35 min remaining to read)
