<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="server-configuration">
      </a>
      7.1.1 Configuring the Server
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045302467040">
  </a>
  <a class="indexterm" name="idm46045302465968">
  </a>
  <a class="indexterm" name="idm46045302464480">
  </a>
  <a class="indexterm" name="idm46045302462992">
  </a>
  <p>
   The MySQL server,
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   , has many command
      options and system variables that can be set at startup to
      configure its operation. To determine the default command option
      and system variable values used by the server, execute this
      command:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa48148092"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqld</span> <span class="token property">--verbose</span> <span class="token property">--help</span></code></pre>
  </div>
  <a class="indexterm" name="idm46045302458384">
  </a>
  <a class="indexterm" name="idm46045302457312">
  </a>
  <a class="indexterm" name="idm46045302456240">
  </a>
  <a class="indexterm" name="idm46045302454752">
  </a>
  <p>
   The command produces a list of all
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   options and configurable system variables. Its output includes the
      default option and variable values and looks something like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa86480337"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">activate-all-roles-on-login                                  FALSE
admin-address                                                <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>
admin-port                                                   33062
admin-ssl                                                    TRUE
admin-ssl-ca                                                 <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>
admin-ssl-capath                                             <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>
admin-ssl-cert                                               <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>
admin-ssl-cipher                                             <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>
admin-ssl-crl                                                <span class="token punctuation">(</span>No default value<span class="token punctuation">)</span>

<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>

transaction-prealloc-size                                    4096
transaction-read-only                                        FALSE
updatable-views-with-limit                                   YES
upgrade                                                      AUTO
validate-config                                              FALSE
validate-user-plugins                                        TRUE
verbose                                                      TRUE
wait-timeout                                                 28800
windowing-use-high-precision                                 TRUE
xa-detach-on-prepare                                         TRUE</code></pre>
  </div>
  <p>
   To see the current system variable values actually used by the
      server as it runs, connect to it and execute this statement:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa84296113"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   To see some statistical and status indicators for a running
      server, execute this statement:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa45521588"><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-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   System variable and status information also is available using the
   <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
    <span class="command">
     <strong>
      mysqladmin
     </strong>
    </span>
   </a>
   command:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa92210142"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqladmin</span> variables
<span class="token prompt">$&gt; </span><span class="token command">mysqladmin</span> extended-status</code></pre>
  </div>
  <p>
   For a full description of all command options, system variables,
      and status variables, see these sections:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="server-options.html" title="7.1.7 Server Command Options">
       Section 7.1.7, “Server Command Options”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
       Section 7.1.8, “Server System Variables”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="server-status-variables.html" title="7.1.10 Server Status Variables">
       Section 7.1.10, “Server Status Variables”
      </a>
     </p>
    </li>
   </ul>
  </div>
  <p>
   More detailed monitoring information is available from the
      Performance Schema; see
   <a class="xref" href="performance-schema.html" title="Chapter 29 MySQL Performance Schema">
    Chapter 29,
    <i>
     MySQL Performance Schema
    </i>
   </a>
   . In
      addition, the MySQL
   <code class="literal">
    sys
   </code>
   schema is a set of
      objects that provides convenient access to data collected by the
      Performance Schema; see
   <a class="xref" href="sys-schema.html" title="Chapter 30 MySQL sys Schema">
    Chapter 30,
    <i>
     MySQL sys Schema
    </i>
   </a>
   .
  </p>
  <p>
   If you specify an option on the command line for
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   or
   <a class="link" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
    <span class="command">
     <strong>
      mysqld_safe
     </strong>
    </span>
   </a>
   , it
      remains in effect only for that invocation of the server. To use
      the option every time the server runs, put it in an option file.
      See
   <a class="xref" href="option-files.html" title="6.2.2.2 Using Option Files">
    Section 6.2.2.2, “Using Option Files”
   </a>
   .
  </p>
  <p>
   Windows users may execute
   <a class="xref" href="mysql-configurator.html" title="2.3.2 Configuration: Using MySQL Configurator">
    Section 2.3.2, “Configuration: Using MySQL Configurator”
   </a>
   to
      help configure a MySQL server installation. This includes tasks
      such as configuring MySQL users, log files, the Windows service
      name, and sample databases.
  </p>
 </div>
 <br/>
</div>
