/usr/local/etc/rc.d/mysql-server onestart
for i in 1 4 8 16 32 40 64 128 ; do echo "-----" ; echo $i ; for j in ` jot 8 ` ; do sysbench --test=oltp --db-driver=mysql --mysql-table-engine=innodb --mysql-socket=/tmp/mysql.sock --mysql-user=root --max-requests=0 --max-time=120 --oltp-read-only=on --num-threads=$i run |grep transactions:|awk '{ print $3 }' |sed -e 's/(//g' ; done ; done
#for i in 32 40 64 128  ; do echo "-----" ; echo $i ; for j in ` jot 8 ` ; do sysbench --test=oltp --db-driver=mysql --mysql-table-engine=innodb --mysql-socket=/tmp/mysql.sock --mysql-user=root --max-requests=0 --max-time=120 --oltp-read-only=on --num-threads=$i run |grep transactions:|awk '{ print $3 }' |sed -e 's/(//g' ; done ; done