<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-blobs">
      </a>
      25.6.17.4 The ndbinfo blobs Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045090491408">
  </a>
  <p>
   This table provides about blob values stored in
   <code class="literal">
    NDB
   </code>
   . The
   <code class="literal">
    blobs
   </code>
   table has
        the columns listed here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_id
      </code>
     </p>
     <p>
      Unique ID of the table containing the column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       database_name
      </code>
     </p>
     <p>
      Name of the database in which this table resides
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      Name of the table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       column_id
      </code>
     </p>
     <p>
      The column's unique ID within the table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       column_name
      </code>
     </p>
     <p>
      Name of the column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       inline_size
      </code>
     </p>
     <p>
      Inline size of the column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       part_size
      </code>
     </p>
     <p>
      Part size of the column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       stripe_size
      </code>
     </p>
     <p>
      Stripe size of the column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       blob_table_name
      </code>
     </p>
     <p>
      Name of the blob table containing this column's blob
            data, if any
     </p>
    </li>
   </ul>
  </div>
  <p>
   Rows exist in this table for those
   <code class="literal">
    NDB
   </code>
   table
        columns that store
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     BLOB
    </code>
   </a>
   ,
   <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
    <code class="literal">
     TEXT
    </code>
   </a>
   values taking up more than
        255 bytes and thus require the use of a blob table. Parts of
   <a class="link" href="json.html" title="13.5 The JSON Data Type">
    <code class="literal">
     JSON
    </code>
   </a>
   values exceeding 4000 bytes
        in size are also stored in this table. For more information
        about how NDB Cluster stores columns of such types, see
   <a class="xref" href="storage-requirements.html#data-types-storage-reqs-strings" title="String Type Storage Requirements">
    String Type Storage Requirements
   </a>
   .
  </p>
  <p>
   The part and inline sizes of
   <code class="literal">
    NDB
   </code>
   blob columns
        can be set using
   <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 containing
   <code class="literal">
    NDB
   </code>
   table column comments (see
   <a class="xref" href="create-table-ndb-comment-options.html#create-table-ndb-comment-column-options" title="NDB_COLUMN Options">
    NDB_COLUMN Options
   </a>
   ); this
        can also be done in NDB API applications (see
   <a class="ulink" href="/doc/ndbapi/en/ndb-column.html#ndb-column-setpartsize" target="_top">
    <code class="literal">
     Column::setPartSize()
    </code>
   </a>
   and
   <a class="ulink" href="/doc/ndbapi/en/ndb-column.html#ndb-column-setinlinesize" target="_top">
    <code class="literal">
     setInlineSize()
    </code>
   </a>
   ).
  </p>
 </div>
 <br/>
</div>
