8 Threads sysbench 1000 rows - mysql

mysql_sysbench_1000.sh

#!/bin/bash
ROWS=10000
touch result.dat
for ENGINE in "myisam" "innodb"
do
        CSV=$ENGINE-$ROWS.csv
        cp /dev/null $CSV
        for threads in 2 4 6 8
        do       

       sysbench --test=oltp --oltp-table-size=10000 --oltp-test-mode=complex \
                --oltp-read-only=off --num-threads=$threads --max-time=60 \
                --max-requests=0 --mysql-db=dbtest \
                --mysql-user=mysqluser --mysql-password=mysqluser --mysql-table-engine=$ENGINE cleanup

        sysbench --test=oltp --oltp-table-size=10000 --oltp-test-mode=complex \
                 --oltp-read-only=off --num-threads=$threads --max-time=60 \
                 --max-requests=0 --mysql-db=dbtest \
                 --mysql-user=mysqluser --mysql-password=mysqluser --mysql-table-engine=$ENGINE prepare
        
        sysbench --test=oltp --oltp-table-size=10000 --oltp-test-mode=complex \
                 --oltp-read-only=off --num-threads=$threads --max-time=60 \ 
                 --max-requests=0 --mysql-db=dbtest \
                 --mysql-user=mysqluser --mysql-password=mysqluser \
                 --mysql-table-engine=$ENGINE run >result.dat

        READ=`egrep 'read:' result.dat`
        WRITE=`egrep 'write:' result.dat`
        echo $threads,$READ,$WRITE >>$CSV
        
        done
done