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

     1  #!/bin/bash
     2  set -e
     3  set -o pipefail
     4  
     5  HOST="127.0.0.1"
     6  PORT=3316
     7  DBNAME="tpcc_test"
     8  USER="root"
     9  PASS="toor"
    10  
    11  if [ ! -d "./sysbench-tpcc" ]; then
    12    git clone https://github.com/Percona-Lab/sysbench-tpcc.git
    13  fi
    14  
    15  pushd sysbench-tpcc
    16  
    17  ./tpcc.lua \
    18    --db-driver="mysql" \
    19    --mysql-db="$DBNAME" \
    20    --mysql-host="$HOST" \
    21    --mysql-port="$PORT" \
    22    --mysql-user="$USER" \
    23    --mysql-password="$PASS" \
    24    --time=10 \
    25    --report_interval=1 \
    26    --threads=2 \
    27    --tables=1 \
    28    --scale=1 \
    29    --trx_level="RR" \
    30    cleanup
    31  
    32  
    33  ./tpcc.lua \
    34    --db-driver="mysql" \
    35    --mysql-db="$DBNAME" \
    36    --mysql-host="$HOST" \
    37    --mysql-port="$PORT" \
    38    --mysql-user="$USER" \
    39    --mysql-password="$PASS" \
    40    --time=10 \
    41    --report_interval=1 \
    42    --threads=2 \
    43    --tables=1 \
    44    --scale=1 \
    45    --trx_level="RR" \
    46    prepare
    47  
    48  ./tpcc.lua \
    49    --db-driver="mysql" \
    50    --mysql-db="$DBNAME" \
    51    --mysql-host="$HOST" \
    52    --mysql-port="$PORT" \
    53    --mysql-user="$USER" \
    54    --mysql-password="$PASS" \
    55    --time=10 \
    56    --report_interval=1 \
    57    --threads=2 \
    58    --tables=1 \
    59    --scale=1 \
    60    --trx_level="RR" \
    61    run
    62  
    63  
    64  echo "benchmark TPC-C complete at $WORKING_DIR"