github.com/square/finch@v0.0.0-20240412205204-6530c03e2b96/benchmarks/xfer/setup.yaml (about)

     1  # https://square.github.io/finch/benchmark/examples/#xfer
     2  
     3  stage:
     4    name: setup
     5    stats:
     6      disable: true
     7    workload:
     8      - clients: 1                  #
     9        group: schema               # exec group "schema"
    10        trx: [schema.sql]           #
    11      - clients: 2                    #
    12        group: rows                   #
    13        trx: [insert-cust-bal.sql]    # exec group "rows"
    14      - clients: 2                    #
    15        group: rows                   #
    16        trx: [insert-xfers.sql]       #
    17  
    18    trx:
    19      - file: ./trx/schema.sql
    20      - file: ./trx/insert-cust-bal.sql
    21        data:
    22          c_token:
    23            generator: xid
    24            scope: trx
    25          b_token:
    26            generator: xid
    27            scope: value # required to generate 3 different balance tokens in same INSERT statement
    28          c_c1:
    29            generator: "str-fill-az"
    30            params:
    31              len: 20
    32          c_c2:
    33            generator: "str-fill-az"
    34            params:
    35              len: 50
    36          c_c3:
    37            generator: "str-fill-az"
    38            params:
    39              len: 75
    40          b_c1:
    41            generator: "str-fill-az"
    42            params:
    43              len: 30
    44          b_c2:
    45            generator: "str-fill-az"
    46            params:
    47              len: 50
    48      - file: ./trx/insert-xfers.sql
    49        data:
    50          x_token:
    51            generator: "xid"
    52          s_token:
    53            generator: "xid"
    54          r_token:
    55            generator: "xid"
    56          c1:
    57            generator: "str-fill-az"
    58            params:
    59              len: 10
    60          c2:
    61            generator: "str-fill-az"
    62            params:
    63              len: 50
    64          c3:
    65            generator: "str-fill-az"
    66            params:
    67              len: 5