<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-blob-tool">
      </a>
      25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster
Tables
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045105979200">
  </a>
  <p>
   This tool can be used to check for and remove orphaned BLOB
        column parts from
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   tables, as
        well as to generate a file listing any orphaned parts. It is
        sometimes useful in diagnosing and repairing corrupted or
        damaged
   <code class="literal">
    NDB
   </code>
   tables containing
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     BLOB
    </code>
   </a>
   or
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   columns.
  </p>
  <p>
   The basic syntax for
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html" title="25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables">
    <span class="command">
     <strong>
      ndb_blob_tool
     </strong>
    </span>
   </a>
   is shown
        here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-simple"><div class="docs-select-all right" id="sa88010659"><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-simple">ndb_blob_tool <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">table</em> <span class="token punctuation">[</span><em class="replaceable">column</em><span class="token punctuation">,</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">]</span></code></pre>
  </div>
  <p>
   Unless you use the
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_help">
    <code class="option">
     --help
    </code>
   </a>
   option, you must specify an action to be performed by including
        one or more of the options
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_check-orphans">
    <code class="option">
     --check-orphans
    </code>
   </a>
   ,
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_delete-orphans">
    <code class="option">
     --delete-orphans
    </code>
   </a>
   , or
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_dump-file">
    <code class="option">
     --dump-file
    </code>
   </a>
   . These options
        cause
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html" title="25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables">
    <span class="command">
     <strong>
      ndb_blob_tool
     </strong>
    </span>
   </a>
   to check for orphaned
        BLOB parts, remove any orphaned BLOB parts, and generate a dump
        file listing orphaned BLOB parts, respectively, and are
        described in more detail later in this section.
  </p>
  <p>
   You must also specify the name of a table when invoking
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html" title="25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables">
    <span class="command">
     <strong>
      ndb_blob_tool
     </strong>
    </span>
   </a>
   . In addition, you can
        optionally follow the table name with the (comma-separated)
        names of one or more
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     BLOB
    </code>
   </a>
   or
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   columns from that table. If
        no columns are listed, the tool works on all of the table's
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     BLOB
    </code>
   </a>
   and
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   columns. If you need to
        specify a database, use the
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_database">
    <code class="option">
     --database
    </code>
   </a>
   (
   <code class="option">
    -d
   </code>
   ) option.
  </p>
  <p>
   The
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   option
        provides additional information in the output about the
        tool's progress.
  </p>
  <p>
   All options that can be used with
   <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>
   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_blob_tool_add-missing">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_add-missing">
       <code class="option">
        --add-missing
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105947712">
     </a>
     <a class="indexterm" name="idm46045105946224">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for add-missing">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --add-missing
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      For each inline part in NDB Cluster tables which has no
            corresponding BLOB part, write a dummy BLOB part of the
            required length, consisting of spaces.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105936384">
     </a>
     <a class="indexterm" name="idm46045105934928">
     </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_blob_tool_check-missing">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_check-missing">
       <code class="option">
        --check-missing
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105925072">
     </a>
     <a class="indexterm" name="idm46045105923584">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for check-missing">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --check-missing
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Check for inline parts in NDB Cluster tables which have no
            corresponding BLOB parts.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_check-orphans">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_check-orphans">
       <code class="option">
        --check-orphans
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105913920">
     </a>
     <a class="indexterm" name="idm46045105912432">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for check-orphans">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --check-orphans
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Check for BLOB parts in NDB Cluster tables which have no
            corresponding inline parts.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105902656">
     </a>
     <a class="indexterm" name="idm46045105901168">
     </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_blob_tool_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105882000">
     </a>
     <a class="indexterm" name="idm46045105880496">
     </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_blob_tool_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105861376">
     </a>
     <a class="indexterm" name="idm46045105859888">
     </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-blob-tool.html#option_ndb_blob_tool_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105844576">
     </a>
     <a class="indexterm" name="idm46045105843088">
     </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_blob_tool_database">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_database">
       <code class="option">
        --database=
        <em class="replaceable">
         <code>
          db_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -d
      </code>
     </p>
     <a class="indexterm" name="idm46045105832784">
     </a>
     <a class="indexterm" name="idm46045105831296">
     </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">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify the database to find the table in.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105816960">
     </a>
     <a class="indexterm" name="idm46045105815456">
     </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_blob_tool_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105801104">
     </a>
     <a class="indexterm" name="idm46045105799616">
     </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_blob_tool_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105785328">
     </a>
     <a class="indexterm" name="idm46045105783824">
     </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_blob_tool_delete-orphans">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_delete-orphans">
       <code class="option">
        --delete-orphans
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105769648">
     </a>
     <a class="indexterm" name="idm46045105768160">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for delete-orphans">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --delete-orphans
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Remove BLOB parts from NDB Cluster tables which have no
            corresponding inline parts.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_dump-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_dump-file">
       <code class="option">
        --dump-file=
        <em class="replaceable">
         <code>
          file
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105758160">
     </a>
     <a class="indexterm" name="idm46045105756672">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for dump-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --dump-file=file
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Writes a list of orphaned BLOB column parts to
      <em class="replaceable">
       <code>
        file
       </code>
      </em>
      . The information written to
            the file includes the table key and BLOB part number for
            each orphaned BLOB part.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105741920">
     </a>
     <a class="indexterm" name="idm46045105740432">
     </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_blob_tool_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105730752">
     </a>
     <a class="indexterm" name="idm46045105729264">
     </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_blob_tool_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105714992">
     </a>
     <a class="indexterm" name="idm46045105713504">
     </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_blob_tool_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105703840">
     </a>
     <a class="indexterm" name="idm46045105702384">
     </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_blob_tool_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105683408">
     </a>
     <a class="indexterm" name="idm46045105681920">
     </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_blob_tool_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105660800">
     </a>
     <a class="indexterm" name="idm46045105659312">
     </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-blob-tool.html#option_ndb_blob_tool_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105644128">
     </a>
     <a class="indexterm" name="idm46045105642640">
     </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
            --ndb-connectstring.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105628224">
     </a>
     <a class="indexterm" name="idm46045105626720">
     </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_blob_tool_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105616352">
     </a>
     <a class="indexterm" name="idm46045105614848">
     </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_blob_tool_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105591152">
     </a>
     <a class="indexterm" name="idm46045105589664">
     </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_blob_tool_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105579776">
     </a>
     <a class="indexterm" name="idm46045105578288">
     </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_blob_tool_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105568448">
     </a>
     <a class="indexterm" name="idm46045105566960">
     </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 --help.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_verbose">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105557376">
     </a>
     <a class="indexterm" name="idm46045105555888">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for verbose">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --verbose
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Provide extra information in the tool's output
            regarding its progress.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_blob_tool_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045105546080">
     </a>
     <a class="indexterm" name="idm46045105544592">
     </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>
  <h4>
   <a name="idm46045105536880">
   </a>
   Example
  </h4>
  <p>
   First we create an
   <code class="literal">
    NDB
   </code>
   table in the
   <code class="literal">
    test
   </code>
   database, using the
   <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
    <code class="literal">
     CREATE TABLE
    </code>
   </a>
   statement shown
        here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa34186763"><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">USE</span> test<span class="token punctuation">;</span>

