<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-delete-all">
      </a>
      25.5.8 ndb_delete_all — Delete All Rows from an NDB Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045104744240">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-delete-all.html" title="25.5.8 ndb_delete_all — Delete All Rows from an NDB Table">
    <span class="command">
     <strong>
      ndb_delete_all
     </strong>
    </span>
   </a>
   deletes all rows from the
        given
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   table. In some cases,
        this can be much faster than
   <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
    <code class="literal">
     DELETE
    </code>
   </a>
   or even
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   .
  </p>
  <h4>
   <a name="idm46045104737760">
   </a>
   Usage
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa56434088"><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">ndb_delete_all <span class="token property">-c</span> <em class="replaceable">connection_string</em> <em class="replaceable">tbl_name</em> <span class="token property">-d</span> <em class="replaceable">db_name</em></code></pre>
  </div>
  <p>
   This deletes all rows from the table named
   <em class="replaceable">
    <code>
     tbl_name
    </code>
   </em>
   in the database named
   <em class="replaceable">
    <code>
     db_name
    </code>
   </em>
   . It is exactly equivalent to
        executing
   <code class="literal">
    TRUNCATE
    <em class="replaceable">
     <code>
      db_name
     </code>
    </em>
    .
    <em class="replaceable">
     <code>
      tbl_name
     </code>
    </em>
   </code>
   in MySQL.
  </p>
  <p>
   Options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-delete-all.html" title="25.5.8 ndb_delete_all — Delete All Rows from an NDB Table">
    <span class="command">
     <strong>
      ndb_delete_all
     </strong>
    </span>
   </a>
   are shown in the following table. Additional descriptions follow
        the table.
  </p>
  <p>
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104727088">
     </a>
     <a class="indexterm" name="idm46045104725584">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=path
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Directory containing character sets.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104715792">
     </a>
     <a class="indexterm" name="idm46045104714304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retries">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retries=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times to retry connection before giving up.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104695136">
     </a>
     <a class="indexterm" name="idm46045104693632">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retry-delay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retry-delay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of seconds to wait between attempts to contact
            management server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104674576">
     </a>
     <a class="indexterm" name="idm46045104673088">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-string">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-string=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104657728">
     </a>
     <a class="indexterm" name="idm46045104656240">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for core-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --core-file
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Write core file on error; used in debugging.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_database">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_database">
       <code class="option">
        --database
       </code>
      </a>
      ,
      <code class="option">
       -d
      </code>
     </p>
     <a class="indexterm" name="idm46045104646112">
     </a>
     <a class="indexterm" name="idm46045104644624">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --database=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           TEST_DB
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Name of the database containing the table to delete from.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104630272">
     </a>
     <a class="indexterm" name="idm46045104628768">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given file after global files are read.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104614544">
     </a>
     <a class="indexterm" name="idm46045104613056">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read default options from given file only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104598768">
     </a>
     <a class="indexterm" name="idm46045104597264">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Also read groups with concat(group, suffix).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_diskscan">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_diskscan">
       <code class="option">
        --diskscan
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104582976">
     </a>
     <a class="indexterm" name="idm46045104581488">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for diskscan">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --diskscan
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Run a disk scan.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104571808">
     </a>
     <a class="indexterm" name="idm46045104570320">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104560512">
     </a>
     <a class="indexterm" name="idm46045104559024">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given path from login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104544816">
     </a>
     <a class="indexterm" name="idm46045104543328">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Skips reading options from the login path file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104533728">
     </a>
     <a class="indexterm" name="idm46045104532272">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-connectstring">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-connectstring=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set connection string for connecting to
      <a class="link" href="mysql-cluster-programs-ndb-mgmd.html" title="25.5.4 ndb_mgmd — The NDB Cluster Management Server Daemon">
       <span class="command">
        <strong>
         ndb_mgmd
        </strong>
       </span>
      </a>
      . Syntax:
      <code class="literal">
       [nodeid=
       <em class="replaceable">
        <code>
         id
        </code>
       </em>
       ;][host=]
       <em class="replaceable">
        <code>
         hostname
        </code>
       </em>
       [:
       <em class="replaceable">
        <code>
         port
        </code>
       </em>
       ]
      </code>
      .
            Overrides entries in
      <code class="literal">
       NDB_CONNECTSTRING
      </code>
      and
      <code class="filename">
       my.cnf
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104513296">
     </a>
     <a class="indexterm" name="idm46045104511808">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgm-tls">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgm-tls=level
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           relaxed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            relaxed
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            strict
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the level of TLS support required to connect to the
            management server; one of
      <code class="literal">
       relaxed
      </code>
      or
      <code class="literal">
       strict
      </code>
      .
      <code class="literal">
       relaxed
      </code>
      (the
            default) means that a TLS connection is attempted, but
            success is not required;
      <code class="literal">
       strict
      </code>
      means
            that TLS is required to connect.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104490752">
     </a>
     <a class="indexterm" name="idm46045104489264">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgmd-host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgmd-host=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104474016">
     </a>
     <a class="indexterm" name="idm46045104472528">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-nodeid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-nodeid=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set node ID for this node, overriding any ID set by
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104457152">
     </a>
     <a class="indexterm" name="idm46045104455648">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-optimized-node-selection">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-optimized-node-selection
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Enable optimizations for selection of nodes for
            transactions. Enabled by default; use
      <code class="option">
       --skip-ndb-optimized-node-selection
      </code>
      to
            disable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104445216">
     </a>
     <a class="indexterm" name="idm46045104443712">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-tls-search-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-tls-search-path=list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Path name
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Unix)
         </th>
         <td>
          <code class="literal">
           $HOME/ndb-tls
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Windows)
         </th>
         <td>
          <code class="literal">
           $HOMEDIR/ndb-tls
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify a list of directories to search for a CA file. On
            Unix platforms, the directory names are separated by colons
            (
      <code class="literal">
       :
      </code>
      ); on Windows systems, the semicolon
            character (
      <code class="literal">
       ;
      </code>
      ) is used as the separator. A
            directory reference may be relative or absolute; it may
            contain one or more environment variables, each denoted by a
            prefixed dollar sign (
      <code class="literal">
       $
      </code>
      ), and expanded
            prior to use.
     </p>
     <p>
      Searching begins with the leftmost named directory and
            proceeds from left to right until a file is found. An empty
            string denotes an empty search path, which causes all
            searches to fail. A string consisting of a single dot
            (
      <code class="literal">
       .
      </code>
      ) indicates that the search path
            limited to the current working directory.
     </p>
     <p>
      If no search path is supplied, the compiled-in default value
            is used. This value depends on the platform used: On
            Windows, this is
      <code class="literal">
       \ndb-tls
      </code>
      ; on other
            platforms (including Linux), it is
      <code class="literal">
       $HOME/ndb-tls
      </code>
      . This can be overridden by
            compiling NDB Cluster using
      <a class="link" href="source-configuration-options.html#option_cmake_with_ndb_tls_search_path">
       <code class="option">
        -DWITH_NDB_TLS_SEARCH_PATH
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104420016">
     </a>
     <a class="indexterm" name="idm46045104418528">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not read default options from any option file other than
            login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104408704">
     </a>
     <a class="indexterm" name="idm46045104407216">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Print program argument list and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_transactional">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_transactional">
       <code class="option">
        --transactional
       </code>
      </a>
      ,
      <code class="option">
       -t
      </code>
     </p>
     <a class="indexterm" name="idm46045104397024">
     </a>
     <a class="indexterm" name="idm46045104395536">
     </a>
     <p>
      Use of this option causes the delete operation to be
            performed as a single transaction.
     </p>
     <div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Warning
      </div>
      <p>
       With very large tables, using this option may cause the
              number of operations available to the cluster to be
              exceeded.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_tupscan">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_tupscan">
       <code class="option">
        --tupscan
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104390320">
     </a>
     <a class="indexterm" name="idm46045104388832">
     </a>
     <p>
      Run a tuple scan.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104384656">
     </a>
     <a class="indexterm" name="idm46045104383168">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for usage">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --usage
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit; same as
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_help">
       <code class="option">
        --help
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_delete_all_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-delete-all.html#option_ndb_delete_all_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104372480">
     </a>
     <a class="indexterm" name="idm46045104370992">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display version information and exit.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
