← Back to branch summary

~dbpercona/percona-qa/readme

« back to all changes in this revision

Viewing changes to performance-new.sh

  • Committer: Ramesh Sivaraman
  • Date: 2014-05-08 11:11:25 UTC
  • mto: This revision was merged to the branch mainline in revision 422.
  • Revision ID: ramesh.sivaraman@percona.com-20140508111125-2xt12i615q71zf0f
Added variable for mutiple thread count

Show diffs side-by-side

added added

removed removed

Lines of Context:
performance-new.sh
16
16
# Internal settings
17
17
MTR_BT=$[$RANDOM % 300 + 1]
18
18
PORT=$[20000 + $RANDOM % 9999 + 1]
19
 
 
 
19
MULTI_THREAD_COUNT=400
20
20
# The first option is the relative workdir
21
21
# The second option is the relative basedir
22
22
if [ -z $2 ]; then
85
85
  ## OLTP RO Run for memory Warmup
86
86
  echo "Sysbench Run: OLTP RO Run for memory Warmup"
87
87
  /usr/bin/sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \
88
 
   --num-threads=700 --max-time=120 --max-requests=1870000000 \
 
88
   --num-threads=$MULTI_THREAD_COUNT --max-time=120 --max-requests=1870000000 \
89
89
   --oltp-tables-count=30 --mysql-db=test --oltp-read-only --mysql-user=root \
90
90
   --db-driver=mysql --mysql-socket=$WORKDIR/$WORKDIRSUB/socket.sock \
91
91
   run > $WORKDIR/$WORKDIRSUB/sysbench_ro_run_warm_up.txt 2>&1
101
101
  ## OLTP RW Run with default server settings + multiple threaded (700) + cpubound 
102
102
  echo "Sysbench Run: OLTP RW testing with default server settings + multiple threaded (700) + cpubound"
103
103
  /usr/bin/sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \
104
 
   --num-threads=700 --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
 
104
   --num-threads=$MULTI_THREAD_COUNT --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
105
105
   --oltp-tables-count=10 --mysql-db=test --mysql-user=root \
106
106
   --db-driver=mysql --mysql-socket=$WORKDIR/$WORKDIRSUB/socket.sock \
107
107
   run > $WORKDIR/$WORKDIRSUB/sysbench_default_rw_multi_thread_cpubound.txt 2>&1
196
196
  ## OLTP RO Run for memory Warmup
197
197
  echo "Sysbench Run: OLTP RO Run for memory Warmup"
198
198
  /usr/bin/sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \
199
 
   --num-threads=700 --max-time=120 --max-requests=1870000000 \
 
199
   --num-threads=$MULTI_THREAD_COUNT --max-time=120 --max-requests=1870000000 \
200
200
   --oltp-tables-count=30 --mysql-db=test --oltp-read-only --mysql-user=root \
201
201
   --db-driver=mysql --mysql-socket=$WORKDIR/$WORKDIRSUB/socket.sock \
202
202
   run > $WORKDIR/$WORKDIRSUB/sysbench_ro_run_warm_up.txt 2>&1
212
212
  ## OLTP RW Run with Tuned server settings + multiple threaded (700) + cpubound (10 tables * 1 M Rows each : data size approx = 2.3G ) 
213
213
  echo "Sysbench Run: OLTP RW testing with default server settings + multiple threaded (700) + cpubound"
214
214
  /usr/bin/sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \
215
 
   --num-threads=700 --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
 
215
   --num-threads=$MULTI_THREAD_COUNT --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
216
216
   --oltp-tables-count=10 --mysql-db=test --mysql-user=root \
217
217
   --db-driver=mysql --mysql-socket=$WORKDIR/$WORKDIRSUB/socket.sock \
218
218
   run > $WORKDIR/$WORKDIRSUB/sysbench_tuned_rw_multi_thread_cpubound.txt 2>&1
228
228
  ## OLTP RW Run with Tuned server settings + multiple threaded (700) + iobound (30 tables * 1 M Rows each : data size approx = 6.9G )
229
229
  echo "Sysbench Run: OLTP RW Run with tuned server settings + multiple threaded (700) + iobound"
230
230
  /usr/bin/sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \
231
 
   --num-threads=700 --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
 
231
   --num-threads=$MULTI_THREAD_COUNT --max-time=$SYSBENCH_DURATION --max-requests=1870000000 \
232
232
   --oltp-tables-count=30 --mysql-db=test --mysql-user=root \
233
233
   --db-driver=mysql --mysql-socket=$WORKDIR/$WORKDIRSUB/socket.sock \
234
234
   run > $WORKDIR/$WORKDIRSUB/sysbench_tuned_rw_multi_thread_iobound.txt 2>&1