<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-engines-table">
      </a>
      28.3.13 The INFORMATION_SCHEMA ENGINES Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080032864">
  </a>
  <p>
   The
   <a class="link" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
    <code class="literal">
     ENGINES
    </code>
   </a>
   table provides
      information about storage engines. This is particularly useful for
      checking whether a storage engine is supported, or to see what the
      default engine is.
  </p>
  <p>
   The
   <a class="link" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
    <code class="literal">
     ENGINES
    </code>
   </a>
   table has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       ENGINE
      </code>
     </p>
     <p>
      The name of the storage engine.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SUPPORT
      </code>
     </p>
     <p>
      The server's level of support for the storage engine, as shown
          in the following table.
     </p>
     <div class="informaltable">
      <table summary="Values for the SUPPORT column in the INFORMATION_SCHEMA.ENGINES table.">
       <colgroup>
        <col style="width: 15%"/>
        <col style="width: 85%"/>
       </colgroup>
       <thead>
        <tr>
         <th>
          Value
         </th>
         <th>
          Meaning
         </th>
        </tr>
       </thead>
       <tbody>
        <tr>
         <td>
          <code class="literal">
           YES
          </code>
         </td>
         <td>
          The engine is supported and is active
         </td>
        </tr>
        <tr>
         <td>
          <code class="literal">
           DEFAULT
          </code>
         </td>
         <td>
          Like
          <code class="literal">
           YES
          </code>
          , plus this is the default engine
         </td>
        </tr>
        <tr>
         <td>
          <code class="literal">
           NO
          </code>
         </td>
         <td>
          The engine is not supported
         </td>
        </tr>
        <tr>
         <td>
          <code class="literal">
           DISABLED
          </code>
         </td>
         <td>
          The engine is supported but has been disabled
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      A value of
      <code class="literal">
       NO
      </code>
      means that the server was
          compiled without support for the engine, so it cannot be
          enabled at runtime.
     </p>
     <p>
      A value of
      <code class="literal">
       DISABLED
      </code>
      occurs either because
          the server was started with an option that disables the
          engine, or because not all options required to enable it were
          given. In the latter case, the error log should contain a
          reason indicating why the option is disabled. See
      <a class="xref" href="error-log.html" title="7.4.2 The Error Log">
       Section 7.4.2, “The Error Log”
      </a>
      .
     </p>
     <p>
      You might also see
      <code class="literal">
       DISABLED
      </code>
      for a storage
          engine if the server was compiled to support it, but was
          started with a
      <code class="option">
       --skip-
       <em class="replaceable">
        <code>
         engine_name
        </code>
       </em>
      </code>
      option. For the
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      storage
          engine,
      <code class="literal">
       DISABLED
      </code>
      means the server was
          compiled with support for NDB Cluster, but was not started
          with the
      <a class="link" href="mysql-cluster-options-variables.html#option_mysqld_ndbcluster">
       <code class="option">
        --ndbcluster
       </code>
      </a>
      option.
     </p>
     <p>
      All MySQL servers support
      <code class="literal">
       MyISAM
      </code>
      tables. It
          is not possible to disable
      <code class="literal">
       MyISAM
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COMMENT
      </code>
     </p>
     <p>
      A brief description of the storage engine.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TRANSACTIONS
      </code>
     </p>
     <p>
      Whether the storage engine supports transactions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       XA
      </code>
     </p>
     <p>
      Whether the storage engine supports XA transactions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SAVEPOINTS
      </code>
     </p>
     <p>
      Whether the storage engine supports savepoints.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045079989456">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
       <code class="literal">
        ENGINES
       </code>
      </a>
      is a nonstandard
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      table.
     </p>
    </li>
   </ul>
  </div>
  <p>
   Storage engine information is also available from the
   <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
    <code class="literal">
     SHOW ENGINES
    </code>
   </a>
   statement. See
   <a class="xref" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
    Section 15.7.7.17, “SHOW ENGINES Statement”
   </a>
   . The following statements are
      equivalent:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa69295162"><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 keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">ENGINES</span>

<span class="token keyword">SHOW</span> <span class="token keyword">ENGINES</span></code></pre>
  </div>
 </div>
 <br/>
</div>
