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

     1  ---
     2  title: kbcli bench sysbench run
     3  ---
     4  
     5  Run  SysBench on cluster
     6  
     7  ```
     8  kbcli bench sysbench run [ClusterName] [flags]
     9  ```
    10  
    11  ### Examples
    12  
    13  ```
    14    # sysbench run on a cluster
    15    kbcli bench sysbench run mycluster --user xxx --password xxx --database mydb
    16    
    17    # sysbench run on a cluster with different threads
    18    kbcli bench sysbench run  mycluster --user xxx --password xxx --database mydb --threads 4,8
    19    
    20    # sysbench run on a cluster with different type
    21    kbcli bench sysbench run mycluster --user xxx --password xxx --database mydb --type oltp_read_only,oltp_read_write
    22    
    23    # sysbench run on a cluster with specified read/write ratio
    24    kbcli bench sysbench run  mycluster --user xxx --password xxx  --database mydb --type oltp_read_write_pct --read-percent 80 --write-percent 80
    25    
    26    # sysbench run on a cluster with specified tables and size
    27    kbcli bench sysbench run mycluster --user xxx --password xxx --database mydb --tables 10 --size 25000
    28  ```
    29  
    30  ### Options
    31  
    32  ```
    33    -h, --help   help for run
    34  ```
    35  
    36  ### Options inherited from parent commands
    37  
    38  ```
    39        --as string                      Username to impersonate for the operation. User could be a regular user or a service account in a namespace.
    40        --as-group stringArray           Group to impersonate for the operation, this flag can be repeated to specify multiple groups.
    41        --as-uid string                  UID to impersonate for the operation.
    42        --cache-dir string               Default cache directory (default "$HOME/.kube/cache")
    43        --certificate-authority string   Path to a cert file for the certificate authority
    44        --client-certificate string      Path to a client certificate file for TLS
    45        --client-key string              Path to a client key file for TLS
    46        --cluster string                 The name of the kubeconfig cluster to use
    47        --context string                 The name of the kubeconfig context to use
    48        --database string                database name
    49        --disable-compression            If true, opt-out of response compression for all requests to the server
    50        --flag int                       the flag of sysbench, 0(normal), 1(long), 2(three nodes)
    51        --host string                    the host of database
    52        --insecure-skip-tls-verify       If true, the server's certificate will not be checked for validity. This will make your HTTPS connections insecure
    53        --kubeconfig string              Path to the kubeconfig file to use for CLI requests.
    54        --match-server-version           Require server version to match client version
    55    -n, --namespace string               If present, the namespace scope for this CLI request
    56        --password string                the password of database
    57        --port int                       the port of database
    58        --read-percent int               the percent of read, only useful when type is oltp_read_write_pct
    59        --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")
    60    -s, --server string                  The address and port of the Kubernetes API server
    61        --size int                       the data size of per table (default 25000)
    62        --tables int                     the number of tables (default 10)
    63        --threads ints                   the number of threads, you can set multiple values, like 4,8 (default [4])
    64        --times int                      the number of test times (default 60)
    65        --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
    66        --token string                   Bearer token for authentication to the API server
    67        --type strings                   sysbench type, you can set multiple values (default [oltp_read_write])
    68        --user string                    the user of database
    69        --write-percent int              the percent of write, only useful when type is oltp_read_write_pct
    70  ```
    71  
    72  ### SEE ALSO
    73  
    74  * [kbcli bench sysbench](kbcli_bench_sysbench.md)	 - run a SysBench benchmark
    75  
    76  #### Go Back to [CLI Overview](cli.md) Homepage.
    77