github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/docs/user_docs/cli/kbcli_bench_sysbench.md (about)

     1  ---
     2  title: kbcli bench sysbench
     3  ---
     4  
     5  run a SysBench benchmark
     6  
     7  ```
     8  kbcli bench sysbench [Step] [BenchmarkName] [flags]
     9  ```
    10  
    11  ### Examples
    12  
    13  ```
    14    # sysbench on a cluster, that will exec for all steps, cleanup, prepare and run
    15    kbcli bench sysbench mytest --cluster mycluster --user xxx --password xxx --database mydb
    16    
    17    # sysbench run on a cluster with cleanup, only cleanup by deleting the testdata
    18    kbcli bench sysbench cleanup mytest --cluster mycluster --user xxx --password xxx --database mydb
    19    
    20    # sysbench run on a cluster with prepare, just prepare by creating the testdata
    21    kbcli bench sysbench prepare mytest --cluster mycluster --user xxx --password xxx --database mydb
    22    
    23    # sysbench run on a cluster with run, just run by running the test
    24    kbcli bench sysbench run mytest --cluster mycluster --user xxx --password xxx --database mydb
    25    
    26    # sysbench on a cluster with thread counts
    27    kbcli bench sysbench mytest --cluster mycluster --user xxx --password xxx --database mydb --threads 4,8
    28    
    29    # sysbench on a cluster with type
    30    kbcli bench sysbench mytest --cluster mycluster --user xxx --password xxx --database mydb --type oltp_read_only,oltp_read_write
    31    
    32    # sysbench on a cluster with specified read/write ratio
    33    kbcli bench sysbench mytest --cluster mycluster --user xxx --password xxx  --database mydb --type oltp_read_write_pct --read-percent 80 --write-percent 20
    34    
    35    # sysbench on a cluster with specified tables and size
    36    kbcli bench sysbench mytest --cluster mycluster --user xxx --password xxx --database mydb --tables 10 --size 25000
    37  ```
    38  
    39  ### Options
    40  
    41  ```
    42        --cluster string        the cluster of database
    43        --database string       database name
    44        --driver string         the driver of database
    45        --duration int          the seconds of running sysbench (default 60)
    46        --extra-args strings    extra arguments for benchmark
    47    -h, --help                  help for sysbench
    48        --host string           the host of database
    49        --password string       the password of database
    50        --port int              the port of database
    51        --read-percent int      the percent of read, only useful when type is oltp_read_write_pct
    52        --size int              the data size of per table (default 25000)
    53        --tables int            the number of tables (default 10)
    54        --threads ints          the number of threads, you can set multiple values, like 4,8 (default [4])
    55        --tolerations strings   Tolerations for benchmark, such as '"dev=true:NoSchedule,large=true:NoSchedule"'
    56        --type strings          sysbench type, you can set multiple values (default [oltp_read_write])
    57        --user string           the user of database
    58        --write-percent int     the percent of write, only useful when type is oltp_read_write_pct
    59  ```
    60  
    61  ### Options inherited from parent commands
    62  
    63  ```
    64        --as string                      Username to impersonate for the operation. User could be a regular user or a service account in a namespace.
    65        --as-group stringArray           Group to impersonate for the operation, this flag can be repeated to specify multiple groups.
    66        --as-uid string                  UID to impersonate for the operation.
    67        --cache-dir string               Default cache directory (default "$HOME/.kube/cache")
    68        --certificate-authority string   Path to a cert file for the certificate authority
    69        --client-certificate string      Path to a client certificate file for TLS
    70        --client-key string              Path to a client key file for TLS
    71        --context string                 The name of the kubeconfig context to use
    72        --disable-compression            If true, opt-out of response compression for all requests to the server
    73        --insecure-skip-tls-verify       If true, the server's certificate will not be checked for validity. This will make your HTTPS connections insecure
    74        --kubeconfig string              Path to the kubeconfig file to use for CLI requests.
    75        --match-server-version           Require server version to match client version
    76    -n, --namespace string               If present, the namespace scope for this CLI request
    77        --request-timeout string         The length of time to wait before giving up on a single server request. Non-zero values should contain a corresponding time unit (e.g. 1s, 2m, 3h). A value of zero means don't timeout requests. (default "0")
    78    -s, --server string                  The address and port of the Kubernetes API server
    79        --tls-server-name string         Server name to use for server certificate validation. If it is not provided, the hostname used to contact the server is used
    80        --token string                   Bearer token for authentication to the API server
    81  ```
    82  
    83  ### SEE ALSO
    84  
    85  * [kbcli bench](kbcli_bench.md)	 - Run a benchmark.
    86  
    87  #### Go Back to [CLI Overview](cli.md) Homepage.
    88