<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysqlslap">
      </a>
      6.5.7 mysqlslap — A Load Emulation Client
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045309949696">
  </a>
  <a class="indexterm" name="idm46045309948784">
  </a>
  <p>
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   is a diagnostic program designed to
        emulate client load for a MySQL server and to report the timing
        of each stage. It works as if multiple clients are accessing the
        server.
  </p>
  <p>
   Invoke
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa93429323"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlslap <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span></code></pre>
  </div>
  <p>
   Some options such as
   <a class="link" href="mysqlslap.html#option_mysqlslap_create">
    <code class="option">
     --create
    </code>
   </a>
   or
   <a class="link" href="mysqlslap.html#option_mysqlslap_query">
    <code class="option">
     --query
    </code>
   </a>
   enable you to
        specify a string containing an SQL statement or a file
        containing statements. If you specify a file, by default it must
        contain one statement per line. (That is, the implicit statement
        delimiter is the newline character.) Use the
   <a class="link" href="mysqlslap.html#option_mysqlslap_delimiter">
    <code class="option">
     --delimiter
    </code>
   </a>
   option to specify
        a different delimiter, which enables you to specify statements
        that span multiple lines or place multiple statements on a
        single line. You cannot include comments in a file;
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   does not understand them.
  </p>
  <p>
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   runs in three stages:
  </p>
  <div class="orderedlist">
   <ol class="orderedlist" type="1">
    <li class="listitem">
     <p>
      Create schema, table, and optionally any stored programs or
            data to use for the test. This stage uses a single client
            connection.
     </p>
    </li>
    <li class="listitem">
     <p>
      Run the load test. This stage can use many client
            connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      Clean up (disconnect, drop table if specified). This stage
            uses a single client connection.
     </p>
    </li>
   </ol>
  </div>
  <p>
   Examples:
  </p>
  <p>
   Supply your own create and query SQL statements, with 50 clients
        querying and 200 selects for each (enter the command on a single
        line):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa9892498"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlslap <span class="token constant">--delimiter</span>=<span class="token atrule">";"</span>
  <span class="token constant">--create</span>=<span class="token atrule">"CREATE TABLE a (b int);INSERT INTO a VALUES (23)"</span>
  <span class="token constant">--query</span>=<span class="token atrule">"SELECT * FROM a"</span> <span class="token constant">--concurrency</span><span class="token attr-value"><span class="token punctuation">=</span>50</span> <span class="token constant">--iterations</span><span class="token attr-value"><span class="token punctuation">=</span>200</span></code></pre>
  </div>
  <p>
   Let
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   build the query SQL statement
        with a table of two
   <a class="link" href="integer-types.html" title="13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT">
    <code class="literal">
     INT
    </code>
   </a>
   columns
        and three
   <a class="link" href="char.html" title="13.3.2 The CHAR and VARCHAR Types">
    <code class="literal">
     VARCHAR
    </code>
   </a>
   columns. Use
        five clients querying 20 times each. Do not create the table or
        insert the data (that is, use the previous test's schema and
        data):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa26697644"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlslap <span class="token constant">--concurrency</span><span class="token attr-value"><span class="token punctuation">=</span>5</span> <span class="token constant">--iterations</span><span class="token attr-value"><span class="token punctuation">=</span>20</span>
  <span class="token constant">--number-int-cols</span><span class="token attr-value"><span class="token punctuation">=</span>2</span> <span class="token constant">--number-char-cols</span><span class="token attr-value"><span class="token punctuation">=</span>3</span>
  <span class="token property">--auto-generate-sql</span></code></pre>
  </div>
  <p>
   Tell the program to load the create, insert, and query SQL
        statements from the specified files, where the
   <code class="filename">
    create.sql
   </code>
   file has multiple table creation
        statements delimited by
   <code class="literal">
    ';'
   </code>
   and multiple
        insert statements delimited by
   <code class="literal">
    ';'
   </code>
   . The
   <code class="option">
    --query
   </code>
   file should contain multiple queries
        delimited by
   <code class="literal">
    ';'
   </code>
   . Run all the load
        statements, then run all the queries in the query file with five
        clients (five times each):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa73481022"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlslap <span class="token constant">--concurrency</span><span class="token attr-value"><span class="token punctuation">=</span>5</span>
  <span class="token constant">--iterations</span><span class="token attr-value"><span class="token punctuation">=</span>5</span> <span class="token constant">--query</span><span class="token attr-value"><span class="token punctuation">=</span>query.sql</span> <span class="token constant">--create</span><span class="token attr-value"><span class="token punctuation">=</span>create.sql</span>
  <span class="token constant">--delimiter</span>=<span class="token atrule">";"</span></code></pre>
  </div>
  <p>
   <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
    <span class="command">
     <strong>
      mysqlslap
     </strong>
    </span>
   </a>
   supports the following options,
        which can be specified on the command line or in the
   <code class="literal">
    [mysqlslap]
   </code>
   and
   <code class="literal">
    [client]
   </code>
   groups of an option file. For information about option files
        used by MySQL programs, see
   <a class="xref" href="option-files.html" title="6.2.2.2 Using Option Files">
    Section 6.2.2.2, “Using Option Files”
   </a>
   .
  </p>
  <div class="table">
   <a name="idm46045309915744">
   </a>
   <p class="title">
    <b>
     Table 6.16 mysqlslap Options
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Command-line options available for mysqlslap.">
     <colgroup>
      <col style="width: 35%"/>
      <col style="width: 64%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Option Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql">
         --auto-generate-sql
        </a>
       </td>
       <td>
        Generate SQL statements automatically when they are not supplied in files or using command options
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-add-autoincrement">
         --auto-generate-sql-add-autoincrement
        </a>
       </td>
       <td>
        Add AUTO_INCREMENT column to automatically generated tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-execute-number">
         --auto-generate-sql-execute-number
        </a>
       </td>
       <td>
        Specify how many queries to generate automatically
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-guid-primary">
         --auto-generate-sql-guid-primary
        </a>
       </td>
       <td>
        Add a GUID-based primary key to automatically generated tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-load-type">
         --auto-generate-sql-load-type
        </a>
       </td>
       <td>
        Specify the test load type
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-secondary-indexes">
         --auto-generate-sql-secondary-indexes
        </a>
       </td>
       <td>
        Specify how many secondary indexes to add to automatically generated tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-unique-query-number">
         --auto-generate-sql-unique-query-number
        </a>
       </td>
       <td>
        How many different queries to generate for automatic tests
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-unique-write-number">
         --auto-generate-sql-unique-write-number
        </a>
       </td>
       <td>
        How many different queries to generate for --auto-generate-sql-write-number
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-write-number">
         --auto-generate-sql-write-number
        </a>
       </td>
       <td>
        How many row inserts to perform on each thread
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_commit">
         --commit
        </a>
       </td>
       <td>
        How many statements to execute before committing
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_compress">
         --compress
        </a>
       </td>
       <td>
        Compress all information sent between client and server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_compression-algorithms">
         --compression-algorithms
        </a>
       </td>
       <td>
        Permitted compression algorithms for connections to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_concurrency">
         --concurrency
        </a>
       </td>
       <td>
        Number of clients to simulate when issuing the SELECT statement
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_create">
         --create
        </a>
       </td>
       <td>
        File or string containing the statement to use for creating the table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_create-schema">
         --create-schema
        </a>
       </td>
       <td>
        Schema in which to run the tests
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_csv">
         --csv
        </a>
       </td>
       <td>
        Generate output in comma-separated values format
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_debug">
         --debug
        </a>
       </td>
       <td>
        Write debugging log
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_debug-check">
         --debug-check
        </a>
       </td>
       <td>
        Print debugging information when program exits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_debug-info">
         --debug-info
        </a>
       </td>
       <td>
        Print debugging information, memory, and CPU statistics when program exits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_default-auth">
         --default-auth
        </a>
       </td>
       <td>
        Authentication plugin to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-extra-file">
         --defaults-extra-file
        </a>
       </td>
       <td>
        Read named option file in addition to usual option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-file">
         --defaults-file
        </a>
       </td>
       <td>
        Read only named option file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-group-suffix">
         --defaults-group-suffix
        </a>
       </td>
       <td>
        Option group suffix value
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_delimiter">
         --delimiter
        </a>
       </td>
       <td>
        Delimiter to use in SQL statements
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_detach">
         --detach
        </a>
       </td>
       <td>
        Detach (close and reopen) each connection after each N statements
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_enable-cleartext-plugin">
         --enable-cleartext-plugin
        </a>
       </td>
       <td>
        Enable cleartext authentication plugin
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_engine">
         --engine
        </a>
       </td>
       <td>
        Storage engine to use for creating the table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_get-server-public-key">
         --get-server-public-key
        </a>
       </td>
       <td>
        Request RSA public key from server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_help">
         --help
        </a>
       </td>
       <td>
        Display help message and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_host">
         --host
        </a>
       </td>
       <td>
        Host on which MySQL server is located
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_iterations">
         --iterations
        </a>
       </td>
       <td>
        Number of times to run the tests
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_login-path">
         --login-path
        </a>
       </td>
       <td>
        Read login path options from .mylogin.cnf
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_no-defaults">
         --no-defaults
        </a>
       </td>
       <td>
        Read no option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_no-drop">
         --no-drop
        </a>
       </td>
       <td>
        Do not drop any schema created during the test run
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_no-login-paths">
         --no-login-paths
        </a>
       </td>
       <td>
        Do not read login paths from the login path file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_number-char-cols">
         --number-char-cols
        </a>
       </td>
       <td>
        Number of VARCHAR columns to use if --auto-generate-sql is specified
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_number-int-cols">
         --number-int-cols
        </a>
       </td>
       <td>
        Number of INT columns to use if --auto-generate-sql is specified
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_number-of-queries">
         --number-of-queries
        </a>
       </td>
       <td>
        Limit each client to approximately this number of queries
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_only-print">
         --only-print
        </a>
       </td>
       <td>
        Do not connect to databases. mysqlslap only prints what it would have done
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_password">
         --password
        </a>
       </td>
       <td>
        Password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
         --password1
        </a>
       </td>
       <td>
        First multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_password2">
         --password2
        </a>
       </td>
       <td>
        Second multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_password3">
         --password3
        </a>
       </td>
       <td>
        Third multifactor authentication password to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_pipe">
         --pipe
        </a>
       </td>
       <td>
        Connect to server using named pipe (Windows only)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_plugin-dir">
         --plugin-dir
        </a>
       </td>
       <td>
        Directory where plugins are installed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_port">
         --port
        </a>
       </td>
       <td>
        TCP/IP port number for connection
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_post-query">
         --post-query
        </a>
       </td>
       <td>
        File or string containing the statement to execute after the tests have completed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_post-system">
         --post-system
        </a>
       </td>
       <td>
        String to execute using system() after the tests have completed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_pre-query">
         --pre-query
        </a>
       </td>
       <td>
        File or string containing the statement to execute before running the tests
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_pre-system">
         --pre-system
        </a>
       </td>
       <td>
        String to execute using system() before running the tests
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_print-defaults">
         --print-defaults
        </a>
       </td>
       <td>
        Print default options
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_protocol">
         --protocol
        </a>
       </td>
       <td>
        Transport protocol to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_query">
         --query
        </a>
       </td>
       <td>
        File or string containing the SELECT statement to use for retrieving data
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_server-public-key-path">
         --server-public-key-path
        </a>
       </td>
       <td>
        Path name to file containing RSA public key
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_shared-memory-base-name">
         --shared-memory-base-name
        </a>
       </td>
       <td>
        Shared-memory name for shared-memory connections (Windows only)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_silent">
         --silent
        </a>
       </td>
       <td>
        Silent mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_socket">
         --socket
        </a>
       </td>
       <td>
        Unix socket file or Windows named pipe to use
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_sql-mode">
         --sql-mode
        </a>
       </td>
       <td>
        Set SQL mode for client session
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-ca
        </a>
       </td>
       <td>
        File that contains list of trusted SSL Certificate Authorities
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-capath
        </a>
       </td>
       <td>
        Directory that contains trusted SSL Certificate Authority certificate files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-cert
        </a>
       </td>
       <td>
        File that contains X.509 certificate
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-cipher
        </a>
       </td>
       <td>
        Permissible ciphers for connection encryption
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-crl
        </a>
       </td>
       <td>
        File that contains certificate revocation lists
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-crlpath
        </a>
       </td>
       <td>
        Directory that contains certificate revocation-list files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
         --ssl-fips-mode
        </a>
       </td>
       <td>
        Whether to enable FIPS mode on client side
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-key
        </a>
       </td>
       <td>
        File that contains X.509 key
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-mode
        </a>
       </td>
       <td>
        Desired security state of connection to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-session-data
        </a>
       </td>
       <td>
        File that contains SSL session data
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_ssl">
         --ssl-session-data-continue-on-failed-reuse
        </a>
       </td>
       <td>
        Whether to establish connections if session reuse fails
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_tls-ciphersuites">
         --tls-ciphersuites
        </a>
       </td>
       <td>
        Permissible TLSv1.3 ciphersuites for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_tls-sni-servername">
         --tls-sni-servername
        </a>
       </td>
       <td>
        Server name supplied by the client
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_tls-version">
         --tls-version
        </a>
       </td>
       <td>
        Permissible TLS protocols for encrypted connections
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_user">
         --user
        </a>
       </td>
       <td>
        MySQL user name to use when connecting to server
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_verbose">
         --verbose
        </a>
       </td>
       <td>
        Verbose mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_version">
         --version
        </a>
       </td>
       <td>
        Display version information and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="mysqlslap.html#option_mysqlslap_zstd-compression-level">
         --zstd-compression-level
        </a>
       </td>
       <td>
        Compression level for connections to server that use zstd compression
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th style="width: 260.906px;">
        Option Name
       </th>
       <th style="width: 477.094px;">
        Description
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_help">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_help">
       <code class="option">
        --help
       </code>
      </a>
      ,
      <code class="option">
       -?
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309693136">
     </a>
     <a class="indexterm" name="idm46045309691648">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql">
       <code class="option">
        --auto-generate-sql
       </code>
      </a>
      ,
      <code class="option">
       -a
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309677072">
     </a>
     <a class="indexterm" name="idm46045309675568">
     </a>
     <p>
      Generate SQL statements automatically when they are not
            supplied in files or using command options.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-add-autoincrement">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-add-autoincrement">
       <code class="option">
        --auto-generate-sql-add-autoincrement
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-add-autoincrement">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-add-autoincrement
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309661216">
     </a>
     <a class="indexterm" name="idm46045309659696">
     </a>
     <p>
      Add an
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column to
            automatically generated tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-execute-number">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-execute-number">
       <code class="option">
        --auto-generate-sql-execute-number=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-execute-number">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-execute-number=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309646864">
     </a>
     <a class="indexterm" name="idm46045309645360">
     </a>
     <p>
      Specify how many queries to generate automatically.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-guid-primary">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-guid-primary">
       <code class="option">
        --auto-generate-sql-guid-primary
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-guid-primary">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-guid-primary
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309631056">
     </a>
     <a class="indexterm" name="idm46045309629552">
     </a>
     <p>
      Add a GUID-based primary key to automatically generated
            tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-load-type">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-load-type">
       <code class="option">
        --auto-generate-sql-load-type=
        <em class="replaceable">
         <code>
          type
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-load-type">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-load-type=type
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           mixed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            read
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            write
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            key
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            update
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            mixed
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309608288">
     </a>
     <a class="indexterm" name="idm46045309606784">
     </a>
     <p>
      Specify the test load type. The permissible values are
      <code class="literal">
       read
      </code>
      (scan tables),
      <code class="literal">
       write
      </code>
      (insert into tables),
      <code class="literal">
       key
      </code>
      (read primary keys),
      <code class="literal">
       update
      </code>
      (update primary keys), or
      <code class="literal">
       mixed
      </code>
      (half inserts, half scanning
            selects). The default is
      <code class="literal">
       mixed
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-secondary-indexes">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-secondary-indexes">
       <code class="option">
        --auto-generate-sql-secondary-indexes=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-secondary-indexes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-secondary-indexes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309587856">
     </a>
     <a class="indexterm" name="idm46045309586336">
     </a>
     <p>
      Specify how many secondary indexes to add to automatically
            generated tables. By default, none are added.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-unique-query-number">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-unique-query-number">
       <code class="option">
        --auto-generate-sql-unique-query-number=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-unique-query-number">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-unique-query-number=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           10
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309571648">
     </a>
     <a class="indexterm" name="idm46045309570128">
     </a>
     <p>
      How many different queries to generate for automatic tests.
            For example, if you run a
      <code class="literal">
       key
      </code>
      test that
            performs 1000 selects, you can use this option with a value
            of 1000 to run 1000 unique queries, or with a value of 50 to
            perform 50 different selects. The default is 10.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-unique-write-number">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-unique-write-number">
       <code class="option">
        --auto-generate-sql-unique-write-number=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-unique-write-number">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-unique-write-number=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           10
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309554624">
     </a>
     <a class="indexterm" name="idm46045309553104">
     </a>
     <p>
      How many different queries to generate for
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-write-number">
       <code class="option">
        --auto-generate-sql-write-number
       </code>
      </a>
      .
            The default is 10.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_auto-generate-sql-write-number">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql-write-number">
       <code class="option">
        --auto-generate-sql-write-number=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for auto-generate-sql-write-number">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --auto-generate-sql-write-number=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           100
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309537456">
     </a>
     <a class="indexterm" name="idm46045309535952">
     </a>
     <p>
      How many row inserts to perform. The default is 100.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_commit">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_commit">
       <code class="option">
        --commit=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for commit">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --commit=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309521616">
     </a>
     <a class="indexterm" name="idm46045309520128">
     </a>
     <p>
      How many statements to execute before committing. The
            default is 0 (no commits are done).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_compress">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_compress">
       <code class="option">
        --compress
       </code>
      </a>
      ,
      <code class="option">
       -C
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for compress">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --compress[={OFF|ON}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           OFF
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309503472">
     </a>
     <a class="indexterm" name="idm46045309501984">
     </a>
     <p>
      Compress all information sent between the client and the
            server if possible. See
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
     <p>
      This option is deprecated. Expect it to be removed in a
            future version of MySQL. See
      <a class="xref" href="connection-compression-control.html#connection-compression-legacy-configuration" title="Configuring Legacy Connection Compression">
       Configuring Legacy Connection Compression
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_compression-algorithms">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_compression-algorithms">
       <code class="option">
        --compression-algorithms=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for compression-algorithms">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --compression-algorithms=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Set
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           uncompressed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            zlib
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            zstd
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            uncompressed
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309480800">
     </a>
     <a class="indexterm" name="idm46045309479296">
     </a>
     <p>
      The permitted compression algorithms for connections to the
            server. The available algorithms are the same as for the
      <a class="link" href="server-system-variables.html#sysvar_protocol_compression_algorithms">
       <code class="literal">
        protocol_compression_algorithms
       </code>
      </a>
      system variable. The default value is
      <code class="literal">
       uncompressed
      </code>
      .
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_concurrency">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_concurrency">
       <code class="option">
        --concurrency=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -c
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for concurrency">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --concurrency=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309463344">
     </a>
     <a class="indexterm" name="idm46045309461856">
     </a>
     <p>
      The number of parallel clients to simulate.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_create">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_create">
       <code class="option">
        --create=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for create">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --create=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309449936">
     </a>
     <a class="indexterm" name="idm46045309448448">
     </a>
     <p>
      The file or string containing the statement to use for
            creating the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_create-schema">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_create-schema">
       <code class="option">
        --create-schema=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for create-schema">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --create-schema=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309436400">
     </a>
     <a class="indexterm" name="idm46045309434912">
     </a>
     <p>
      The schema in which to run the tests.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If the
       <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql">
        <code class="option">
         --auto-generate-sql
        </code>
       </a>
       option is also given,
       <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
        <span class="command">
         <strong>
          mysqlslap
         </strong>
        </span>
       </a>
       drops
              the schema at the end of the test run. To avoid this, use
              the
       <a class="link" href="mysqlslap.html#option_mysqlslap_no-drop">
        <code class="option">
         --no-drop
        </code>
       </a>
       option as
              well.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_csv">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_csv">
       <code class="option">
        --csv[=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for csv">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --csv=[file]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309418704">
     </a>
     <a class="indexterm" name="idm46045309417216">
     </a>
     <p>
      Generate output in comma-separated values format. The output
            goes to the named file, or to the standard output if no file
            is given.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_debug">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_debug">
       <code class="option">
        --debug[=
        <em class="replaceable">
         <code>
          debug_options
         </code>
        </em>
        ]
       </code>
      </a>
      ,
      <code class="option">
       -#
            [
       <em class="replaceable">
        <code>
         debug_options
        </code>
       </em>
       ]
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug[=debug_options]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           d:t:o,/tmp/mysqlslap.trace
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309401728">
     </a>
     <a class="indexterm" name="idm46045309400240">
     </a>
     <p>
      Write a debugging log. A typical
      <em class="replaceable">
       <code>
        debug_options
       </code>
      </em>
      string is
      <code class="literal">
       d:t:o,
       <em class="replaceable">
        <code>
         file_name
        </code>
       </em>
      </code>
      .
            The default is
      <code class="literal">
       d:t:o,/tmp/mysqlslap.trace
      </code>
      .
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_debug-check">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_debug-check">
       <code class="option">
        --debug-check
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug-check
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309381920">
     </a>
     <a class="indexterm" name="idm46045309380432">
     </a>
     <p>
      Print some debugging information when the program exits.
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_debug-info">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_debug-info">
       <code class="option">
        --debug-info
       </code>
      </a>
      ,
      <code class="option">
       -T
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for debug-info">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --debug-info
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309363904">
     </a>
     <a class="indexterm" name="idm46045309362416">
     </a>
     <p>
      Print debugging information and memory and CPU usage
            statistics when the program exits.
     </p>
     <p>
      This option is available only if MySQL was built using
      <a class="link" href="source-configuration-options.html#option_cmake_with_debug">
       <code class="option">
        WITH_DEBUG
       </code>
      </a>
      . MySQL release
            binaries provided by Oracle are
      <span class="emphasis">
       <em>
        not
       </em>
      </span>
      built using this option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_default-auth">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_default-auth">
       <code class="option">
        --default-auth=
        <em class="replaceable">
         <code>
          plugin
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for default-auth">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --default-auth=plugin
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309348416">
     </a>
     <a class="indexterm" name="idm46045309346928">
     </a>
     <p>
      A hint about which client-side authentication plugin to use.
            See
      <a class="xref" href="pluggable-authentication.html" title="8.2.17 Pluggable Authentication">
       Section 8.2.17, “Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_defaults-extra-file">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-extra-file">
       <code class="option">
        --defaults-extra-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309334176">
     </a>
     <a class="indexterm" name="idm46045309332672">
     </a>
     <p>
      Read this option file after the global option file but (on
            Unix) before the user option file. If the file does not
            exist or is otherwise inaccessible, an error occurs. If
      <em class="replaceable">
       <code>
        file_name
       </code>
      </em>
      is not an absolute path
            name, it is interpreted relative to the current directory.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_defaults-file">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-file">
       <code class="option">
        --defaults-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309318768">
     </a>
     <a class="indexterm" name="idm46045309317280">
     </a>
     <p>
      Use only the given option file. If the file does not exist
            or is otherwise inaccessible, an error occurs. If
      <em class="replaceable">
       <code>
        file_name
       </code>
      </em>
      is not an absolute path
            name, it is interpreted relative to the current directory.
     </p>
     <p>
      Exception: Even with
      <a class="link" href="option-file-options.html#option_general_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
      , client
            programs read
      <code class="filename">
       .mylogin.cnf
      </code>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_defaults-group-suffix">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309301312">
     </a>
     <a class="indexterm" name="idm46045309299808">
     </a>
     <p>
      Read not only the usual option groups, but also groups with
            the usual names and a suffix of
      <em class="replaceable">
       <code>
        str
       </code>
      </em>
      . For example,
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      normally reads the
      <code class="literal">
       [client]
      </code>
      and
      <code class="literal">
       [mysqlslap]
      </code>
      groups. If this option is
            given as
      <a class="link" href="mysqlslap.html#option_mysqlslap_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=_other
       </code>
      </a>
      ,
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      also reads the
      <code class="literal">
       [client_other]
      </code>
      and
      <code class="literal">
       [mysqlslap_other]
      </code>
      groups.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_delimiter">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_delimiter">
       <code class="option">
        --delimiter=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -F
       <em class="replaceable">
        <code>
         str
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for delimiter">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --delimiter=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309279008">
     </a>
     <a class="indexterm" name="idm46045309277520">
     </a>
     <p>
      The delimiter to use in SQL statements supplied in files or
            using command options.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_detach">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_detach">
       <code class="option">
        --detach=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for detach">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --detach=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309263168">
     </a>
     <a class="indexterm" name="idm46045309261680">
     </a>
     <p>
      Detach (close and reopen) each connection after each
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      statements. The default is 0
            (connections are not detached).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_enable-cleartext-plugin">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_enable-cleartext-plugin">
       <code class="option">
        --enable-cleartext-plugin
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for enable-cleartext-plugin">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --enable-cleartext-plugin
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309246864">
     </a>
     <a class="indexterm" name="idm46045309245360">
     </a>
     <p>
      Enable the
      <code class="literal">
       mysql_clear_password
      </code>
      cleartext
            authentication plugin. (See
      <a class="xref" href="cleartext-pluggable-authentication.html" title="8.4.1.4 Client-Side Cleartext Pluggable Authentication">
       Section 8.4.1.4, “Client-Side Cleartext Pluggable Authentication”
      </a>
      .)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_engine">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_engine">
       <code class="option">
        --engine=
        <em class="replaceable">
         <code>
          engine_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -e
       <em class="replaceable">
        <code>
         engine_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for engine">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --engine=engine_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309231344">
     </a>
     <a class="indexterm" name="idm46045309229856">
     </a>
     <p>
      The storage engine to use for creating tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_get-server-public-key">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for get-server-public-key">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --get-server-public-key
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309218144">
     </a>
     <a class="indexterm" name="idm46045309216640">
     </a>
     <p>
      Request from the server the RSA public key that it uses for
            key pair-based password exchange. This option applies to
            clients that connect to the server using an account that
            authenticates with the
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
            plugin. For connections by such accounts, the server does
            not send the public key to the client unless requested. The
            option is ignored for accounts that do not authenticate with
            that plugin. It is also ignored if RSA-based password
            exchange is not needed, as is the case when the client
            connects to the server using a secure connection.
     </p>
     <p>
      If
      <a class="link" href="mysqlslap.html#option_mysqlslap_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      is given and specifies a valid public key file, it takes
            precedence over
      <a class="link" href="mysqlslap.html#option_mysqlslap_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
      .
     </p>
     <p>
      For information about the
      <code class="literal">
       caching_sha2_password
      </code>
      plugin, see
      <a class="xref" href="caching-sha2-pluggable-authentication.html" title="8.4.1.2 Caching SHA-2 Pluggable Authentication">
       Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_host">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_host">
       <code class="option">
        --host=
        <em class="replaceable">
         <code>
          host_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -h
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --host=host_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           localhost
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309195520">
     </a>
     <a class="indexterm" name="idm46045309194032">
     </a>
     <p>
      Connect to the MySQL server on the given host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_iterations">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_iterations">
       <code class="option">
        --iterations=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -i
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for iterations">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --iterations=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309181392">
     </a>
     <a class="indexterm" name="idm46045309179904">
     </a>
     <p>
      The number of times to run the tests.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_login-path">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_login-path">
       <code class="option">
        --login-path=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309167904">
     </a>
     <a class="indexterm" name="idm46045309166416">
     </a>
     <p>
      Read options from the named login path in the
      <code class="filename">
       .mylogin.cnf
      </code>
      login path file. A
      <span class="quote">
       “
       <span class="quote">
        login path
       </span>
       ”
      </span>
      is an option group containing
            options that specify which MySQL server to connect to and
            which account to authenticate as. To create or modify a
            login path file, use the
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
      utility. See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_no-login-paths">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309152272">
     </a>
     <a class="indexterm" name="idm46045309150784">
     </a>
     <p>
      Skips reading options from the login path file.
     </p>
     <p>
      See
      <a class="link" href="mysqlslap.html#option_mysqlslap_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
      for
            related information.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_no-drop">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_no-drop">
       <code class="option">
        --no-drop
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-drop">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-drop
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309133984">
     </a>
     <a class="indexterm" name="idm46045309132496">
     </a>
     <p>
      Prevent
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      from dropping any
            schema it creates during the test run.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_no-defaults">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309121632">
     </a>
     <a class="indexterm" name="idm46045309120144">
     </a>
     <p>
      Do not read any option files. If program startup fails due
            to reading unknown options from an option file,
      <a class="link" href="mysqlslap.html#option_mysqlslap_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
      can be used
            to prevent them from being read.
     </p>
     <p>
      The exception is that the
      <code class="filename">
       .mylogin.cnf
      </code>
      file is read in all cases, if it exists. This permits
            passwords to be specified in a safer way than on the command
            line even when
      <a class="link" href="mysqlslap.html#option_mysqlslap_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
      is used. To
            create
      <code class="filename">
       .mylogin.cnf
      </code>
      , use the
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
      utility. See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_number-char-cols">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_number-char-cols">
       <code class="option">
        --number-char-cols=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -x
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for number-char-cols">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --number-char-cols=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309100208">
     </a>
     <a class="indexterm" name="idm46045309098720">
     </a>
     <p>
      The number of
      <a class="link" href="char.html" title="13.3.2 The CHAR and VARCHAR Types">
       <code class="literal">
        VARCHAR
       </code>
      </a>
      columns
            to use if
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql">
       <code class="option">
        --auto-generate-sql
       </code>
      </a>
      is
            specified.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_number-int-cols">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_number-int-cols">
       <code class="option">
        --number-int-cols=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -y
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for number-int-cols">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --number-int-cols=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309083840">
     </a>
     <a class="indexterm" name="idm46045309082352">
     </a>
     <p>
      The number of
      <a class="link" href="integer-types.html" title="13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT">
       <code class="literal">
        INT
       </code>
      </a>
      columns to
            use if
      <a class="link" href="mysqlslap.html#option_mysqlslap_auto-generate-sql">
       <code class="option">
        --auto-generate-sql
       </code>
      </a>
      is specified.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_number-of-queries">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_number-of-queries">
       <code class="option">
        --number-of-queries=
        <em class="replaceable">
         <code>
          N
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for number-of-queries">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --number-of-queries=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309068192">
     </a>
     <a class="indexterm" name="idm46045309066688">
     </a>
     <p>
      Limit each client to approximately this many queries. Query
            counting takes into account the statement delimiter. For
            example, if you invoke
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      as
            follows, the
      <code class="literal">
       ;
      </code>
      delimiter is recognized so
            that each instance of the query string counts as two
            queries. As a result, 5 rows (not 10) are inserted.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa22345099"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlslap <span class="token constant">--delimiter</span>=<span class="token atrule">";"</span> <span class="token constant">--number-of-queries</span><span class="token attr-value"><span class="token punctuation">=</span>10</span>
          <span class="token constant">--query</span>=<span class="token atrule">"use test;insert into t values(null)"</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_only-print">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_only-print">
       <code class="option">
        --only-print
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for only-print">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --only-print
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           FALSE
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045309049264">
     </a>
     <a class="indexterm" name="idm46045309047776">
     </a>
     <p>
      Do not connect to databases.
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      only prints what it would have done.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_password">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_password">
       <code class="option">
        --password[=
        <em class="replaceable">
         <code>
          password
         </code>
        </em>
        ]
       </code>
      </a>
      ,
      <code class="option">
       -p[
       <em class="replaceable">
        <code>
         password
        </code>
       </em>
       ]
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for password">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --password[=password]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045340908352">
     </a>
     <a class="indexterm" name="idm46045340906864">
     </a>
     <p>
      The password of the MySQL account used for connecting to the
            server. The password value is optional. If not given,
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      prompts for one. If given,
            there must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqlslap.html#option_mysqlslap_password">
       <code class="option">
        --password=
       </code>
      </a>
      or
      <code class="option">
       -p
      </code>
      and the password following it. If no
            password option is specified, the default is to send no
            password.
     </p>
     <p>
      Specifying a password on the command line should be
            considered insecure. To avoid giving the password on the
            command line, use an option file. See
      <a class="xref" href="password-security-user.html" title="8.1.2.1 End-User Guidelines for Password Security">
       Section 8.1.2.1, “End-User Guidelines for Password Security”
      </a>
      .
     </p>
     <p>
      To explicitly specify that there is no password and that
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqlslap.html#option_mysqlslap_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_password1">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --password1[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045308934256">
     </a>
     <p>
      The password for multifactor authentication factor 1 of the
            MySQL account used for connecting to the server. The
            password value is optional. If not given,
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      prompts for one. If given,
            there must be
      <span class="emphasis">
       <em>
        no space
       </em>
      </span>
      between
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --password1=
       </code>
      </a>
      and the
            password following it. If no password option is specified,
            the default is to send no password.
     </p>
     <p>
      Specifying a password on the command line should be
            considered insecure. To avoid giving the password on the
            command line, use an option file. See
      <a class="xref" href="password-security-user.html" title="8.1.2.1 End-User Guidelines for Password Security">
       Section 8.1.2.1, “End-User Guidelines for Password Security”
      </a>
      .
     </p>
     <p>
      To explicitly specify that there is no password and that
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      should not prompt for one, use
            the
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      option.
     </p>
     <p>
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --password1
       </code>
      </a>
      and
      <a class="link" href="mysqlslap.html#option_mysqlslap_password">
       <code class="option">
        --password
       </code>
      </a>
      are synonymous,
            as are
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --skip-password1
       </code>
      </a>
      and
      <a class="link" href="mysqlslap.html#option_mysqlslap_password">
       <code class="option">
        --skip-password
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_password2">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_password2">
       <code class="option">
        --password2[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045308918960">
     </a>
     <p>
      The password for multifactor authentication factor 2 of the
            MySQL account used for connecting to the server. The
            semantics of this option are similar to the semantics for
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_password3">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_password3">
       <code class="option">
        --password3[=
        <em class="replaceable">
         <code>
          pass_val
         </code>
        </em>
        ]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045308913728">
     </a>
     <p>
      The password for multifactor authentication factor 3 of the
            MySQL account used for connecting to the server. The
            semantics of this option are similar to the semantics for
      <a class="link" href="mysqlslap.html#option_mysqlslap_password1">
       <code class="option">
        --password1
       </code>
      </a>
      ; see the
            description of that option for details.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_pipe">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_pipe">
       <code class="option">
        --pipe
       </code>
      </a>
      ,
      <code class="option">
       -W
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pipe">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pipe
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308901056">
     </a>
     <a class="indexterm" name="idm46045308899568">
     </a>
     <p>
      On Windows, connect to the server using a named pipe. This
            option applies only if the server was started with the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe">
       <code class="literal">
        named_pipe
       </code>
      </a>
      system variable
            enabled to support named-pipe connections. In addition, the
            user making the connection must be a member of the Windows
            group specified by the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe_full_access_group">
       <code class="literal">
        named_pipe_full_access_group
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_plugin-dir">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_plugin-dir">
       <code class="option">
        --plugin-dir=
        <em class="replaceable">
         <code>
          dir_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for plugin-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --plugin-dir=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308884944">
     </a>
     <a class="indexterm" name="idm46045308883456">
     </a>
     <p>
      The directory in which to look for plugins. Specify this
            option if the
      <a class="link" href="mysqlslap.html#option_mysqlslap_default-auth">
       <code class="option">
        --default-auth
       </code>
      </a>
      option is
            used to specify an authentication plugin but
      <a class="link" href="mysqlslap.html" title="6.5.7 mysqlslap — A Load Emulation Client">
       <span class="command">
        <strong>
         mysqlslap
        </strong>
       </span>
      </a>
      does not find it. See
      <a class="xref" href="pluggable-authentication.html" title="8.2.17 Pluggable Authentication">
       Section 8.2.17, “Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_port">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_port">
       <code class="option">
        --port=
        <em class="replaceable">
         <code>
          port_num
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -P
       <em class="replaceable">
        <code>
         port_num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for port">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --port=port_num
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           3306
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308865456">
     </a>
     <a class="indexterm" name="idm46045308863968">
     </a>
     <p>
      For TCP/IP connections, the port number to use.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_post-query">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_post-query">
       <code class="option">
        --post-query=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for post-query">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --post-query=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308852096">
     </a>
     <a class="indexterm" name="idm46045308850608">
     </a>
     <p>
      The file or string containing the statement to execute after
            the tests have completed. This execution is not counted for
            timing purposes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_post-system">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_post-system">
       <code class="option">
        --post-system=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for post-system">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --post-system=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308838640">
     </a>
     <a class="indexterm" name="idm46045308837152">
     </a>
     <p>
      The string to execute using
      <code class="literal">
       system()
      </code>
      after the tests have completed. This execution is not
            counted for timing purposes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_pre-query">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_pre-query">
       <code class="option">
        --pre-query=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pre-query">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pre-query=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308824544">
     </a>
     <a class="indexterm" name="idm46045308823056">
     </a>
     <p>
      The file or string containing the statement to execute
            before running the tests. This execution is not counted for
            timing purposes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_pre-system">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_pre-system">
       <code class="option">
        --pre-system=
        <em class="replaceable">
         <code>
          str
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pre-system">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pre-system=str
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308811104">
     </a>
     <a class="indexterm" name="idm46045308809680">
     </a>
     <p>
      The string to execute using
      <code class="literal">
       system()
      </code>
      before running the tests. This execution is not counted for
            timing purposes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_print-defaults">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308800080">
     </a>
     <a class="indexterm" name="idm46045308798688">
     </a>
     <p>
      Print the program name and all options that it gets from
            option files.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_protocol">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_protocol">
       <code class="option">
        --protocol={TCP|SOCKET|PIPE|MEMORY}
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for protocol">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --protocol=type
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [see text]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            TCP
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            SOCKET
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            PIPE
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            MEMORY
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308779072">
     </a>
     <a class="indexterm" name="idm46045308777680">
     </a>
     <p>
      The transport protocol to use for connecting to the server.
            It is useful when the other connection parameters normally
            result in use of a protocol other than the one you want. For
            details on the permissible values, see
      <a class="xref" href="transport-protocols.html" title="6.2.7 Connection Transport Protocols">
       Section 6.2.7, “Connection Transport Protocols”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_query">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_query">
       <code class="option">
        --query=
        <em class="replaceable">
         <code>
          value
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -q
       <em class="replaceable">
        <code>
         value
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for query">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --query=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308765152">
     </a>
     <a class="indexterm" name="idm46045308763760">
     </a>
     <p>
      The file or string containing the
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statement to use for
            retrieving data.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_server-public-key-path">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for server-public-key-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --server-public-key-path=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308751520">
     </a>
     <a class="indexterm" name="idm46045308750128">
     </a>
     <p>
      The path name to a file in PEM format containing a
            client-side copy of the public key required by the server
            for RSA key pair-based password exchange. This option
            applies to clients that authenticate with the
      <code class="literal">
       sha256_password
      </code>
      (deprecated) or
      <code class="literal">
       caching_sha2_password
      </code>
      authentication
            plugin. This option is ignored for accounts that do not
            authenticate with one of those plugins. It is also ignored
            if RSA-based password exchange is not used, as is the case
            when the client connects to the server using a secure
            connection.
     </p>
     <p>
      If
      <a class="link" href="mysqlslap.html#option_mysqlslap_server-public-key-path">
       <code class="option">
        --server-public-key-path=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      is given and specifies a valid public key file, it takes
            precedence over
      <a class="link" href="mysqlslap.html#option_mysqlslap_get-server-public-key">
       <code class="option">
        --get-server-public-key
       </code>
      </a>
      .
     </p>
     <p>
      For
      <code class="literal">
       sha256_password
      </code>
      (deprecated), this
            option applies only if MySQL was built using OpenSSL.
     </p>
     <p>
      For information about the
      <code class="literal">
       sha256_password
      </code>
      and
      <code class="literal">
       caching_sha2_password
      </code>
      plugins, see
      <a class="xref" href="sha256-pluggable-authentication.html" title="8.4.1.3 SHA-256 Pluggable Authentication">
       Section 8.4.1.3, “SHA-256 Pluggable Authentication”
      </a>
      , and
      <a class="xref" href="caching-sha2-pluggable-authentication.html" title="8.4.1.2 Caching SHA-2 Pluggable Authentication">
       Section 8.4.1.2, “Caching SHA-2 Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_shared-memory-base-name">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_shared-memory-base-name">
       <code class="option">
        --shared-memory-base-name=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for shared-memory-base-name">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --shared-memory-base-name=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Platform Specific
         </th>
         <td>
          Windows
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308731152">
     </a>
     <a class="indexterm" name="idm46045308729760">
     </a>
     <p>
      On Windows, the shared-memory name to use for connections
            made using shared memory to a local server. The default
            value is
      <code class="literal">
       MYSQL
      </code>
      . The shared-memory name is
            case-sensitive.
     </p>
     <p>
      This option applies only if the server was started with the
      <a class="link" href="server-system-variables.html#sysvar_shared_memory">
       <code class="literal">
        shared_memory
       </code>
      </a>
      system
            variable enabled to support shared-memory connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_silent">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_silent">
       <code class="option">
        --silent
       </code>
      </a>
      ,
      <code class="option">
       -s
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for silent">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --silent
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308718080">
     </a>
     <a class="indexterm" name="idm46045308716688">
     </a>
     <p>
      Silent mode. No output.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_socket">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_socket">
       <code class="option">
        --socket=
        <em class="replaceable">
         <code>
          path
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -S
       <em class="replaceable">
        <code>
         path
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for socket">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --socket={file_name|pipe_name}
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308704960">
     </a>
     <a class="indexterm" name="idm46045308703568">
     </a>
     <p>
      For connections to
      <code class="literal">
       localhost
      </code>
      , the Unix
            socket file to use, or, on Windows, the name of the named
            pipe to use.
     </p>
     <p>
      On Windows, this option applies only if the server was
            started with the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe">
       <code class="literal">
        named_pipe
       </code>
      </a>
      system variable enabled to support named-pipe connections.
            In addition, the user making the connection must be a member
            of the Windows group specified by the
      <a class="link" href="server-system-variables.html#sysvar_named_pipe_full_access_group">
       <code class="literal">
        named_pipe_full_access_group
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_sql-mode">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_sql-mode">
       <code class="option">
        --sql-mode=
        <em class="replaceable">
         <code>
          mode
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sql-mode">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sql-mode=mode
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308689024">
     </a>
     <a class="indexterm" name="idm46045308687632">
     </a>
     <p>
      Set the SQL mode for the client session.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_ssl">
      </a>
      <code class="option">
       --ssl*
      </code>
     </p>
     <a class="indexterm" name="idm46045308684384">
     </a>
     <a class="indexterm" name="idm46045308682992">
     </a>
     <p>
      Options that begin with
      <code class="option">
       --ssl
      </code>
      specify
            whether to connect to the server using encryption and
            indicate where to find SSL keys and certificates. See
      <a class="xref" href="connection-options.html#encrypted-connection-options" title="Command Options for Encrypted Connections">
       Command Options for Encrypted Connections
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_ssl-fips-mode">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode={OFF|ON|STRICT}
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ssl-fips-mode">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ssl-fips-mode={OFF|ON|STRICT}
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           OFF
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            OFF
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            ON
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            STRICT
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308662320">
     </a>
     <a class="indexterm" name="idm46045308660928">
     </a>
     <p>
      Controls whether to enable FIPS mode on the client side. The
      <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode
       </code>
      </a>
      option
            differs from other
      <code class="option">
       --ssl-
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      options in that it is not used to establish encrypted
            connections, but rather to affect which cryptographic
            operations to permit. See
      <a class="xref" href="fips-mode.html" title="8.8 FIPS Support">
       Section 8.8, “FIPS Support”
      </a>
      .
     </p>
     <p>
      These
      <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
       <code class="option">
        --ssl-fips-mode
       </code>
      </a>
      values are permitted:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          OFF
         </code>
         : Disable FIPS mode.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          ON
         </code>
         : Enable FIPS mode.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          STRICT
         </code>
         : Enable
         <span class="quote">
          “
          <span class="quote">
           strict
          </span>
          ”
         </span>
         FIPS mode.
        </p>
       </li>
      </ul>
     </div>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       If the OpenSSL FIPS Object Module is not available, the
              only permitted value for
       <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
        <code class="option">
         --ssl-fips-mode
        </code>
       </a>
       is
       <code class="literal">
        OFF
       </code>
       . In this case, setting
       <a class="link" href="mysqlslap.html#option_mysqlslap_ssl-fips-mode">
        <code class="option">
         --ssl-fips-mode
        </code>
       </a>
       to
       <code class="literal">
        ON
       </code>
       or
       <code class="literal">
        STRICT
       </code>
       causes
              the client to produce a warning at startup and to operate
              in non-FIPS mode.
      </p>
     </div>
     <p>
      This option is deprecated. Expect it to be removed in a
            future version of MySQL.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_tls-ciphersuites">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_tls-ciphersuites">
       <code class="option">
        --tls-ciphersuites=
        <em class="replaceable">
         <code>
          ciphersuite_list
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-ciphersuites">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-ciphersuites=ciphersuite_list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308636640">
     </a>
     <a class="indexterm" name="idm46045308635248">
     </a>
     <p>
      The permissible ciphersuites for encrypted connections that
            use TLSv1.3. The value is a list of one or more
            colon-separated ciphersuite names. The ciphersuites that can
            be named for this option depend on the SSL library used to
            compile MySQL. For details, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_tls-sni-servername">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_tls-sni-servername">
       <code class="option">
        --tls-sni-servername=
        <em class="replaceable">
         <code>
          server_name
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-sni-servername">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-sni-servername=server_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308623312">
     </a>
     <a class="indexterm" name="idm46045308621920">
     </a>
     <p>
      When specified, the name is passed to the
      <code class="literal">
       libmysqlclient
      </code>
      C API library using the
      <code class="literal">
       MYSQL_OPT_TLS_SNI_SERVERNAME
      </code>
      option of
      <a class="ulink" href="/doc/c-api/8.4/en/mysql-options.html" target="_top">
       <code class="literal">
        mysql_options()
       </code>
      </a>
      . The server
            name is not case-sensitive. To show which server name the
            client specified for the current session, if any, check the
      <a class="link" href="server-status-variables.html#statvar_Tls_sni_server_name">
       <code class="literal">
        Tls_sni_server_name
       </code>
      </a>
      status
            variable.
     </p>
     <p>
      Server Name Indication (SNI) is an extension to the TLS
            protocol (OpenSSL must be compiled using TLS extensions for
            this option to function). The MySQL implementation of SNI
            represents the client-side only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_tls-version">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_tls-version">
       <code class="option">
        --tls-version=
        <em class="replaceable">
         <code>
          protocol_list
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tls-version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tls-version=protocol_list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
           </code>
           (OpenSSL 1.1.1 or higher)
          </p>
          <p class="valid-value">
           <code class="literal">
            TLSv1,TLSv1.1,TLSv1.2
           </code>
           (otherwise)
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308602752">
     </a>
     <a class="indexterm" name="idm46045308601360">
     </a>
     <p>
      The permissible TLS protocols for encrypted connections. The
            value is a list of one or more comma-separated protocol
            names. The protocols that can be named for this option
            depend on the SSL library used to compile MySQL. For
            details, see
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_user">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_user">
       <code class="option">
        --user=
        <em class="replaceable">
         <code>
          user_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -u
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for user">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --user=user_name,
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308588816">
     </a>
     <a class="indexterm" name="idm46045308587424">
     </a>
     <p>
      The user name of the MySQL account to use for connecting to
            the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_verbose">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      ,
      <code class="option">
       -v
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for verbose">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --verbose
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308578064">
     </a>
     <a class="indexterm" name="idm46045308576672">
     </a>
     <p>
      Verbose mode. Print more information about what the program
            does. This option can be used multiple times to increase the
            amount of information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_version">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_version">
       <code class="option">
        --version
       </code>
      </a>
      ,
      <code class="option">
       -V
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308567232">
     </a>
     <a class="indexterm" name="idm46045308565840">
     </a>
     <p>
      Display version information and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqlslap_zstd-compression-level">
      </a>
      <a class="link" href="mysqlslap.html#option_mysqlslap_zstd-compression-level">
       <code class="option">
        --zstd-compression-level=
        <em class="replaceable">
         <code>
          level
         </code>
        </em>
       </code>
      </a>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for zstd-compression-level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --zstd-compression-level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308554672">
     </a>
     <a class="indexterm" name="idm46045308553280">
     </a>
     <p>
      The compression level to use for connections to the server
            that use the
      <code class="literal">
       zstd
      </code>
      compression algorithm.
            The permitted levels are from 1 to 22, with larger values
            indicating increasing levels of compression. The default
      <code class="literal">
       zstd
      </code>
      compression level is 3. The
            compression level setting has no effect on connections that
            do not use
      <code class="literal">
       zstd
      </code>
      compression.
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
