<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="drop-logfile-group">
      </a>
      15.1.28 DROP LOGFILE GROUP Statement
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045183421792">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30525518"><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">DROP</span> <span class="token keyword">LOGFILE</span> <span class="token keyword">GROUP</span> <em class="replaceable">logfile_group</em>
    <span class="token keyword">ENGINE</span> <span class="token punctuation">[</span><span class="token operator">=</span><span class="token punctuation">]</span> <em class="replaceable">engine_name</em></code></pre>
  </div>
  <p>
   This statement drops the log file group named
   <em class="replaceable">
    <code>
     logfile_group
    </code>
   </em>
   . The log file group must
      already exist or an error results. (For information on creating
      log file groups, see
   <a class="xref" href="create-logfile-group.html" title="15.1.16 CREATE LOGFILE GROUP Statement">
    Section 15.1.16, “CREATE LOGFILE GROUP Statement”
   </a>
   .)
  </p>
  <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Important
   </div>
   <p>
    Before dropping a log file group, you must drop all tablespaces
        that use that log file group for
    <code class="literal">
     UNDO
    </code>
    logging.
   </p>
  </div>
  <p>
   The required
   <code class="literal">
    ENGINE
   </code>
   clause provides the name of
      the storage engine used by the log file group to be dropped. The
      only permitted values for
   <em class="replaceable">
    <code>
     engine_name
    </code>
   </em>
   are
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDBCLUSTER
    </code>
   </a>
   .
  </p>
  <p>
   <a class="link" href="drop-logfile-group.html" title="15.1.28 DROP LOGFILE GROUP Statement">
    <code class="literal">
     DROP LOGFILE GROUP
    </code>
   </a>
   is useful only
      with Disk Data storage for NDB Cluster. See
   <a class="xref" href="mysql-cluster-disk-data.html" title="25.6.11 NDB Cluster Disk Data Tables">
    Section 25.6.11, “NDB Cluster Disk Data Tables”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
