<div id="docs-body">
 <div class="chapter">
  <div class="titlepage">
   <div>
    <div>
     <h1 class="title">
      <a name="server-administration">
      </a>
      Chapter 7 MySQL Server Administration
     </h1>
    </div>
   </div>
  </div>
  <div class="toc">
   <p>
    <b>
     Table of Contents
    </b>
   </p>
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="mysqld-server.html">
       7.1 The MySQL Server
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="server-configuration.html">
         7.1.1 Configuring the Server
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-configuration-defaults.html">
         7.1.2 Server Configuration Defaults
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-configuration-validation.html">
         7.1.3 Server Configuration Validation
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-option-variable-reference.html">
         7.1.4 Server Option, System Variable, and Status Variable Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-system-variable-reference.html">
         7.1.5 Server System Variable Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-status-variable-reference.html">
         7.1.6 Server Status Variable Reference
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-options.html">
         7.1.7 Server Command Options
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-system-variables.html">
         7.1.8 Server System Variables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="using-system-variables.html">
         7.1.9 Using System Variables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-status-variables.html">
         7.1.10 Server Status Variables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="sql-mode.html">
         7.1.11 Server SQL Modes
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="connection-management.html">
         7.1.12 Connection Management
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="ipv6-support.html">
         7.1.13 IPv6 Support
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="network-namespace-support.html">
         7.1.14 Network Namespace Support
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="time-zone-support.html">
         7.1.15 MySQL Server Time Zone Support
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="resource-groups.html">
         7.1.16 Resource Groups
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-side-help-support.html">
         7.1.17 Server-Side Help Support
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="session-state-tracking.html">
         7.1.18 Server Tracking of Client Session State
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="server-shutdown.html">
         7.1.19 The Server Shutdown Process
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="data-directory.html">
       7.2 The MySQL Data Directory
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="system-schema.html">
       7.3 The mysql System Schema
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="server-logs.html">
       7.4 MySQL Server Logs
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="log-destinations.html">
         7.4.1 Selecting General Query Log and Slow Query Log Output Destinations
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="error-log.html">
         7.4.2 The Error Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="query-log.html">
         7.4.3 The General Query Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="binary-log.html">
         7.4.4 The Binary Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="slow-query-log.html">
         7.4.5 The Slow Query Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="log-file-maintenance.html">
         7.4.6 Server Log Maintenance
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="components.html">
       7.5 MySQL Components
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="component-loading.html">
         7.5.1 Installing and Uninstalling Components
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="obtaining-component-information.html">
         7.5.2 Obtaining Component Information
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="error-log-components.html">
         7.5.3 Error Log Components
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="query-attribute-components.html">
         7.5.4 Query Attribute Components
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="scheduler-component.html">
         7.5.5 Scheduler Component
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="server-plugins.html">
       7.6 MySQL Server Plugins
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="plugin-loading.html">
         7.6.1 Installing and Uninstalling Plugins
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="obtaining-plugin-information.html">
         7.6.2 Obtaining Server Plugin Information
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="thread-pool.html">
         7.6.3 MySQL Enterprise Thread Pool
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="rewriter-query-rewrite-plugin.html">
         7.6.4 The Rewriter Query Rewrite Plugin
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="ddl-rewriter.html">
         7.6.5 The ddl_rewriter Plugin
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="version-tokens.html">
         7.6.6 Version Tokens
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="clone-plugin.html">
         7.6.7 The Clone Plugin
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="daemon-keyring-proxy-plugin.html">
         7.6.8 The Keyring Proxy Bridge Plugin
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="plugin-services.html">
         7.6.9 MySQL Plugin Services
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="server-loadable-functions.html">
       7.7 MySQL Server Loadable Functions
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="function-loading.html">
         7.7.1 Installing and Uninstalling Loadable Functions
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="obtaining-loadable-function-information.html">
         7.7.2 Obtaining Information About Loadable Functions
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="multiple-servers.html">
       7.8 Running Multiple MySQL Instances on One Machine
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="multiple-data-directories.html">
         7.8.1 Setting Up Multiple Data Directories
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="multiple-windows-servers.html">
         7.8.2 Running Multiple MySQL Instances on Windows
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="multiple-unix-servers.html">
         7.8.3 Running Multiple MySQL Instances on Unix
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="multiple-server-clients.html">
         7.8.4 Using Client Programs in a Multiple-Server Environment
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="debugging-mysql.html">
       7.9 Debugging MySQL
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="debugging-server.html">
         7.9.1 Debugging a MySQL Server
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="debugging-client.html">
         7.9.2 Debugging a MySQL Client
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="lock-order-tool.html">
         7.9.3 The LOCK_ORDER Tool
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="dbug-package.html">
         7.9.4 The DBUG Package
        </a>
       </span>
      </dt>
     </dl>
    </dd>
   </dl>
  </div>
  <p>
   MySQL Server (
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   ) is the main program that
    does most of the work in a MySQL installation. This chapter provides
    an overview of MySQL Server and covers general server
    administration:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Server configuration
     </p>
    </li>
    <li class="listitem">
     <p>
      The data directory, particularly the
      <code class="literal">
       mysql
      </code>
      system schema
     </p>
    </li>
    <li class="listitem">
     <p>
      The server log files
     </p>
    </li>
    <li class="listitem">
     <p>
      Management of multiple servers on a single machine
     </p>
    </li>
   </ul>
  </div>
  <p>
   For additional information on administrative topics, see also:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="security.html" title="Chapter 8 Security">
       Chapter 8,
       <i>
        Security
       </i>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="backup-and-recovery.html" title="Chapter 9 Backup and Recovery">
       Chapter 9,
       <i>
        Backup and Recovery
       </i>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="replication.html" title="Chapter 19 Replication">
       Chapter 19,
       <i>
        Replication
       </i>
      </a>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
