<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-index-stat">
      </a>
      25.5.14 ndb_index_stat — NDB Index Statistics Utility
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045101793264">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   provides per-fragment
        statistical information about indexes on
   <code class="literal">
    NDB
   </code>
   tables. This includes cache version and age, number of index
        entries per partition, and memory consumption by indexes.
  </p>
  <h4>
   <a name="idm46045101789600">
   </a>
   Usage
  </h4>
  <p>
   To obtain basic index statistics about a given
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   table, invoke
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   as shown here, with the name
        of the table as the first argument and the name of the database
        containing this table specified immediately following it, using
        the
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_database">
    <code class="option">
     --database
    </code>
   </a>
   (
   <code class="option">
    -d
   </code>
   ) option:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa14153968"><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_index_stat <em class="replaceable">table</em> <span class="token property">-d</span> <em class="replaceable">database</em></code></pre>
  </div>
  <p>
   In this example, we use
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   to
        obtain such information about an
   <code class="literal">
    NDB
   </code>
   table
        named
   <code class="literal">
    mytable
   </code>
   in the
   <code class="literal">
    test
   </code>
   database:
  </p>
  <a class="indexterm" name="idm46045101778624">
  </a>
  <a class="indexterm" name="idm46045101777136">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa61085393"><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_index_stat</span> <span class="token property">-d</span> test mytable
table<span class="token punctuation">:</span>City index<span class="token punctuation">:</span>PRIMARY fragCount<span class="token punctuation">:</span>2
sampleVersion<span class="token punctuation">:</span>3 loadTime<span class="token punctuation">:</span>1399585986 sampleCount<span class="token punctuation">:</span>1994 keyBytes<span class="token punctuation">:</span>7976
query cache<span class="token punctuation">:</span> valid<span class="token punctuation">:</span>1 sampleCount<span class="token punctuation">:</span>1994 totalBytes<span class="token punctuation">:</span>27916
times in ms<span class="token punctuation">:</span> save<span class="token punctuation">:</span> 7<span class="token punctuation">.</span>133 sort<span class="token punctuation">:</span> 1<span class="token punctuation">.</span>974 sort per sample<span class="token punctuation">:</span> 0<span class="token punctuation">.</span>000</code></pre>
  </div>
  <p>
   <code class="literal">
    sampleVersion
   </code>
   is the version number of the
        cache from which the statistics data is taken. Running
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   with the
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_update">
    <code class="option">
     --update
    </code>
   </a>
   option causes
        sampleVersion to be incremented.
  </p>
  <p>
   <code class="literal">
    loadTime
   </code>
   shows when the cache was last
        updated. This is expressed as seconds since the Unix Epoch.
  </p>
  <p>
   <code class="literal">
    sampleCount
   </code>
   is the number of index entries
        found per partition. You can estimate the total number of
        entries by multiplying this by the number of fragments (shown as
   <code class="literal">
    fragCount
   </code>
   ).
  </p>
  <p>
   <code class="literal">
    sampleCount
   </code>
   can be compared with the
        cardinality of
   <a class="link" href="show-index.html" title="15.7.7.23 SHOW INDEX Statement">
    <code class="literal">
     SHOW INDEX
    </code>
   </a>
   or
   <a class="link" href="information-schema-statistics-table.html" title="28.3.34 The INFORMATION_SCHEMA STATISTICS Table">
    <code class="literal">
     INFORMATION_SCHEMA.STATISTICS
    </code>
   </a>
   ,
        although the latter two provide a view of the table as a whole,
        while
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   provides a per-fragment
        average.
  </p>
  <p>
   <code class="literal">
    keyBytes
   </code>
   is the number of bytes used by the
        index. In this example, the primary key is an integer, which
        requires four bytes for each index, so
   <code class="literal">
    keyBytes
   </code>
   can be calculated in this case as
        shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-simple"><div class="docs-select-all right" id="sa56654575"><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">    keyBytes <span class="token operator">=</span> sampleCount <span class="token operator">*</span> <span class="token punctuation">(</span>4 bytes per index<span class="token punctuation">)</span> <span class="token operator">=</span> 1994 <span class="token operator">*</span> 4 <span class="token operator">=</span> 7976</code></pre>
  </div>
  <p>
   This information can also be obtained using the corresponding
        column definitions from
   <a class="link" href="information-schema-columns-table.html" title="28.3.8 The INFORMATION_SCHEMA COLUMNS Table">
    <code class="literal">
     INFORMATION_SCHEMA.COLUMNS
    </code>
   </a>
   (this
        requires a MySQL Server and a MySQL client application).
  </p>
  <p>
   <code class="literal">
    totalBytes
   </code>
   is the total memory consumed by
        all indexes on the table, in bytes.
  </p>
  <p>
   Timings shown in the preceding examples are specific to each
        invocation of
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   option
        provides some additional output, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa91359579"><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_index_stat</span> <span class="token property">-d</span> test mytable <span class="token property">--verbose</span>
