github.com/percona/percona-xtradb-cluster-operator@v1.14.0/e2e-tests/conf/sysbench.yaml (about)

     1  apiVersion: apps/v1
     2  kind: ReplicaSet
     3  metadata:
     4    name: sysbench
     5  spec:
     6    replicas: 1
     7    minReadySeconds: 20
     8    selector:
     9      matchLabels:
    10        app: sysbench
    11    template:
    12      metadata:
    13        name: sysbench
    14        labels:
    15          app: sysbench
    16      spec:
    17        containers:
    18          - name: sysbench
    19            image: perconalab/sysbench
    20            env:
    21              - name: MYSQL_USER
    22                value: root
    23              - name: MYSQL_PASSWORD
    24                value: root_password
    25              - name: MYSQL_HOSTNAME
    26                value: 10.28.0.8
    27            command: ["bash"]
    28            args:
    29              - "-c"
    30              - |
    31                set -ex
    32  
    33                mysql \
    34                  --host="${MYSQL_HOSTNAME}" \
    35                  --port=3306 \
    36                  --user="${MYSQL_USER}" \
    37                  --password="${MYSQL_PASSWORD}" \
    38                  -e 'CREATE DATABASE IF NOT EXISTS sbtest'
    39  
    40                sysbench /usr/share/sysbench/oltp_insert.lua \
    41                  --db-driver=mysql \
    42                  --mysql-host="${MYSQL_HOSTNAME}" \
    43                  --mysql-port=3306 \
    44                  --mysql-user="${MYSQL_USER}" \
    45                  --mysql-password="${MYSQL_PASSWORD}" \
    46                  --mysql-db=sbtest \
    47                  --mysql_storage_engine=innodb \
    48                  --tables=16 \
    49                  --table_size=100 \
    50                  prepare
    51  
    52                sysbench /usr/share/sysbench/oltp_read_write.lua \
    53                  --rate=200 \
    54                  --threads=16 \
    55                  --report-interval=10 \
    56                  --time=7200 \
    57                  --events=0 \
    58                  --rand-type=pareto \
    59                  --db-driver=mysql \
    60                  --mysql-host="${MYSQL_HOSTNAME}" \
    61                  --mysql-port=3306 \
    62                  --mysql-user="${MYSQL_USER}" \
    63                  --mysql-password="${MYSQL_PASSWORD}" \
    64                  --mysql-db=sbtest \
    65                  --mysql_storage_engine=innodb \
    66                  --table-size=0 \
    67                  run