<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="x-plugin-options-system-variables">
      </a>
      22.5.6.2 X Plugin Options and System Variables
     </h4>
    </div>
   </div>
  </div>
  <p>
   To control activation of X Plugin, use this option:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_mysqld_mysqlx">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#option_mysqld_mysqlx">
       <code class="option">
        --mysqlx[=value]
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125788784">
     </a>
     <a class="indexterm" name="idm46045125787712">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx[=value]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ON
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            ON
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            OFF
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            FORCE
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            FORCE_PLUS_PERMANENT
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      This option controls how the server loads X Plugin at
            startup. In MySQL 8.4, X Plugin is enabled by
            default, but this option may be used to control its
            activation state.
     </p>
     <p>
      The option value should be one of those available for
            plugin-loading options, as described in
      <a class="xref" href="plugin-loading.html" title="7.6.1 Installing and Uninstalling Plugins">
       Section 7.6.1, “Installing and Uninstalling Plugins”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   If X Plugin is enabled, it exposes several system variables
        that permit control over its operation:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_bind_address">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_bind_address">
       <code class="literal">
        mysqlx_bind_address
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125765344">
     </a>
     <a class="indexterm" name="idm46045125764304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_bind_address">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-bind-address=addr
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_bind_address">
            mysqlx_bind_address
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           *
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The network address on which X Plugin listens for TCP/IP
            connections. This variable is not dynamic and can be
            configured only at startup. This is the X Plugin equivalent
            of the
      <a class="link" href="server-system-variables.html#sysvar_bind_address">
       <code class="literal">
        bind_address
       </code>
      </a>
      system
            variable; see that variable description for more
            information.
     </p>
     <p>
      By default, X Plugin accepts TCP/IP connections on all
            server host IPv4 interfaces, and, if the server host
            supports IPv6, on all IPv6 interfaces. If
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_bind_address">
       <code class="literal">
        mysqlx_bind_address
       </code>
      </a>
      is
            specified, its value must satisfy these requirements:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         A single address value, which may specify a single
                non-wildcard IP address (either IPv4 or IPv6), or a host
                name, or one of the wildcard address formats that permit
                listening on multiple network interfaces
                (
         <code class="literal">
          *
         </code>
         ,
         <code class="literal">
          0.0.0.0
         </code>
         , or
         <code class="literal">
          ::
         </code>
         ).
        </p>
       </li>
       <li class="listitem">
        <p>
         A list of comma-separated values. When the variable
                names a list of multiple values, each value must specify
                a single non-wildcard IP address (either IPv4 or IPv6)
                or a host name. Wildcard address formats
                (
         <code class="literal">
          *
         </code>
         ,
         <code class="literal">
          0.0.0.0
         </code>
         , or
         <code class="literal">
          ::
         </code>
         ) are not allowed in a list of
                values.
        </p>
       </li>
       <li class="listitem">
        <p>
         The value may also include a network namespace
                specifier.
        </p>
       </li>
      </ul>
     </div>
     <p>
      IP addresses can be specified as IPv4 or IPv6 addresses. For
            any value that is a host name, X Plugin resolves the name
            to an IP address and binds to that address. If a host name
            resolves to multiple IP addresses, X Plugin uses the first
            IPv4 address if there are any, or the first IPv6 address
            otherwise.
     </p>
     <p>
      X Plugin treats different types of addresses as follows:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         If the address is
         <code class="literal">
          *
         </code>
         , X Plugin
                accepts TCP/IP connections on all server host IPv4
                interfaces, and, if the server host supports IPv6, on
                all IPv6 interfaces. Use this address to permit both
                IPv4 and IPv6 connections for X Plugin. This value is
                the default. If the variable specifies a list of
                multiple values, this value is not permitted.
        </p>
       </li>
       <li class="listitem">
        <p>
         If the address is
         <code class="literal">
          0.0.0.0
         </code>
         , X Plugin
                accepts TCP/IP connections on all server host IPv4
                interfaces. If the variable specifies a list of multiple
                values, this value is not permitted.
        </p>
       </li>
       <li class="listitem">
        <p>
         If the address is
         <code class="literal">
          ::
         </code>
         , X Plugin
                accepts TCP/IP connections on all server host IPv4 and
                IPv6 interfaces. If the variable specifies a list of
                multiple values, this value is not permitted.
        </p>
       </li>
       <li class="listitem">
        <p>
         If the address is an IPv4-mapped address, X Plugin
                accepts TCP/IP connections for that address, in either
                IPv4 or IPv6 format. For example, if X Plugin is bound
                to
         <code class="literal">
          ::ffff:127.0.0.1
         </code>
         , a client such as
                MySQL Shell can connect using
         <code class="option">
          --host=127.0.0.1
         </code>
         or
         <code class="option">
          --host=::ffff:127.0.0.1
         </code>
         .
        </p>
       </li>
       <li class="listitem">
        <p>
         If the address is a
         <span class="quote">
          “
          <span class="quote">
           regular
          </span>
          ”
         </span>
         IPv4 or IPv6
                address (such as
         <code class="literal">
          127.0.0.1
         </code>
         or
         <code class="literal">
          ::1
         </code>
         ), X Plugin accepts TCP/IP
                connections only for that IPv4 or IPv6 address.
        </p>
       </li>
      </ul>
     </div>
     <p>
      These rules apply to specifying a network namespace for an
            address:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         A network namespace can be specified for an IP address
                or a host name.
        </p>
       </li>
       <li class="listitem">
        <p>
         A network namespace cannot be specified for a wildcard
                IP address.
        </p>
       </li>
       <li class="listitem">
        <p>
         For a given address, the network namespace is optional.
                If given, it must be specified as a
         <code class="literal">
          /
          <em class="replaceable">
           <code>
            ns
           </code>
          </em>
         </code>
         suffix
                immediately following the address.
        </p>
       </li>
       <li class="listitem">
        <p>
         An address with no
         <code class="literal">
          /
          <em class="replaceable">
           <code>
            ns
           </code>
          </em>
         </code>
         suffix
                uses the host system global namespace. The global
                namespace is therefore the default.
        </p>
       </li>
       <li class="listitem">
        <p>
         An address with a
         <code class="literal">
          /
          <em class="replaceable">
           <code>
            ns
           </code>
          </em>
         </code>
         suffix
                uses the namespace named
         <em class="replaceable">
          <code>
           ns
          </code>
         </em>
         .
        </p>
       </li>
       <li class="listitem">
        <p>
         The host system must support network namespaces and each
                named namespace must previously have been set up. Naming
                a nonexistent namespace produces an error.
        </p>
       </li>
       <li class="listitem">
        <p>
         If the variable value specifies multiple addresses, it
                can include addresses in the global namespace, in named
                namespaces, or a mix.
        </p>
       </li>
      </ul>
     </div>
     <p>
      For additional information about network namespaces, see
      <a class="xref" href="network-namespace-support.html" title="7.1.14 Network Namespace Support">
       Section 7.1.14, “Network Namespace Support”
      </a>
      .
     </p>
     <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Important
      </div>
      <p>
       Because X Plugin is not a mandatory plugin, it does not
              prevent server startup if there is an error in the
              specified address or list of addresses (as MySQL Server
              does for
       <a class="link" href="server-system-variables.html#sysvar_bind_address">
        <code class="literal">
         bind_address
        </code>
       </a>
       errors). With X Plugin, if one of the listed addresses
              cannot be parsed or if X Plugin cannot bind to it, the
              address is skipped, an error message is logged, and
              X Plugin attempts to bind to each of the remaining
              addresses. X Plugin's
       <a class="link" href="x-plugin-status-variables.html#statvar_Mysqlx_address">
        <code class="literal">
         Mysqlx_address
        </code>
       </a>
       status
              variable displays only those addresses from the list for
              which the bind succeeded. If none of the listed addresses
              results in a successful bind, or if a single specified
              address fails, X Plugin logs the error message
       <a class="ulink" href="/doc/mysql-errors/8.4/en/server-error-reference.html#error_er_xplugin_failed_to_prepare_io_interfaces" target="_top">
        <code class="literal">
         ER_XPLUGIN_FAILED_TO_PREPARE_IO_INTERFACES
        </code>
       </a>
       stating that X Protocol cannot be used.
       <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_bind_address">
        <code class="literal">
         mysqlx_bind_address
        </code>
       </a>
       is
              not dynamic, so to fix any issues you must stop the
              server, correct the system variable value, and restart the
              server.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_compression_algorithms">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_compression_algorithms">
       <code class="literal">
        mysqlx_compression_algorithms
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125697584">
     </a>
     <a class="indexterm" name="idm46045125696480">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_compression_algorithms">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-compression-algorithms=value
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_compression_algorithms">
            mysqlx_compression_algorithms
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Set
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           deflate_stream,lz4_message,zstd_stream
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            deflate_stream
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            lz4_message
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            zstd_stream
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The compression algorithms that are permitted for use on
            X Protocol connections. By default, the Deflate, LZ4, and
            zstd algorithms are all permitted. To disallow any of the
            algorithms, set
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_compression_algorithms">
       <code class="literal">
        mysqlx_compression_algorithms
       </code>
      </a>
      to include only the ones you permit. The algorithm names
      <code class="literal">
       deflate_stream
      </code>
      ,
      <code class="literal">
       lz4_message
      </code>
      , and
      <code class="literal">
       zstd_stream
      </code>
      can be specified in any
            combination, and the order and case are not important. If
            you set the system variable to the empty string, no
            compression algorithms are permitted and only uncompressed
            connections are used. Use the algorithm-specific system
            variables to adjust the default and maximum compression
            level for each permitted algorithm. For more details, and
            information on how connection compression for X Protocol
            relates to the equivalent settings for MySQL Server, see
      <a class="xref" href="x-plugin-connection-compression.html" title="22.5.5 Connection Compression with X Plugin">
       Section 22.5.5, “Connection Compression with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_connect_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_connect_timeout">
       <code class="literal">
        mysqlx_connect_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125662064">
     </a>
     <a class="indexterm" name="idm46045125661024">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_connect_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-connect-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_connect_timeout">
            mysqlx_connect_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           30
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1000000000
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds X Plugin waits for the first packet
            to be received from newly connected clients. This is the
            X Plugin equivalent of
      <a class="link" href="server-system-variables.html#sysvar_connect_timeout">
       <code class="literal">
        connect_timeout
       </code>
      </a>
      ; see that
            variable description for more information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_deflate_default_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_deflate_default_compression_level">
       <code class="literal">
        mysqlx_deflate_default_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125628096">
     </a>
     <a class="indexterm" name="idm46045125626976">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_deflate_default_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_deflate_default_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_deflate_default_compression_level">
            mysqlx_deflate_default_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           3
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           9
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The default compression level that the server uses for the
            Deflate algorithm on X Protocol connections. Specify the
            level as an integer from 1 (the lowest compression effort)
            to 9 (the highest effort). This level is used if the client
            does not request a compression level during capability
            negotiation. If you do not specify this system variable, the
            server uses level 3 as the default. For more information,
            see
      <a class="xref" href="x-plugin-connection-compression.html" title="22.5.5 Connection Compression with X Plugin">
       Section 22.5.5, “Connection Compression with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_deflate_max_client_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_deflate_max_client_compression_level">
       <code class="literal">
        mysqlx_deflate_max_client_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125596208">
     </a>
     <a class="indexterm" name="idm46045125595088">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_deflate_max_client_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_deflate_max_client_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_deflate_max_client_compression_level">
            mysqlx_deflate_max_client_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           9
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum compression level that the server permits for
            the Deflate algorithm on X Protocol connections. The range
            is the same as for the default compression level for this
            algorithm. If the client requests a higher compression level
            than this, the server uses the level you set here. If you do
            not specify this system variable, the server sets a maximum
            compression level of 5.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_document_id_unique_prefix">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_document_id_unique_prefix">
       <code class="literal">
        mysqlx_document_id_unique_prefix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125565184">
     </a>
     <a class="indexterm" name="idm46045125564080">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_document_id_unique_prefix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-document-id-unique-prefix=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_document_id_unique_prefix">
            mysqlx_document_id_unique_prefix
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           65535
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the first 4 bytes of document IDs generated by the
            server when documents are added to a collection. By setting
            this variable to a unique value per instance, you can ensure
            document IDs are unique across instances. See
      <a class="ulink" href="/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html" target="_top">
       Understanding Document IDs
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_enable_hello_notice">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_enable_hello_notice">
       <code class="literal">
        mysqlx_enable_hello_notice
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125532784">
     </a>
     <a class="indexterm" name="idm46045125531680">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_enable_hello_notice">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-enable-hello-notice[={OFF|ON}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_enable_hello_notice">
            mysqlx_enable_hello_notice
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ON
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Controls messages sent to classic MySQL protocol clients that try
            to connect over X Protocol. When enabled, clients which do
            not support X Protocol that attempt to connect to the
            server X Protocol port receive an error explaining they are
            using the wrong protocol.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_idle_worker_thread_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_idle_worker_thread_timeout">
       <code class="literal">
        mysqlx_idle_worker_thread_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125506656">
     </a>
     <a class="indexterm" name="idm46045125505616">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_idle_worker_thread_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-idle-worker-thread-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_idle_worker_thread_timeout">
            mysqlx_idle_worker_thread_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           60
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           3600
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds after which idle worker threads are
            terminated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_interactive_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_interactive_timeout">
       <code class="literal">
        mysqlx_interactive_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125474000">
     </a>
     <a class="indexterm" name="idm46045125472896">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_interactive_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-interactive-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_interactive_timeout">
            mysqlx_interactive_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           28800
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           2147483
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The default value of the
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_wait_timeout">
       <code class="literal">
        mysqlx_wait_timeout
       </code>
      </a>
      session
            variable for interactive clients. (The number of seconds to
            wait for interactive clients to timeout.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_lz4_default_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_lz4_default_compression_level">
       <code class="literal">
        mysqlx_lz4_default_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125439824">
     </a>
     <a class="indexterm" name="idm46045125438784">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_lz4_default_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_lz4_default_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_lz4_default_compression_level">
            mysqlx_lz4_default_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           2
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           16
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The default compression level that the server uses for the
            LZ4 algorithm on X Protocol connections. Specify the level
            as an integer from 0 (the lowest compression effort) to 16
            (the highest effort). This level is used if the client does
            not request a compression level during capability
            negotiation. If you do not specify this system variable, the
            server uses level 2 as the default. For more information,
            see
      <a class="xref" href="x-plugin-connection-compression.html" title="22.5.5 Connection Compression with X Plugin">
       Section 22.5.5, “Connection Compression with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_lz4_max_client_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_lz4_max_client_compression_level">
       <code class="literal">
        mysqlx_lz4_max_client_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125408000">
     </a>
     <a class="indexterm" name="idm46045125406960">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_lz4_max_client_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_lz4_max_client_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_lz4_max_client_compression_level">
            mysqlx_lz4_max_client_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           8
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           16
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum compression level that the server permits for
            the LZ4 algorithm on X Protocol connections. The range is
            the same as for the default compression level for this
            algorithm. If the client requests a higher compression level
            than this, the server uses the level you set here. If you do
            not specify this system variable, the server sets a maximum
            compression level of 8.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_max_allowed_packet">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_max_allowed_packet">
       <code class="literal">
        mysqlx_max_allowed_packet
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125377104">
     </a>
     <a class="indexterm" name="idm46045125376000">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_max_allowed_packet">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-max-allowed-packet=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_max_allowed_packet">
            mysqlx_max_allowed_packet
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           67108864
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           512
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1073741824
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum size of network packets that can be received by
            X Plugin. This limit also applies when compression is used
            for the connection, so the network packet must be smaller
            than this size after the message has been decompressed. This
            is the X Plugin equivalent of
      <a class="link" href="server-system-variables.html#sysvar_max_allowed_packet">
       <code class="literal">
        max_allowed_packet
       </code>
      </a>
      ; see
            that variable description for more information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_max_connections">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_max_connections">
       <code class="literal">
        mysqlx_max_connections
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125342864">
     </a>
     <a class="indexterm" name="idm46045125341824">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_max_connections">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-max-connections=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_max_connections">
            mysqlx_max_connections
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           100
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           65535
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of concurrent client connections
            X Plugin can accept. This is the X Plugin equivalent of
      <a class="link" href="server-system-variables.html#sysvar_max_connections">
       <code class="literal">
        max_connections
       </code>
      </a>
      ; see that
            variable description for more information.
     </p>
     <p>
      For modifications to this variable, if the new value is
            smaller than the current number of connections, the new
            limit is taken into account only for new connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_min_worker_threads">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_min_worker_threads">
       <code class="literal">
        mysqlx_min_worker_threads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125310464">
     </a>
     <a class="indexterm" name="idm46045125309360">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_min_worker_threads">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-min-worker-threads=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_min_worker_threads">
            mysqlx_min_worker_threads
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           2
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           100
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The minimum number of worker threads used by X Plugin for
            handling client requests.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_port">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_port">
       <code class="literal">
        mysqlx_port
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125280000">
     </a>
     <a class="indexterm" name="idm46045125278912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_port">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-port=port_num
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_port">
            mysqlx_port
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           33060
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           65535
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The network port on which X Plugin listens for TCP/IP
            connections. This is the X Plugin equivalent of
      <a class="link" href="server-system-variables.html#sysvar_port">
       <code class="literal">
        port
       </code>
      </a>
      ; see that variable
            description for more information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_port_open_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_port_open_timeout">
       <code class="literal">
        mysqlx_port_open_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125248176">
     </a>
     <a class="indexterm" name="idm46045125247072">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_port_open_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-port-open-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_port_open_timeout">
            mysqlx_port_open_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           120
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds X Plugin waits for a TCP/IP port to
            become free.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_read_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_read_timeout">
       <code class="literal">
        mysqlx_read_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125215568">
     </a>
     <a class="indexterm" name="idm46045125214528">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_read_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-read-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_read_timeout">
            mysqlx_read_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Session
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           30
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           2147483
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds that X Plugin waits for blocking read
            operations to complete. After this time, if the read
            operation is not successful, X Plugin closes the connection
            and returns a warning notice with the error code
      <span class="errorcode">
       ER_IO_READ_ERROR
      </span>
      to the client
            application.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_socket">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_socket">
       <code class="literal">
        mysqlx_socket
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125182160">
     </a>
     <a class="indexterm" name="idm46045125181072">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_socket">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-socket=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_socket">
            mysqlx_socket
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           /tmp/mysqlx.sock
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The path to a Unix socket file which X Plugin uses for
            connections. This setting is only used by MySQL Server when
            running on Unix operating systems. Clients can use this
            socket to connect to MySQL Server using X Plugin.
     </p>
     <p>
      The default
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_socket">
       <code class="literal">
        mysqlx_socket
       </code>
      </a>
      path and file name is based on the default path and file
            name for the main socket file for MySQL Server, with the
            addition of an
      <code class="literal">
       x
      </code>
      appended to the file
            name. The default path and file name for the main socket
            file is
      <code class="literal">
       /tmp/mysql.sock
      </code>
      , therefore the
            default path and file name for the X Plugin socket file is
      <code class="literal">
       /tmp/mysqlx.sock
      </code>
      .
     </p>
     <p>
      If you specify an alternative path and file name for the
            main socket file at server startup using the
      <a class="link" href="server-system-variables.html#sysvar_socket">
       <code class="literal">
        socket
       </code>
      </a>
      system variable,
            this does not affect the default for the X Plugin socket
            file. In this situation, if you want to store both sockets
            at a single path, you must set the
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_socket">
       <code class="literal">
        mysqlx_socket
       </code>
      </a>
      system
            variable as well. For example in a configuration file:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa84504865"><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-ini"><span class="token constant">socket</span><span class="token attr-value"><span class="token punctuation">=</span>/home/sockets/mysqld/mysql.sock</span>
<span class="token constant">mysqlx_socket</span><span class="token attr-value"><span class="token punctuation">=</span>/home/sockets/xplugin/xplugin.sock</span></code></pre>
     </div>
     <p>
      If you change the default path and file name for the main
            socket file at compile time using the
      <a class="link" href="source-configuration-options.html#option_cmake_mysql_unix_addr">
       <code class="option">
        MYSQL_UNIX_ADDR
       </code>
      </a>
      compile
            option, this does affect the default for the X Plugin
            socket file, which is formed by appending an
      <code class="literal">
       x
      </code>
      to the
      <a class="link" href="source-configuration-options.html#option_cmake_mysql_unix_addr">
       <code class="option">
        MYSQL_UNIX_ADDR
       </code>
      </a>
      file name. If
            you want to set a different default for the X Plugin socket
            file at compile time, use the
      <a class="link" href="source-configuration-options.html#option_cmake_mysqlx_unix_addr">
       <code class="option">
        MYSQLX_UNIX_ADDR
       </code>
      </a>
      compile
            option.
     </p>
     <p>
      The
      <code class="literal">
       MYSQLX_UNIX_PORT
      </code>
      environment variable
            can also be used to set a default for the X Plugin socket
            file at server startup (see
      <a class="xref" href="environment-variables.html" title="6.9 Environment Variables">
       Section 6.9, “Environment Variables”
      </a>
      ). If you set this
            environment variable, it overrides the compiled
      <a class="link" href="source-configuration-options.html#option_cmake_mysqlx_unix_addr">
       <code class="option">
        MYSQLX_UNIX_ADDR
       </code>
      </a>
      value, but is
            overridden by the
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_socket">
       <code class="literal">
        mysqlx_socket
       </code>
      </a>
      value.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_ca">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_ca">
       <code class="literal">
        mysqlx_ssl_ca
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125139200">
     </a>
     <a class="indexterm" name="idm46045125138112">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_ca">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-ca=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_ca">
            mysqlx_ssl_ca
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_ca">
       <code class="literal">
        mysqlx_ssl_ca
       </code>
      </a>
      system
            variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_ca">
       <code class="literal">
        ssl_ca
       </code>
      </a>
      ,
            except that it applies to X Plugin rather than the MySQL
            Server main connection interface. For information about
            configuring encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_capath">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_capath">
       <code class="literal">
        mysqlx_ssl_capath
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125110176">
     </a>
     <a class="indexterm" name="idm46045125109136">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_capath">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-capath=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_capath">
            mysqlx_ssl_capath
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_capath">
       <code class="literal">
        mysqlx_ssl_capath
       </code>
      </a>
      system variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_capath">
       <code class="literal">
        ssl_capath
       </code>
      </a>
      , except that it
            applies to X Plugin rather than the MySQL Server main
            connection interface. For information about configuring
            encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_cert">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cert">
       <code class="literal">
        mysqlx_ssl_cert
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125081232">
     </a>
     <a class="indexterm" name="idm46045125080144">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_cert">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-cert=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cert">
            mysqlx_ssl_cert
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cert">
       <code class="literal">
        mysqlx_ssl_cert
       </code>
      </a>
      system
            variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_cert">
       <code class="literal">
        ssl_cert
       </code>
      </a>
      ,
            except that it applies to X Plugin rather than the MySQL
            Server main connection interface. For information about
            configuring encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_cipher">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cipher">
       <code class="literal">
        mysqlx_ssl_cipher
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125052208">
     </a>
     <a class="indexterm" name="idm46045125051168">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_cipher">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-cipher=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cipher">
            mysqlx_ssl_cipher
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_cipher">
       <code class="literal">
        mysqlx_ssl_cipher
       </code>
      </a>
      system variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_cipher">
       <code class="literal">
        ssl_cipher
       </code>
      </a>
      , except that it
            applies to X Plugin rather than the MySQL Server main
            connection interface. For information about configuring
            encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_crl">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crl">
       <code class="literal">
        mysqlx_ssl_crl
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045125023264">
     </a>
     <a class="indexterm" name="idm46045125022176">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_crl">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-crl=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crl">
            mysqlx_ssl_crl
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crl">
       <code class="literal">
        mysqlx_ssl_crl
       </code>
      </a>
      system
            variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_crl">
       <code class="literal">
        ssl_crl
       </code>
      </a>
      ,
            except that it applies to X Plugin rather than the MySQL
            Server main connection interface. For information about
            configuring encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_crlpath">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crlpath">
       <code class="literal">
        mysqlx_ssl_crlpath
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124994304">
     </a>
     <a class="indexterm" name="idm46045124993264">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_crlpath">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-crlpath=dir_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crlpath">
            mysqlx_ssl_crlpath
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Directory name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_crlpath">
       <code class="literal">
        mysqlx_ssl_crlpath
       </code>
      </a>
      system variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_crlpath">
       <code class="literal">
        ssl_crlpath
       </code>
      </a>
      , except that it
            applies to X Plugin rather than the MySQL Server main
            connection interface. For information about configuring
            encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_ssl_key">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_key">
       <code class="literal">
        mysqlx_ssl_key
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124965424">
     </a>
     <a class="indexterm" name="idm46045124964336">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_ssl_key">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-ssl-key=file_name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_key">
            mysqlx_ssl_key
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           NULL
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_ssl_key">
       <code class="literal">
        mysqlx_ssl_key
       </code>
      </a>
      system
            variable is like
      <a class="link" href="server-system-variables.html#sysvar_ssl_key">
       <code class="literal">
        ssl_key
       </code>
      </a>
      ,
            except that it applies to X Plugin rather than the MySQL
            Server main connection interface. For information about
            configuring encryption support for X Plugin, see
      <a class="xref" href="x-plugin-encrypted-connections.html" title="22.5.3 Using Encrypted Connections with X Plugin">
       Section 22.5.3, “Using Encrypted Connections with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_wait_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_wait_timeout">
       <code class="literal">
        mysqlx_wait_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124936400">
     </a>
     <a class="indexterm" name="idm46045124935360">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_wait_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-wait-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_wait_timeout">
            mysqlx_wait_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Session
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           28800
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           2147483
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds that X Plugin waits for activity on a
            connection. After this time, if the read operation is not
            successful, X Plugin closes the connection. If the client
            is noninteractive, the initial value of the session variable
            is copied from the global
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_wait_timeout">
       <code class="literal">
        mysqlx_wait_timeout
       </code>
      </a>
      variable. For interactive clients, the initial value is
            copied from the session
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_interactive_timeout">
       <code class="literal">
        mysqlx_interactive_timeout
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_write_timeout">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_write_timeout">
       <code class="literal">
        mysqlx_write_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124900976">
     </a>
     <a class="indexterm" name="idm46045124899936">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_write_timeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx-write-timeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_write_timeout">
            mysqlx_write_timeout
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Session
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           60
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           2147483
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of seconds that X Plugin waits for blocking
            write operations to complete. After this time, if the write
            operation is not successful, X Plugin closes the
            connection.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_zstd_default_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_zstd_default_compression_level">
       <code class="literal">
        mysqlx_zstd_default_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124868208">
     </a>
     <a class="indexterm" name="idm46045124867168">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_zstd_default_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_zstd_default_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_zstd_default_compression_level">
            mysqlx_zstd_default_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           3
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -131072
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           22
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The default compression level that the server uses for the
            zstd algorithm on X Protocol connections. For versions of
            the zstd library from 1.4.0, you can set positive values
            from 1 to 22 (the highest compression effort), or negative
            values which represent progressively lower effort. A value
            of 0 is converted to a value of 1. For earlier versions of
            the zstd library, you can only specify the value 3. This
            level is used if the client does not request a compression
            level during capability negotiation. If you do not specify
            this system variable, the server uses level 3 as the
            default. For more information, see
      <a class="xref" href="x-plugin-connection-compression.html" title="22.5.5 Connection Compression with X Plugin">
       Section 22.5.5, “Connection Compression with X Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_mysqlx_zstd_max_client_compression_level">
      </a>
      <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_zstd_max_client_compression_level">
       <code class="literal">
        mysqlx_zstd_max_client_compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045124835056">
     </a>
     <a class="indexterm" name="idm46045124833936">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for mysqlx_zstd_max_client_compression_level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --mysqlx_zstd_max_client_compression_level=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="x-plugin-options-system-variables.html#sysvar_mysqlx_zstd_max_client_compression_level">
            mysqlx_zstd_max_client_compression_level
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           11
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -131072
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           22
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum compression level that the server permits for
            the zstd algorithm on X Protocol connections. The range is
            the same as for the default compression level for this
            algorithm. If the client requests a higher compression level
            than this, the server uses the level you set here. If you do
            not specify this system variable, the server sets a maximum
            compression level of 11.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