random seed 1337010518
connected
loop 1 of 1
table<span class="token punctuation">:</span>mytable index<span class="token punctuation">:</span>PRIMARY fragCount<span class="token punctuation">:</span>4
sampleVersion<span class="token punctuation">:</span>2 loadTime<span class="token punctuation">:</span>1336751773 sampleCount<span class="token punctuation">:</span>0 keyBytes<span class="token punctuation">:</span>0
read stats
query cache created
query cache<span class="token punctuation">:</span> valid<span class="token punctuation">:</span>1 sampleCount<span class="token punctuation">:</span>0 totalBytes<span class="token punctuation">:</span>0
times in ms<span class="token punctuation">:</span> save<span class="token punctuation">:</span> 20<span class="token punctuation">.</span>766 sort<span class="token punctuation">:</span> 0<span class="token punctuation">.</span>001
disconnected

$&gt;</code></pre>
  </div>
  <p>
   If the output from the program is empty, this may indicate that
        no statistics yet exist. To force them to be created (or updated
        if they already exist), invoke
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   with the
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_update">
    <code class="option">
     --update
    </code>
   </a>
   option,
        or execute
   <a class="link" href="analyze-table.html" title="15.7.3.1 ANALYZE TABLE Statement">
    <code class="literal">
     ANALYZE TABLE
    </code>
   </a>
   on the
        table in the
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client.
  </p>
  <h4>
   <a name="idm46045101744960">
   </a>
   Options
  </h4>
  <p>
   The following table includes options that are specific to the
        NDB Cluster
   <a class="link" href="mysql-cluster-programs-ndb-index-stat.html" title="25.5.14 ndb_index_stat — NDB Index Statistics Utility">
    <span class="command">
     <strong>
      ndb_index_stat
     </strong>
    </span>
   </a>
   utility.
        Additional descriptions are listed following the table.
  </p>
  <p>
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101739328">
     </a>
     <a class="indexterm" name="idm46045101737824">
     </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_index_stat_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101728032">
     </a>
     <a class="indexterm" name="idm46045101726544">
     </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_index_stat_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101707440">
     </a>
     <a class="indexterm" name="idm46045101705936">
     </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_index_stat_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101686816">
     </a>
     <a class="indexterm" name="idm46045101685328">
     </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-index-stat.html#option_ndb_index_stat_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101669968">
     </a>
     <a class="indexterm" name="idm46045101668480">
     </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_index_stat_database">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_database">
       <code class="option">
        --database=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -d
       <em class="replaceable">
        <code>
         name
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045101657824">
     </a>
     <a class="indexterm" name="idm46045101656336">
     </a>
     <a class="indexterm" name="idm46045101654848">
     </a>
     <a class="indexterm" name="idm46045101653360">
     </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>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The name of the database that contains the table being
            queried.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101634416">
     </a>
     <a class="indexterm" name="idm46045101632912">
     </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_index_stat_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101618624">
     </a>
     <a class="indexterm" name="idm46045101617136">
     </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_index_stat_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101602848">
     </a>
     <a class="indexterm" name="idm46045101601344">
     </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_index_stat_delete">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_delete">
       <code class="option">
        --delete
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101587056">
     </a>
     <a class="indexterm" name="idm46045101585568">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for delete">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --delete
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Delete the index statistics for the given table, stopping
            any auto-update that was previously configured.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_dump">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_dump">
       <code class="option">
        --dump
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101575792">
     </a>
     <a class="indexterm" name="idm46045101574304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for dump">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --dump
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Dump the contents of the query cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101564608">
     </a>
     <a class="indexterm" name="idm46045101563120">
     </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_index_stat_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101553376">
     </a>
     <a class="indexterm" name="idm46045101551888">
     </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_index_stat_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101537616">
     </a>
     <a class="indexterm" name="idm46045101536128">
     </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_index_stat_loops">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_loops">
       <code class="option">
        --loops=
        <em class="replaceable">
         <code>
          #
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101526096">
     </a>
     <a class="indexterm" name="idm46045101524608">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for loops">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --loops=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </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">
           MAX_INT
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Repeat commands this number of times (for use in testing).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101505680">
     </a>
     <a class="indexterm" name="idm46045101504224">
     </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_index_stat_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101485184">
     </a>
     <a class="indexterm" name="idm46045101483696">
     </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_index_stat_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101462576">
     </a>
     <a class="indexterm" name="idm46045101461088">
     </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-index-stat.html#option_ndb_index_stat_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101445840">
     </a>
     <a class="indexterm" name="idm46045101444352">
     </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-index-stat.html#option_ndb_index_stat_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101429040">
     </a>
     <a class="indexterm" name="idm46045101427536">
     </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_index_stat_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101417104">
     </a>
     <a class="indexterm" name="idm46045101415600">
     </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_index_stat_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101391840">
     </a>
     <a class="indexterm" name="idm46045101390352">
     </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_index_stat_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101380528">
     </a>
     <a class="indexterm" name="idm46045101379040">
     </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_index_stat_query">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_query">
       <code class="option">
        --query=
        <em class="replaceable">
         <code>
          #
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101369008">
     </a>
     <a class="indexterm" name="idm46045101367520">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for query">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --query=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </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">
           MAX_INT
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Perform random range queries on first key attribute (must be
            int unsigned).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-drop">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-drop">
       <code class="option">
        --sys-drop
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101348320">
     </a>
     <a class="indexterm" name="idm46045101346832">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-drop">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-drop
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Drop all statistics tables and events in the NDB kernel.
      <span class="emphasis">
       <em>
        This causes all statistics to be lost
       </em>
      </span>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-create">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create">
       <code class="option">
        --sys-create
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101336528">
     </a>
     <a class="indexterm" name="idm46045101335040">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-create">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-create
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Create all statistics tables and events in the NDB kernel.
            This works only if none of them exist previously.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-create-if-not-exist">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create-if-not-exist">
       <code class="option">
        --sys-create-if-not-exist
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101325088">
     </a>
     <a class="indexterm" name="idm46045101323584">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-create-if-not-exist">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-create-if-not-exist
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Create any NDB system statistics tables or events (or both)
            that do not already exist when the program is invoked.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-create-if-not-valid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create-if-not-valid">
       <code class="option">
        --sys-create-if-not-valid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101313616">
     </a>
     <a class="indexterm" name="idm46045101312112">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-create-if-not-valid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-create-if-not-valid
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Create any NDB system statistics tables or events that do
            not already exist, after dropping any that are invalid.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-check">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-check">
       <code class="option">
        --sys-check
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101302240">
     </a>
     <a class="indexterm" name="idm46045101300752">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-check
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Verify that all required system statistics tables and events
            exist in the NDB kernel.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-skip-tables">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-skip-tables">
       <code class="option">
        --sys-skip-tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101290976">
     </a>
     <a class="indexterm" name="idm46045101289488">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-skip-tables">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-skip-tables
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not apply any
      <code class="option">
       --sys-*
      </code>
      options to any
            statistics tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_sys-skip-events">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-skip-events">
       <code class="option">
        --sys-skip-events
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101279248">
     </a>
     <a class="indexterm" name="idm46045101277760">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for sys-skip-events">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --sys-skip-events
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not apply any
      <code class="option">
       --sys-*
      </code>
      options to any
            events.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_update">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_update">
       <code class="option">
        --update
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101267712">
     </a>
     <a class="indexterm" name="idm46045101266224">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for update">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --update
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Update the index statistics for the given table, and restart
            any auto-update that was previously configured.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101256384">
     </a>
     <a class="indexterm" name="idm46045101254896">
     </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-index-stat.html#option_ndb_index_stat_help">
       <code class="option">
        --help
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_verbose">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101244320">
     </a>
     <a class="indexterm" name="idm46045101242832">
     </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>
      Turn on verbose output.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_index_stat_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101233152">
     </a>
     <a class="indexterm" name="idm46045101231664">
     </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>
  <p>
   <a name="ndb-index-stat-options-system">
   </a>
   <b>
    ndb_index_stat system options.
   </b>
   The following options are used to generate and update the
          statistics tables in the NDB kernel. None of these options can
          be mixed with statistics options (see
   <a class="xref" href="mysql-cluster-programs-ndb-index-stat.html#ndb-index-stat-options-statistics" title="ndb_index_stat statistics options">
    ndb_index_stat statistics options
   </a>
   ).
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-drop">
       <code class="option">
        --sys-drop
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create">
       <code class="option">
        --sys-create
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create-if-not-exist">
       <code class="option">
        --sys-create-if-not-exist
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-create-if-not-valid">
       <code class="option">
        --sys-create-if-not-valid
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-check">
       <code class="option">
        --sys-check
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-skip-tables">
       <code class="option">
        --sys-skip-tables
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_sys-skip-events">
       <code class="option">
        --sys-skip-events
       </code>
      </a>
     </p>
    </li>
   </ul>
  </div>
  <p>
   <a name="ndb-index-stat-options-statistics">
   </a>
   <b>
    ndb_index_stat statistics options.
   </b>
   The options listed here are used to generate index statistics.
          They work with a given table and database. They cannot be
          mixed with system options (see
   <a class="xref" href="mysql-cluster-programs-ndb-index-stat.html#ndb-index-stat-options-system" title="ndb_index_stat system options">
    ndb_index_stat system options
   </a>
   ).
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_database">
       <code class="option">
        --database
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_delete">
       <code class="option">
        --delete
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_update">
       <code class="option">
        --update
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_dump">
       <code class="option">
        --dump
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysql-cluster-programs-ndb-index-stat.html#option_ndb_index_stat_query">
       <code class="option">
        --query
       </code>
      </a>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
