github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/performance/scripts/mysql_sysbench.sh (about)

     1  #!/bin/bash
     2  set -e
     3  set -o pipefail
     4  
     5  
     6  HOST="127.0.0.1"
     7  PORT=3316
     8  DBNAME="tpcc_test"
     9  USER="root"
    10  PASS="toor"
    11  
    12  SYSBENCH_TEST="oltp_point_select"
    13  
    14  # parse options
    15  # superuser.com/questions/186272/
    16  while test $# -gt 0
    17  do
    18      case "$1" in
    19  
    20          # specify sysbench benchmark
    21          *) SYSBENCH_TEST="$1"
    22              ;;
    23  
    24      esac
    25      shift
    26  done
    27  
    28  if [ ! -d "./sysbench-lua-scripts" ]; then
    29    git clone https://github.com/dolthub/sysbench-lua-scripts.git
    30  fi
    31  
    32  pushd sysbench-lua-scripts
    33  
    34  
    35  sysbench \
    36    --mysql-host="$HOST" \
    37    --mysql-user="$USER" \
    38    --mysql-password="$PASS" \
    39    --mysql-port="$PORT" \
    40    --db-ps-mode=disable \
    41    "$SYSBENCH_TEST" cleanup
    42  
    43  sysbench \
    44    --mysql-host="$HOST" \
    45    --mysql-user="$USER" \
    46    --mysql-password="$PASS" \
    47    --mysql-port="$PORT" \
    48    "$SYSBENCH_TEST" prepare
    49  
    50  # run benchmark
    51  echo "benchmark $SYSBENCH_TEST starting at $WORKING_DIR"
    52  
    53  sysbench \
    54    --mysql-host="$HOST" \
    55    --mysql-user="$USER" \
    56    --mysql-password="$PASS" \
    57    --mysql-port="$PORT" \
    58    --db-ps-mode=disable \
    59    --rand-type="uniform" \
    60    "$SYSBENCH_TEST" run
    61  
    62  popd