<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="show-engines">
      </a>
      15.7.7.17 SHOW ENGINES Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045170530448">
  </a>
  <a class="indexterm" name="idm46045170529376">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa39456045"><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">SHOW</span> <span class="token punctuation">[</span><span class="token keyword">STORAGE</span><span class="token punctuation">]</span> <span class="token keyword">ENGINES</span></code></pre>
  </div>
  <p>
   <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
    <code class="literal">
     SHOW ENGINES
    </code>
   </a>
   displays status
        information about the server's storage engines. This is
        particularly useful for checking whether a storage engine is
        supported, or to see what the default engine is.
  </p>
  <p>
   For information about MySQL storage engines, see
   <a class="xref" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    Chapter 17,
    <i>
     The InnoDB Storage Engine
    </i>
   </a>
   , and
   <a class="xref" href="storage-engines.html" title="Chapter 18 Alternative Storage Engines">
    Chapter 18,
    <i>
     Alternative Storage Engines
    </i>
   </a>
   .
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa25571904"><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">ENGINES</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> MEMORY
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Hash based, stored in memory, useful for temporary tables
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> InnoDB
     Support<span class="token punctuation">:</span> DEFAULT
     Comment<span class="token punctuation">:</span> Supports transactions, row-level locking, and foreign keys
Transactions<span class="token punctuation">:</span> YES
          XA<span class="token punctuation">:</span> YES
  Savepoints<span class="token punctuation">:</span> YES
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 3. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> PERFORMANCE_SCHEMA
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Performance Schema
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 4. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> MyISAM
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> MyISAM storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 5. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> MRG_MYISAM
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Collection of identical MyISAM tables
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 6. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> BLACKHOLE
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> /dev/null storage engine (anything you write to it disappears)
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 7. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> CSV
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> CSV storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 8. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
      Engine<span class="token punctuation">:</span> ARCHIVE
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Archive storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO</span></code></pre>
  </div>
  <p>
   The output from
   <code class="literal">
    SHOW ENGINES
   </code>
   may vary
        according to the MySQL version used and other factors.
  </p>
  <p>
   <code class="literal">
    SHOW ENGINES
   </code>
   output 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 output of the SHOW ENGINES statement.">
       <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>
  <p>
   Storage engine information is also available from the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <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. See
   <a class="xref" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
    Section 28.3.13, “The INFORMATION_SCHEMA ENGINES Table”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
