sysbench测试脚本

#!/bin/bash


thread_num=(50 250 500 1000 1500 2000)
lua_name=(oltp_read_write oltp_read_only oltp_point_select oltp_update_index oltp_update_non_index oltp_insert oltp_delete)
length=${#lua_name[@]} 


for arg in `seq 1 $length`
do
        for num in ${thread_num[*]};
        do
          cur_dateTime="`date +%Y-%m-%d,%H:%m:%s`"
          echo "=================================" >> test_oltp.log
          echo "thread_num:"$num >> test_oltp.log
          echo "start_time:"$cur_dateTime  >> test_oltp.log
          echo "test_scene:"${lua_name[$arg]} >> test_oltp.log
          sysbench --pgsql-host=xxxx --pgsql-port=xxxx --pgsql-user=root --pgs