TPCC 사용법

1. Build binaries
   * cd scr ; make
   ( you should have mysql_config available in $PATH)

2. Load data
   * create database
     mysqladmin create tpcc1000

    create database tpcc1000

   * create tables
     mysql tpcc1000 < create_table.sql
     or
     mysql -uroot -p tpcc1000 < create_table.sql

   * create indexes and FK ( this step can be done after loading data)
     mysql tpcc1000 < add_fkey_idx.sql

   * populate data
     - simple step
       tpcc_load 127.0.0.1:33000 tpcc1000 root "" 1000
                 |hostname:port| |dbname| |user| |password| |WAREHOUSES|
       ref. tpcc_load --help for all options
     - load data in parallel
       check load.sh script

$ ./tpcc_load localhost tpcc1000 root 'root123o!' 20

3. start benchmark
   * ./tpcc_start -h127.0.0.1 -P33000 -dtpcc1000 -uroot -w1000 -c32 -r10 -l10800
                  |hostname| |port| |dbname| |user| |WAREHOUSES| |CONNECTIONS| |WARMUP TIME| |BENCHMARK TIME|
   * ref. tpcc_start --help for all options

 ./tpcc_start -h192.168.194.189 -dtpcc1000 -uroot -p 'root123o!' -w20 -c16 -l1200

# -r 옵션 추가 시 segment fault error 발생 / 버그인듯

 

[tpcc_start 결과]
    ......
    1200, 345(0):4.172|4.393, 342(0):0.882|1.234, 35(0):0.404|0.423, 34(0):4.965|4.980, 35(0):12.524|12.629
   
    STOPPING THREADS................
   
    <Raw Results>
      [0] sc:40388  lt:0  rt:0  fl:0
      [1] sc:40376  lt:0  rt:0  fl:0
      [2] sc:4040  lt:0  rt:0  fl:0
      [3] sc:4039  lt:0  rt:0  fl:0
      [4] sc:4041  lt:0  rt:0  fl:0
     in 1200 sec.
   
    <Raw Results2(sum ver.)>
      [0] sc:40396  lt:0  rt:0  fl:0
      [1] sc:40397  lt:0  rt:0  fl:0
      [2] sc:4040  lt:0  rt:0  fl:0
      [3] sc:4039  lt:0  rt:0  fl:0
      [4] sc:4041  lt:0  rt:0  fl:0
   
    <Constraint Check> (all must be [OK])
     [transaction percentage]
            Payment: 43.47% (>=43.0%) [OK]
       Order-Status: 4.35% (>= 4.0%) [OK]
           Delivery: 4.35% (>= 4.0%) [OK]
        Stock-Level: 4.35% (>= 4.0%) [OK]
     [response time (at least 90% passed)]
          New-Order: 100.00%  [OK]
            Payment: 100.00%  [OK]
       Order-Status: 100.00%  [OK]
           Delivery: 100.00%  [OK]
        Stock-Level: 100.00%  [OK]
   
    <TpmC>
                     2019.400 TpmC