<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-desc">
      </a>
      25.5.9 ndb_desc — Describe NDB Tables
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045104362160">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   provides a detailed description of
        one or more
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   tables.
  </p>
  <h4>
   <a name="idm46045104358240">
   </a>
   Usage
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa65473886"><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_desc <span class="token property">-c</span> <em class="replaceable">connection_string</em> <em class="replaceable">tbl_name</em> <span class="token property">-d</span> <em class="replaceable">db_name</em> <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span>

ndb_desc <span class="token property">-c</span> <em class="replaceable">connection_string</em> <em class="replaceable">index_name</em> <span class="token property">-d</span> <em class="replaceable">db_name</em> <span class="token property">-t</span> <em class="replaceable">tbl_name</em></code></pre>
  </div>
  <p>
   Additional options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   are listed later in this section.
  </p>
  <h4>
   <a name="idm46045104351328">
   </a>
   Sample Output
  </h4>
  <p>
   MySQL table creation and population statements:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa45158647"><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> fish <span class="token punctuation">(</span>
    id <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword">AUTO_INCREMENT</span><span class="token punctuation">,</span>
    <span class="token keyword">name</span> <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">20</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
    length_mm <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
    weight_gm <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>

    <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span> pk <span class="token punctuation">(</span>id<span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token keyword">UNIQUE</span> <span class="token keyword">KEY</span> uk <span class="token punctuation">(</span><span class="token keyword">name</span><span class="token punctuation">)</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>

<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> fish <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">'guppy'</span><span class="token punctuation">,</span> <span class="token number">35</span><span class="token punctuation">,</span> <span class="token number">2</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'tuna'</span><span class="token punctuation">,</span> <span class="token number">2500</span><span class="token punctuation">,</span> <span class="token number">150000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'shark'</span><span class="token punctuation">,</span> <span class="token number">3000</span><span class="token punctuation">,</span> <span class="token number">110000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'manta ray'</span><span class="token punctuation">,</span> <span class="token number">1500</span><span class="token punctuation">,</span> <span class="token number">50000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'grouper'</span><span class="token punctuation">,</span> <span class="token number">900</span><span class="token punctuation">,</span> <span class="token number">125000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span> <span class="token punctuation">,</span><span class="token string">'puffer'</span><span class="token punctuation">,</span> <span class="token number">250</span><span class="token punctuation">,</span> <span class="token number">2500</span><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Output from
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa50222187"><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_desc</span> <span class="token property">-c</span> localhost fish <span class="token property">-d</span> test <span class="token property">-p</span>
<span class="token property">--</span> fish <span class="token property">--</span>
Version<span class="token punctuation">:</span> 2
Fragment type<span class="token punctuation">:</span> HashMapPartition
K Value<span class="token punctuation">:</span> 6
Min load factor<span class="token punctuation">:</span> 78
Max load factor<span class="token punctuation">:</span> 80
Temporary table<span class="token punctuation">:</span> no
Number of attributes<span class="token punctuation">:</span> 4
Number of primary keys<span class="token punctuation">:</span> 1
Length of frm data<span class="token punctuation">:</span> 337
Max Rows<span class="token punctuation">:</span> 0
Row Checksum<span class="token punctuation">:</span> 1
Row GCI<span class="token punctuation">:</span> 1
SingleUserMode<span class="token punctuation">:</span> 0
ForceVarPart<span class="token punctuation">:</span> 1
PartitionCount<span class="token punctuation">:</span> 2
FragmentCount<span class="token punctuation">:</span> 2
PartitionBalance<span class="token punctuation">:</span> FOR_RP_BY_LDM
ExtraRowGciBits<span class="token punctuation">:</span> 0
ExtraRowAuthorBits<span class="token punctuation">:</span> 0
TableStatus<span class="token punctuation">:</span> Retrieved
Table options<span class="token punctuation">:</span>
HashMap<span class="token punctuation">:</span> DEFAULT-HASHMAP-3840-2
<span class="token property">--</span> Attributes <span class="token property">--</span>
id Int PRIMARY KEY DISTRIBUTION KEY AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> AUTO_INCR
name Varchar<span class="token punctuation">(</span>20<span class="token punctuation">;</span>latin1_swedish_ci<span class="token punctuation">)</span> NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>SHORT_VAR</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
length_mm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
weight_gm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
<span class="token property">--</span> Indexes <span class="token property">--</span>
PRIMARY KEY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - UniqueHashIndex
PRIMARY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - OrderedIndex
uk<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - OrderedIndex
uk$unique<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - UniqueHashIndex
<span class="token property">--</span> Per partition info <span class="token property">--</span>
Partition       Row count       Commit count    Frag fixed memory       Frag varsized memory    Extent_space    Free extent_space
0               2               2               32768                   32768                   0               0
1               4               4               32768                   32768                   0               0</code></pre>
  </div>
  <p>
   Information about multiple tables can be obtained in a single
        invocation of
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   by using their names,
        separated by spaces. All of the tables must be in the same
        database.
  </p>
  <p>
   You can obtain additional information about a specific index
        using the
   <code class="option">
    --table
   </code>
   (short form:
   <code class="option">
    -t
   </code>
   ) option and supplying the name of the index
        as the first argument to
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   , as shown
        here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa97885824"><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_desc</span> uk <span class="token property">-d</span> test <span class="token property">-t</span> fish
<span class="token property">--</span> uk <span class="token property">--</span>
Version<span class="token punctuation">:</span> 2
Base table<span class="token punctuation">:</span> fish
Number of attributes<span class="token punctuation">:</span> 1
Logging<span class="token punctuation">:</span> 0
Index type<span class="token punctuation">:</span> OrderedIndex
Index status<span class="token punctuation">:</span> Retrieved
<span class="token property">--</span> Attributes <span class="token property">--</span>
name Varchar<span class="token punctuation">(</span>20<span class="token punctuation">;</span>latin1_swedish_ci<span class="token punctuation">)</span> NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>SHORT_VAR</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span>
<span class="token property">--</span> IndexTable 10/uk <span class="token property">--</span>
Version<span class="token punctuation">:</span> 2
Fragment type<span class="token punctuation">:</span> FragUndefined
K Value<span class="token punctuation">:</span> 6
Min load factor<span class="token punctuation">:</span> 78
Max load factor<span class="token punctuation">:</span> 80
Temporary table<span class="token punctuation">:</span> yes
Number of attributes<span class="token punctuation">:</span> 2
Number of primary keys<span class="token punctuation">:</span> 1
Length of frm data<span class="token punctuation">:</span> 0
Max Rows<span class="token punctuation">:</span> 0
Row Checksum<span class="token punctuation">:</span> 1
Row GCI<span class="token punctuation">:</span> 1
SingleUserMode<span class="token punctuation">:</span> 2
ForceVarPart<span class="token punctuation">:</span> 0
PartitionCount<span class="token punctuation">:</span> 2
FragmentCount<span class="token punctuation">:</span> 2
FragmentCountType<span class="token punctuation">:</span> ONE_PER_LDM_PER_NODE
ExtraRowGciBits<span class="token punctuation">:</span> 0
ExtraRowAuthorBits<span class="token punctuation">:</span> 0
TableStatus<span class="token punctuation">:</span> Retrieved
Table options<span class="token punctuation">:</span>
<span class="token property">--</span> Attributes <span class="token property">--</span>
name Varchar<span class="token punctuation">(</span>20<span class="token punctuation">;</span>latin1_swedish_ci<span class="token punctuation">)</span> NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>SHORT_VAR</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span>
NDB$TNODE Unsigned <span class="token punctuation">[</span>64<span class="token punctuation">]</span> PRIMARY KEY DISTRIBUTION KEY AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span>
<span class="token property">--</span> Indexes <span class="token property">--</span>
PRIMARY KEY<span class="token punctuation">(</span>NDB$TNODE<span class="token punctuation">)</span> - UniqueHashIndex</code></pre>
  </div>
  <p>
   When an index is specified in this way, the
   <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-partition-info">
    <code class="option">
     --extra-partition-info
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-node-info">
    <code class="option">
     --extra-node-info
    </code>
   </a>
   options have
        no effect.
  </p>
  <p>
   The
   <code class="literal">
    Version
   </code>
   column in the output contains the
        table's schema object version. For information about
        interpreting this value, see
   <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-schema-object-versions.html" target="_top">
    NDB Schema Object Versions
   </a>
   .
  </p>
  <p>
   Three of the table properties that can be set using
   <code class="literal">
    NDB_TABLE
   </code>
   comments embedded in
   <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
    <code class="literal">
     CREATE TABLE
    </code>
   </a>
   and
   <a class="link" href="alter-table.html" title="15.1.9 ALTER TABLE Statement">
    <code class="literal">
     ALTER TABLE
    </code>
   </a>
   statements are also
        visible in
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   output. The table's
   <code class="literal">
    FRAGMENT_COUNT_TYPE
   </code>
   is always shown in the
   <code class="literal">
    FragmentCountType
   </code>
   column.
   <code class="literal">
    READ_ONLY
   </code>
   and
   <code class="literal">
    FULLY_REPLICATED
   </code>
   , if set to 1, are shown in
        the
   <code class="literal">
    Table options
   </code>
   column. You can see this
        after executing the following
   <a class="link" href="alter-table.html" title="15.1.9 ALTER TABLE Statement">
    <code class="literal">
     ALTER
        TABLE
    </code>
   </a>
   statement 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>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa39763894"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">ALTER</span> <span class="token keyword">TABLE</span> fish <span class="token keyword">COMMENT</span><span class="token operator">=</span><span class="token string">'NDB_TABLE=READ_ONLY=1,FULLY_REPLICATED=1'</span><span class="token punctuation">;</span>
<span class="token output">1 row in set, 1 warning (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">WARNINGS</span>\G
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Level   <span class="token punctuation">|</span> Code <span class="token punctuation">|</span> Message                                                                                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Warning <span class="token punctuation">|</span> 1296 <span class="token punctuation">|</span> Got error 4503 'Table property is FRAGMENT_COUNT_TYPE=ONE_PER_LDM_PER_NODE but not in comment' from NDB <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   The warning is issued because
   <code class="literal">
    READ_ONLY=1
   </code>
   requires that the table's fragment count type is (or be set
        to)
   <code class="literal">
    ONE_PER_LDM_PER_NODE_GROUP
   </code>
   ;
   <code class="literal">
    NDB
   </code>
   sets this automatically in such cases.
        You can check that the
   <code class="literal">
    ALTER TABLE
   </code>
   statement
        has the desired effect using
   <a class="link" href="show-create-table.html" title="15.7.7.11 SHOW CREATE TABLE Statement">
    <code class="literal">
     SHOW CREATE
        TABLE
    </code>
   </a>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa7471509"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> fish\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
       Table<span class="token punctuation">:</span> fish
Create Table<span class="token punctuation">:</span> CREATE TABLE `fish` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `length_mm` int(11) NOT NULL,
  `weight_gm` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk` (`name`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
COMMENT='NDB_TABLE=READ_BACKUP=1,FULLY_REPLICATED=1'
</span><span class="token output">1 row in set (0.01 sec)</span></code></pre>
  </div>
  <p>
   Because
   <code class="literal">
    FRAGMENT_COUNT_TYPE
   </code>
   was not set
        explicitly, its value is not shown in the comment text printed
        by
   <code class="literal">
    SHOW CREATE TABLE
   </code>
   .
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   , however, displays the updated value
        for this attribute. The
   <code class="literal">
    Table options
   </code>
   column
        shows the binary properties just enabled. You can see this in
        the output shown here (emphasized text):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa46043361"><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_desc</span> <span class="token property">-c</span> localhost fish <span class="token property">-d</span> test <span class="token property">-p</span>
<span class="token property">--</span> fish <span class="token property">--</span>
Version<span class="token punctuation">:</span> 4
Fragment type<span class="token punctuation">:</span> HashMapPartition
K Value<span class="token punctuation">:</span> 6
Min load factor<span class="token punctuation">:</span> 78
Max load factor<span class="token punctuation">:</span> 80
Temporary table<span class="token punctuation">:</span> no
Number of attributes<span class="token punctuation">:</span> 4
Number of primary keys<span class="token punctuation">:</span> 1
Length of frm data<span class="token punctuation">:</span> 380
Max Rows<span class="token punctuation">:</span> 0
Row Checksum<span class="token punctuation">:</span> 1
Row GCI<span class="token punctuation">:</span> 1
SingleUserMode<span class="token punctuation">:</span> 0
ForceVarPart<span class="token punctuation">:</span> 1
PartitionCount<span class="token punctuation">:</span> 1
FragmentCount<span class="token punctuation">:</span> 1
<em>FragmentCountType<span class="token punctuation">:</span> ONE_PER_LDM_PER_NODE_GROUP</em>
ExtraRowGciBits<span class="token punctuation">:</span> 0
ExtraRowAuthorBits<span class="token punctuation">:</span> 0
TableStatus<span class="token punctuation">:</span> Retrieved
<em>Table options<span class="token punctuation">:</span> readbackup<span class="token punctuation">,</span> fullyreplicated</em>
HashMap<span class="token punctuation">:</span> DEFAULT-HASHMAP-3840-1
<span class="token property">--</span> Attributes <span class="token property">--</span>
id Int PRIMARY KEY DISTRIBUTION KEY AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> AUTO_INCR
name Varchar<span class="token punctuation">(</span>20<span class="token punctuation">;</span>latin1_swedish_ci<span class="token punctuation">)</span> NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>SHORT_VAR</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
length_mm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
weight_gm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> DYNAMIC
<span class="token property">--</span> Indexes <span class="token property">--</span>
PRIMARY KEY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - UniqueHashIndex
PRIMARY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - OrderedIndex
uk<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - OrderedIndex
uk$unique<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - UniqueHashIndex
<span class="token property">--</span> Per partition info <span class="token property">--</span>
Partition       Row count       Commit count    Frag fixed memory       Frag varsized memory    Extent_space    Free extent_space</code></pre>
  </div>
  <p>
   For more information about these table properties, see
   <a class="xref" href="create-table-ndb-comment-options.html" title="15.1.20.12 Setting NDB Comment Options">
    Section 15.1.20.12, “Setting NDB Comment Options”
   </a>
   .
  </p>
  <p>
   The
   <code class="literal">
    Extent_space
   </code>
   and
   <code class="literal">
    Free
        extent_space
   </code>
   columns are applicable only to
   <code class="literal">
    NDB
   </code>
   tables having columns on disk; for tables
        having only in-memory columns, these columns always contain the
        value
   <code class="literal">
    0
   </code>
   .
  </p>
  <p>
   To illustrate their use, we modify the previous example. First,
        we must create the necessary Disk Data objects, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa3520518"><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">CREATE</span> <span class="token keyword">LOGFILE</span> <span class="token keyword">GROUP</span> lg_1
    <span class="token keyword">ADD</span> <span class="token keyword">UNDOFILE</span> <span class="token string">'undo_1.log'</span>
    <span class="token keyword">INITIAL_SIZE</span> 16M
    <span class="token keyword">UNDO_BUFFER_SIZE</span> 2M
    <span class="token keyword">ENGINE</span> <span class="token keyword">NDB</span><span class="token punctuation">;</span>

<span class="token keyword">ALTER</span> <span class="token keyword">LOGFILE</span> <span class="token keyword">GROUP</span> lg_1
    <span class="token keyword">ADD</span> <span class="token keyword">UNDOFILE</span> <span class="token string">'undo_2.log'</span>
    <span class="token keyword">INITIAL_SIZE</span> 12M
    <span class="token keyword">ENGINE</span> <span class="token keyword">NDB</span><span class="token punctuation">;</span>

<span class="token keyword">CREATE</span> <span class="token keyword">TABLESPACE</span> ts_1
    <span class="token keyword">ADD</span> <span class="token keyword">DATAFILE</span> <span class="token string">'data_1.dat'</span>
    <span class="token keyword">USE</span> <span class="token keyword">LOGFILE</span> <span class="token keyword">GROUP</span> lg_1
    <span class="token keyword">INITIAL_SIZE</span> 32M
    <span class="token keyword">ENGINE</span> <span class="token keyword">NDB</span><span class="token punctuation">;</span>

<span class="token keyword">ALTER</span> <span class="token keyword">TABLESPACE</span> ts_1
    <span class="token keyword">ADD</span> <span class="token keyword">DATAFILE</span> <span class="token string">'data_2.dat'</span>
    <span class="token keyword">INITIAL_SIZE</span> 48M
    <span class="token keyword">ENGINE</span> <span class="token keyword">NDB</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   (For more information on the statements just shown and the
        objects created by them, see
   <a class="xref" href="mysql-cluster-disk-data-objects.html" title="25.6.11.1 NDB Cluster Disk Data Objects">
    Section 25.6.11.1, “NDB Cluster Disk Data Objects”
   </a>
   , as well as
   <a class="xref" href="create-logfile-group.html" title="15.1.16 CREATE LOGFILE GROUP Statement">
    Section 15.1.16, “CREATE LOGFILE GROUP Statement”
   </a>
   , and
   <a class="xref" href="create-tablespace.html" title="15.1.21 CREATE TABLESPACE Statement">
    Section 15.1.21, “CREATE TABLESPACE Statement”
   </a>
   .)
  </p>
  <p>
   Now we can create and populate a version of the
   <code class="literal">
    fish
   </code>
   table that stores 2 of its columns on
        disk (deleting the previous version of the table first, if it
        already exists):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa71571622"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">DROP</span> <span class="token keyword">TABLE</span> <span class="token keyword">IF</span> <span class="token keyword">EXISTS</span> fish<span class="token punctuation">;</span>

<span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> fish <span class="token punctuation">(</span>
    id <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword">AUTO_INCREMENT</span><span class="token punctuation">,</span>
    <span class="token keyword">name</span> <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">20</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
    length_mm <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
    weight_gm <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>

    <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span> pk <span class="token punctuation">(</span>id<span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token keyword">UNIQUE</span> <span class="token keyword">KEY</span> uk <span class="token punctuation">(</span><span class="token keyword">name</span><span class="token punctuation">)</span>
<span class="token punctuation">)</span> <span class="token keyword">TABLESPACE</span> ts_1 <span class="token keyword">STORAGE</span> <span class="token keyword">DISK</span>
<span class="token keyword">ENGINE</span><span class="token operator">=</span><span class="token keyword">NDB</span><span class="token punctuation">;</span>

<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> fish <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">'guppy'</span><span class="token punctuation">,</span> <span class="token number">35</span><span class="token punctuation">,</span> <span class="token number">2</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'tuna'</span><span class="token punctuation">,</span> <span class="token number">2500</span><span class="token punctuation">,</span> <span class="token number">150000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'shark'</span><span class="token punctuation">,</span> <span class="token number">3000</span><span class="token punctuation">,</span> <span class="token number">110000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'manta ray'</span><span class="token punctuation">,</span> <span class="token number">1500</span><span class="token punctuation">,</span> <span class="token number">50000</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <span class="token punctuation">(</span><span class="token boolean">NULL</span><span class="token punctuation">,</span> <span class="token string">'grouper'</span><span class="token punctuation">,</span> <span class="token number">900</span><span class="token punctuation">,</span> <span class="token number">125000</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token punctuation">(</span><span class="token boolean">NULL</span> <span class="token punctuation">,</span><span class="token string">'puffer'</span><span class="token punctuation">,</span> <span class="token number">250</span><span class="token punctuation">,</span> <span class="token number">2500</span><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   When run against this version of the table,
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   displays the following output:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa50004736"><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_desc</span> <span class="token property">-c</span> localhost fish <span class="token property">-d</span> test <span class="token property">-p</span>
<span class="token property">--</span> fish <span class="token property">--</span>
Version<span class="token punctuation">:</span> 1
Fragment type<span class="token punctuation">:</span> HashMapPartition
K Value<span class="token punctuation">:</span> 6
Min load factor<span class="token punctuation">:</span> 78
Max load factor<span class="token punctuation">:</span> 80
Temporary table<span class="token punctuation">:</span> no
Number of attributes<span class="token punctuation">:</span> 4
Number of primary keys<span class="token punctuation">:</span> 1
Length of frm data<span class="token punctuation">:</span> 1001
Max Rows<span class="token punctuation">:</span> 0
Row Checksum<span class="token punctuation">:</span> 1
Row GCI<span class="token punctuation">:</span> 1
SingleUserMode<span class="token punctuation">:</span> 0
ForceVarPart<span class="token punctuation">:</span> 1
PartitionCount<span class="token punctuation">:</span> 2
FragmentCount<span class="token punctuation">:</span> 2
PartitionBalance<span class="token punctuation">:</span> FOR_RP_BY_LDM
ExtraRowGciBits<span class="token punctuation">:</span> 0
ExtraRowAuthorBits<span class="token punctuation">:</span> 0
TableStatus<span class="token punctuation">:</span> Retrieved
Table options<span class="token punctuation">:</span> readbackup
HashMap<span class="token punctuation">:</span> DEFAULT-HASHMAP-3840-2
Tablespace id<span class="token punctuation">:</span> 16
Tablespace<span class="token punctuation">:</span> ts_1
<span class="token property">--</span> Attributes <span class="token property">--</span>
id Int PRIMARY KEY DISTRIBUTION KEY AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span> AUTO_INCR
name Varchar<span class="token punctuation">(</span>80<span class="token punctuation">;</span>utf8mb4_0900_ai_ci<span class="token punctuation">)</span> NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>SHORT_VAR</span> ST<span class="token attr-value"><span class="token punctuation">=</span>MEMORY</span>
length_mm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>DISK</span>
weight_gm Int NOT NULL AT<span class="token attr-value"><span class="token punctuation">=</span>FIXED</span> ST<span class="token attr-value"><span class="token punctuation">=</span>DISK</span>
<span class="token property">--</span> Indexes <span class="token property">--</span>
PRIMARY KEY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - UniqueHashIndex
PRIMARY<span class="token punctuation">(</span>id<span class="token punctuation">)</span> - OrderedIndex
uk<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - OrderedIndex
uk$unique<span class="token punctuation">(</span>name<span class="token punctuation">)</span> - UniqueHashIndex
<span class="token property">--</span> Per partition info <span class="token property">--</span>
Partition       Row count       Commit count    Frag fixed memory       Frag varsized memory    Extent_space    Free extent_space
0               2               2               32768                   32768                   1048576         1044440
1               4               4               32768                   32768                   1048576         1044400</code></pre>
  </div>
  <p>
   This means that 1048576 bytes are allocated from the tablespace
        for this table on each partition, of which 1044440 bytes remain
        free for additional storage. In other words, 1048576 - 1044440 =
        4136 bytes per partition is currently being used to store the
        data from this table's disk-based columns. The number of
        bytes shown as
   <code class="literal">
    Free extent_space
   </code>
   is available
        for storing on-disk column data from the
   <code class="literal">
    fish
   </code>
   table only; for this reason, it is not visible when selecting
        from the Information Schema
   <a class="link" href="information-schema-files-table.html" title="28.3.15 The INFORMATION_SCHEMA FILES Table">
    <code class="literal">
     FILES
    </code>
   </a>
   table.
  </p>
  <p>
   <code class="literal">
    Tablespace id
   </code>
   and
   <code class="literal">
    Tablespace
   </code>
   are also displayed for Disk Data
        tables.
  </p>
  <p>
   For fully replicated tables,
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </strong>
    </span>
   </a>
   shows
        only the nodes holding primary partition fragment replicas;
        nodes with copy fragment replicas (only) are ignored. You can
        obtain such information, using 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, from the
   <a class="link" href="mysql-cluster-ndbinfo-table-distribution-status.html" title="25.6.17.57 The ndbinfo table_distribution_status Table">
    <code class="literal">
     table_distribution_status
    </code>
   </a>
   ,
   <a class="link" href="mysql-cluster-ndbinfo-table-fragments.html" title="25.6.17.58 The ndbinfo table_fragments Table">
    <code class="literal">
     table_fragments
    </code>
   </a>
   ,
   <a class="link" href="mysql-cluster-ndbinfo-table-info.html" title="25.6.17.59 The ndbinfo table_info Table">
    <code class="literal">
     table_info
    </code>
   </a>
   , and
   <a class="link" href="mysql-cluster-ndbinfo-table-replicas.html" title="25.6.17.60 The ndbinfo table_replicas Table">
    <code class="literal">
     table_replicas
    </code>
   </a>
   tables in the
   <a class="link" href="mysql-cluster-ndbinfo.html" title="25.6.17 ndbinfo: The NDB Cluster Information Database">
    <code class="literal">
     ndbinfo
    </code>
   </a>
   database.
  </p>
  <p>
   All options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-desc.html" title="25.5.9 ndb_desc — Describe NDB Tables">
    <span class="command">
     <strong>
      ndb_desc
     </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_desc_auto-inc">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_auto-inc">
       <code class="option">
        --auto-inc
       </code>
      </a>
      ,
      <code class="option">
       -a
      </code>
     </p>
     <a class="indexterm" name="idm46045104263744">
     </a>
     <a class="indexterm" name="idm46045104262256">
     </a>
     <p>
      Show the next value for a table's
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column, if it has one.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_blob-info">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_blob-info">
       <code class="option">
        --blob-info
       </code>
      </a>
      ,
      <code class="option">
       -b
      </code>
     </p>
     <a class="indexterm" name="idm46045104256912">
     </a>
     <a class="indexterm" name="idm46045104255424">
     </a>
     <p>
      Include information about subordinate
      <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.
     </p>
     <p>
      Use of this option also requires the use of the
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-partition-info">
       <code class="option">
        --extra-partition-info
       </code>
      </a>
      (
      <code class="option">
       -p
      </code>
      ) option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104246816">
     </a>
     <a class="indexterm" name="idm46045104245360">
     </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_desc_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104235504">
     </a>
     <a class="indexterm" name="idm46045104234016">
     </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_desc_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104214928">
     </a>
     <a class="indexterm" name="idm46045104213472">
     </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_desc_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104194288">
     </a>
     <a class="indexterm" name="idm46045104192800">
     </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-desc.html#option_ndb_desc_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_context">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_context">
       <code class="option">
        --context
       </code>
      </a>
      ,
      <code class="option">
       -x
      </code>
     </p>
     <a class="indexterm" name="idm46045104177072">
     </a>
     <a class="indexterm" name="idm46045104175584">
     </a>
     <p>
      Show additional contextual information for the table such as
            schema, database name, table name, and the table's
            internal ID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104171232">
     </a>
     <a class="indexterm" name="idm46045104169744">
     </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_desc_database">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_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="idm46045104159328">
     </a>
     <a class="indexterm" name="idm46045104157840">
     </a>
     <p>
      Specify the database in which the table should be found.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104153680">
     </a>
     <a class="indexterm" name="idm46045104152224">
     </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_desc_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104137984">
     </a>
     <a class="indexterm" name="idm46045104136496">
     </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_desc_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104122224">
     </a>
     <a class="indexterm" name="idm46045104120768">
     </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_desc_extra-node-info">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-node-info">
       <code class="option">
        --extra-node-info
       </code>
      </a>
      ,
      <code class="option">
       -n
      </code>
     </p>
     <a class="indexterm" name="idm46045104106176">
     </a>
     <a class="indexterm" name="idm46045104104688">
     </a>
     <p>
      Include information about the mappings between table
            partitions and the data nodes upon which they reside. This
            information can be useful for verifying distribution
            awareness mechanisms and supporting more efficient
            application access to the data stored in NDB Cluster.
     </p>
     <p>
      Use of this option also requires the use of the
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-partition-info">
       <code class="option">
        --extra-partition-info
       </code>
      </a>
      (
      <code class="option">
       -p
      </code>
      ) option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_extra-partition-info">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_extra-partition-info">
       <code class="option">
        --extra-partition-info
       </code>
      </a>
      ,
      <code class="option">
       -p
      </code>
     </p>
     <a class="indexterm" name="idm46045104098032">
     </a>
     <a class="indexterm" name="idm46045104096576">
     </a>
     <p>
      Print additional information about the table's
            partitions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104092400">
     </a>
     <a class="indexterm" name="idm46045104090912">
     </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_desc_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104081184">
     </a>
     <a class="indexterm" name="idm46045104079696">
     </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_desc_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104065424">
     </a>
     <a class="indexterm" name="idm46045104063936">
     </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_desc_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104054272">
     </a>
     <a class="indexterm" name="idm46045104052816">
     </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 connect 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_desc_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104033840">
     </a>
     <a class="indexterm" name="idm46045104032352">
     </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_desc_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045104011280">
     </a>
     <a class="indexterm" name="idm46045104009792">
     </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-desc.html#option_ndb_desc_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103994608">
     </a>
     <a class="indexterm" name="idm46045103993120">
     </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-desc.html#option_ndb_desc_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103977856">
     </a>
     <a class="indexterm" name="idm46045103976352">
     </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_desc_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103966000">
     </a>
     <a class="indexterm" name="idm46045103964544">
     </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_desc_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103940784">
     </a>
     <a class="indexterm" name="idm46045103939296">
     </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_desc_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103929472">
     </a>
     <a class="indexterm" name="idm46045103927984">
     </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_desc_retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_retries">
       <code class="option">
        --retries=
        <em class="replaceable">
         <code>
          #
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -r
      </code>
     </p>
     <a class="indexterm" name="idm46045103917712">
     </a>
     <a class="indexterm" name="idm46045103916224">
     </a>
     <p>
      Try to connect this many times before giving up. One connect
            attempt is made per second.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_table">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_table">
       <code class="option">
        --table=
        <em class="replaceable">
         <code>
          tbl_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -t
      </code>
     </p>
     <a class="indexterm" name="idm46045103911328">
     </a>
     <a class="indexterm" name="idm46045103909840">
     </a>
     <p>
      Specify the table in which to look for an index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_unqualified">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_unqualified">
       <code class="option">
        --unqualified
       </code>
      </a>
      ,
      <code class="option">
       -u
      </code>
     </p>
     <a class="indexterm" name="idm46045103905104">
     </a>
     <a class="indexterm" name="idm46045103903616">
     </a>
     <p>
      Use unqualified table names.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103899552">
     </a>
     <a class="indexterm" name="idm46045103898064">
     </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-desc.html#option_ndb_desc_help">
       <code class="option">
        --help
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_desc_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-desc.html#option_ndb_desc_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103887344">
     </a>
     <a class="indexterm" name="idm46045103885856">
     </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>
   Table indexes listed in the output are ordered by ID.
  </p>
 </div>
 <br/>
</div>
