MySQL Performance : Benchmark kit (BMK-kit)

Mysql

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)