<span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> btest <span class="token punctuation">(</span>
    c0 <span class="token datatype">BIGINT</span> <span class="token keyword">UNSIGNED</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword">AUTO_INCREMENT</span> <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span><span class="token punctuation">,</span>
    c1 <span class="token datatype">TEXT</span><span class="token punctuation">,</span>
    c2 <span class="token datatype">BLOB</span>
<span class="token punctuation">)</span>   <span class="token keyword">ENGINE</span><span class="token operator">=</span><span class="token keyword">NDB</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Then we insert a few rows into this table, using a series of
        statements similar to this one:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa25950062"><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">INSERT</span> <span class="token keyword">INTO</span> btest <span class="token keyword">VALUES</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'x'</span><span class="token punctuation">,</span> <span class="token function">REPEAT</span><span class="token punctuation">(</span><span class="token string">'x'</span><span class="token punctuation">,</span> <span class="token number">1000</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   When run with
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html#option_ndb_blob_tool_check-orphans">
    <code class="option">
     --check-orphans
    </code>
   </a>
   against
        this table,
   <a class="link" href="mysql-cluster-programs-ndb-blob-tool.html" title="25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables">
    <span class="command">
     <strong>
      ndb_blob_tool
     </strong>
    </span>
   </a>
   generates the
        following output:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa78271507"><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"><span class="token prompt">$&gt; </span><span class="token command">ndb_blob_tool</span> <span class="token property">--check-orphans</span> <span class="token property">--verbose</span> <span class="token property">-d</span> test btest
connected
processing 2 blobs
processing blob <span class="token comment" spellcheck="true">#0 c1 NDB$BLOB_19_1</span>
NDB$BLOB_19_1<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>1</span>
total parts<span class="token punctuation">:</span> 0
orphan parts<span class="token punctuation">:</span> 0
processing blob <span class="token comment" spellcheck="true">#1 c2 NDB$BLOB_19_2</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>0</span>
NDB$BLOB_19_2<span class="token punctuation">:</span> nextResult<span class="token punctuation">:</span> res<span class="token attr-value"><span class="token punctuation">=</span>1</span>
total parts<span class="token punctuation">:</span> 10
orphan parts<span class="token punctuation">:</span> 0
disconnected</code></pre>
  </div>
  <p>
   The tool reports that there are no
   <code class="literal">
    NDB
   </code>
   BLOB
        column parts associated with column
   <code class="literal">
    c1
   </code>
   , even
        though
   <code class="literal">
    c1
   </code>
   is a
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   column. This is due to the
        fact that, in an
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   table, only
        the first 256 bytes of a
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     BLOB
    </code>
   </a>
   or
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   column value are stored
        inline, and only the excess, if any, is stored separately; thus,
        if there are no values using more than 256 bytes in a given
        column of one of these types, no
   <code class="literal">
    BLOB
   </code>
   column
        parts are created by
   <code class="literal">
    NDB
   </code>
   for this column. See
   <a class="xref" href="storage-requirements.html" title="13.7 Data Type Storage Requirements">
    Section 13.7, “Data Type Storage Requirements”
   </a>
   , for more information.
  </p>
 </div>
 <br/>
</div>
