<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-ndbinfo">
      </a>
      25.6.17 ndbinfo: The NDB Cluster Information Database
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-arbitrator-validity-detail.html">
       25.6.17.1 The ndbinfo arbitrator_validity_detail Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-arbitrator-validity-summary.html">
       25.6.17.2 The ndbinfo arbitrator_validity_summary Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-backup-id.html">
       25.6.17.3 The ndbinfo backup_id Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-blobs.html">
       25.6.17.4 The ndbinfo blobs Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-blocks.html">
       25.6.17.5 The ndbinfo blocks Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-certificates.html">
       25.6.17.6 The ndbinfo certificates Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cluster-locks.html">
       25.6.17.7 The ndbinfo cluster_locks Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cluster-operations.html">
       25.6.17.8 The ndbinfo cluster_operations Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cluster-transactions.html">
       25.6.17.9 The ndbinfo cluster_transactions Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-config-nodes.html">
       25.6.17.10 The ndbinfo config_nodes Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-config-params.html">
       25.6.17.11 The ndbinfo config_params Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-config-values.html">
       25.6.17.12 The ndbinfo config_values Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-counters.html">
       25.6.17.13 The ndbinfo counters Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpudata.html">
       25.6.17.14 The ndbinfo cpudata Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpudata-1sec.html">
       25.6.17.15 The ndbinfo cpudata_1sec Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpudata-20sec.html">
       25.6.17.16 The ndbinfo cpudata_20sec Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpudata-50ms.html">
       25.6.17.17 The ndbinfo cpudata_50ms Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpuinfo.html">
       25.6.17.18 The ndbinfo cpuinfo Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpustat.html">
       25.6.17.19 The ndbinfo cpustat Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpustat-50ms.html">
       25.6.17.20 The ndbinfo cpustat_50ms Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpustat-1sec.html">
       25.6.17.21 The ndbinfo cpustat_1sec Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-cpustat-20sec.html">
       25.6.17.22 The ndbinfo cpustat_20sec Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-dictionary-columns.html">
       25.6.17.23 The ndbinfo dictionary_columns Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-dictionary-tables.html">
       25.6.17.24 The ndbinfo dictionary_tables Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-dict-obj-info.html">
       25.6.17.25 The ndbinfo dict_obj_info Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-dict-obj-tree.html">
       25.6.17.26 The ndbinfo dict_obj_tree Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-dict-obj-types.html">
       25.6.17.27 The ndbinfo dict_obj_types Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-disk-write-speed-base.html">
       25.6.17.28 The ndbinfo disk_write_speed_base Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-disk-write-speed-aggregate.html">
       25.6.17.29 The ndbinfo disk_write_speed_aggregate Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-disk-write-speed-aggregate-node.html">
       25.6.17.30 The ndbinfo disk_write_speed_aggregate_node Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-diskpagebuffer.html">
       25.6.17.31 The ndbinfo diskpagebuffer Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-diskstat.html">
       25.6.17.32 The ndbinfo diskstat Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-diskstats-1sec.html">
       25.6.17.33 The ndbinfo diskstats_1sec Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-error-messages.html">
       25.6.17.34 The ndbinfo error_messages Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-events.html">
       25.6.17.35 The ndbinfo events Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-files.html">
       25.6.17.36 The ndbinfo files Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-foreign-keys.html">
       25.6.17.37 The ndbinfo foreign_keys Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-hash-maps.html">
       25.6.17.38 The ndbinfo hash_maps Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-hwinfo.html">
       25.6.17.39 The ndbinfo hwinfo Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-index-columns.html">
       25.6.17.40 The ndbinfo index_columns Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-index-stats.html">
       25.6.17.41 The ndbinfo index_stats Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-locks-per-fragment.html">
       25.6.17.42 The ndbinfo locks_per_fragment Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-logbuffers.html">
       25.6.17.43 The ndbinfo logbuffers Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-logspaces.html">
       25.6.17.44 The ndbinfo logspaces Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-membership.html">
       25.6.17.45 The ndbinfo membership Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-memoryusage.html">
       25.6.17.46 The ndbinfo memoryusage Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-memory-per-fragment.html">
       25.6.17.47 The ndbinfo memory_per_fragment Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-nodes.html">
       25.6.17.48 The ndbinfo nodes Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-operations-per-fragment.html">
       25.6.17.49 The ndbinfo operations_per_fragment Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-pgman-time-track-stats.html">
       25.6.17.50 The ndbinfo pgman_time_track_stats Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-processes.html">
       25.6.17.51 The ndbinfo processes Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-resources.html">
       25.6.17.52 The ndbinfo resources Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-restart-info.html">
       25.6.17.53 The ndbinfo restart_info Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-server-locks.html">
       25.6.17.54 The ndbinfo server_locks Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-server-operations.html">
       25.6.17.55 The ndbinfo server_operations Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-server-transactions.html">
       25.6.17.56 The ndbinfo server_transactions Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-table-distribution-status.html">
       25.6.17.57 The ndbinfo table_distribution_status Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-table-fragments.html">
       25.6.17.58 The ndbinfo table_fragments Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-table-info.html">
       25.6.17.59 The ndbinfo table_info Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-table-replicas.html">
       25.6.17.60 The ndbinfo table_replicas Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-tc-time-track-stats.html">
       25.6.17.61 The ndbinfo tc_time_track_stats Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-threadblocks.html">
       25.6.17.62 The ndbinfo threadblocks Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-threads.html">
       25.6.17.63 The ndbinfo threads Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-threadstat.html">
       25.6.17.64 The ndbinfo threadstat Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-transporter-details.html">
       25.6.17.65 The ndbinfo transporter_details Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-ndbinfo-transporters.html">
       25.6.17.66 The ndbinfo transporters Table
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045090673808">
  </a>
  <p>
   <code class="literal">
    ndbinfo
   </code>
   is a database containing information
      specific to NDB Cluster.
  </p>
  <p>
   This database contains a number of tables, each providing a
      different sort of data about NDB Cluster node status, resource
      usage, and operations. You can find more detailed information
      about each of these tables in the next several sections.
  </p>
  <a class="indexterm" name="idm46045090670192">
  </a>
  <p>
   <code class="literal">
    ndbinfo
   </code>
   is included with NDB Cluster support in
      the MySQL Server; no special compilation or configuration steps
      are required; the tables are created by the MySQL Server when it
      connects to the cluster. You can verify that
   <code class="literal">
    ndbinfo
   </code>
   support is active in a given MySQL
      Server instance using
   <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    <code class="literal">
     SHOW PLUGINS
    </code>
   </a>
   ;
      if
   <code class="literal">
    ndbinfo
   </code>
   support is enabled, you should see a
      row containing
   <code class="literal">
    ndbinfo
   </code>
   in the
   <code class="literal">
    Name
   </code>
   column and
   <code class="literal">
    ACTIVE
   </code>
   in
      the
   <code class="literal">
    Status
   </code>
   column, as shown here (emphasized
      text):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa62533786"><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">PLUGINS</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> Name                             <span class="token punctuation">|</span> Status <span class="token punctuation">|</span> Type               <span class="token punctuation">|</span> Library <span class="token punctuation">|</span> License <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>
<span class="token output"><span class="token punctuation">|</span> binlog                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sha256_password                  <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> caching_sha2_password            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sha2_cache_cleaner               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUDIT              <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> daemon_keyring_proxy_plugin      <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> DAEMON             <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> CSV                              <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MEMORY                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> InnoDB                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TRX                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMP                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMP_RESET                 <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMPMEM                    <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMPMEM_RESET              <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMP_PER_INDEX             <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMP_PER_INDEX_RESET       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_BUFFER_PAGE               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_BUFFER_PAGE_LRU           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_BUFFER_POOL_STATS         <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TEMP_TABLE_INFO           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_METRICS                   <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_DEFAULT_STOPWORD       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_DELETED                <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_BEING_DELETED          <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_CONFIG                 <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_INDEX_CACHE            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_FT_INDEX_TABLE            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TABLES                    <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TABLESTATS                <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_INDEXES                   <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TABLESPACES               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_COLUMNS                   <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_VIRTUAL                   <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CACHED_INDEXES            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_SESSION_TEMP_TABLESPACES  <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MyISAM                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MRG_MYISAM                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PERFORMANCE_SCHEMA               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TempTable                        <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ARCHIVE                          <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> BLACKHOLE                        <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbcluster                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> ndbinfo                          <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_transid_mysql_connection_map <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ngram                            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> FTPARSER           <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysqlx_cache_cleaner             <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUDIT              <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysqlx                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> DAEMON             <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql_native_password            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <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>
<span class="token output">47 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   You can also do this by checking the output of
   <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
    <code class="literal">
     SHOW ENGINES
    </code>
   </a>
   for a line including
   <code class="literal">
    ndbinfo
   </code>
   in the
   <code class="literal">
    Engine
   </code>
   column
      and
   <code class="literal">
    YES
   </code>
   in the
   <code class="literal">
    Support
   </code>
   column, as shown here (emphasized text):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa31700780"><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">ENGINES</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> 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>
      Engine<span class="token punctuation">:</span> MEMORY
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Hash based, stored in memory, useful for temporary tables
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. 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>
      Engine<span class="token punctuation">:</span> InnoDB
     Support<span class="token punctuation">:</span> DEFAULT
     Comment<span class="token punctuation">:</span> Supports transactions, row-level locking, and foreign keys
Transactions<span class="token punctuation">:</span> YES
          XA<span class="token punctuation">:</span> YES
  Savepoints<span class="token punctuation">:</span> YES
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 3. 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>
      Engine<span class="token punctuation">:</span> PERFORMANCE_SCHEMA
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Performance Schema
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 4. 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>
      Engine<span class="token punctuation">:</span> MyISAM
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> MyISAM storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 5. 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>
      <em>Engine<span class="token punctuation">:</span> ndbinfo</em>
     <em>Support<span class="token punctuation">:</span> YES</em>
     Comment<span class="token punctuation">:</span> MySQL Cluster system information storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 6. 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>
      Engine<span class="token punctuation">:</span> MRG_MYISAM
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Collection of identical MyISAM tables
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 7. 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>
      Engine<span class="token punctuation">:</span> BLACKHOLE
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> /dev/null storage engine (anything you write to it disappears)
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 8. 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>
      Engine<span class="token punctuation">:</span> CSV
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> CSV storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 9. 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>
      Engine<span class="token punctuation">:</span> ARCHIVE
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Archive storage engine
Transactions<span class="token punctuation">:</span> NO
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 10. 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>
      Engine<span class="token punctuation">:</span> ndbcluster
     Support<span class="token punctuation">:</span> YES
     Comment<span class="token punctuation">:</span> Clustered, fault-tolerant tables
Transactions<span class="token punctuation">:</span> YES
          XA<span class="token punctuation">:</span> NO
  Savepoints<span class="token punctuation">:</span> NO
</span><span class="token output">10 rows in set (0.01 sec)</span></code></pre>
  </div>
  <p>
   If
   <code class="literal">
    ndbinfo
   </code>
   support is enabled, then you can
      access
   <code class="literal">
    ndbinfo
   </code>
   using SQL statements in
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   or another MySQL client. For example, you
      can see
   <code class="literal">
    ndbinfo
   </code>
   listed in the output of
   <a class="link" href="show-databases.html" title="15.7.7.15 SHOW DATABASES Statement">
    <code class="literal">
     SHOW DATABASES
    </code>
   </a>
   , as shown here
      (emphasized text):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa33720633"><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">DATABASES</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> Database           <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>
<span class="token output"><span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> ndbinfo            <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sys                <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>
<span class="token output">5 rows in set (0.04 sec)</span></code></pre>
  </div>
  <p>
   If the
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   process was not started with the
   <a class="link" href="mysql-cluster-options-variables.html#option_mysqld_ndbcluster">
    <code class="option">
     --ndbcluster
    </code>
   </a>
   option,
   <code class="literal">
    ndbinfo
   </code>
   is not available and is not displayed
      by
   <a class="link" href="show-databases.html" title="15.7.7.15 SHOW DATABASES Statement">
    <code class="literal">
     SHOW DATABASES
    </code>
   </a>
   . If
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   was formerly connected to an NDB Cluster
      but the cluster becomes unavailable (due to events such as cluster
      shutdown, loss of network connectivity, and so forth),
   <code class="literal">
    ndbinfo
   </code>
   and its tables remain visible, but an
      attempt to access any tables (other than
   <code class="literal">
    blocks
   </code>
   or
   <code class="literal">
    config_params
   </code>
   ) fails with
   <span class="errortext">
    Got
      error 157 'Connection to NDB failed' from NDBINFO
   </span>
   .
  </p>
  <p>
   With the exception of the
   <a class="link" href="mysql-cluster-ndbinfo-blocks.html" title="25.6.17.5 The ndbinfo blocks Table">
    <code class="literal">
     blocks
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-ndbinfo-config-params.html" title="25.6.17.11 The ndbinfo config_params Table">
    <code class="literal">
     config_params
    </code>
   </a>
   tables, what
      we refer to as
   <code class="literal">
    ndbinfo
   </code>
   <span class="quote">
    “
    <span class="quote">
     tables
    </span>
    ”
   </span>
   are actually views generated from internal
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   tables not normally visible to
      the MySQL Server. You can make these tables visible by setting the
   <a class="link" href="mysql-cluster-options-variables.html#sysvar_ndbinfo_show_hidden">
    <code class="literal">
     ndbinfo_show_hidden
    </code>
   </a>
   system
      variable to
   <code class="literal">
    ON
   </code>
   (or
   <code class="literal">
    1
   </code>
   ), but
      this is normally not necessary.
  </p>
  <p>
   All
   <code class="literal">
    ndbinfo
   </code>
   tables are read-only, and are
      generated on demand when queried. Because many of them are
      generated in parallel by the data nodes while other are specific
      to a given SQL node, they are not guaranteed to provide a
      consistent snapshot.
  </p>
  <p>
   In addition, pushing down of joins is not supported on
   <code class="literal">
    ndbinfo
   </code>
   tables; so joining large
   <code class="literal">
    ndbinfo
   </code>
   tables can require transfer of a large
      amount of data to the requesting API node, even when the query
      makes use of a
   <code class="literal">
    WHERE
   </code>
   clause.
  </p>
  <a class="indexterm" name="idm46045090612832">
  </a>
  <a class="indexterm" name="idm46045090611344">
  </a>
  <p>
   <code class="literal">
    ndbinfo
   </code>
   tables are not included in the query
      cache. (Bug #59831)
  </p>
  <p>
   You can select the
   <code class="literal">
    ndbinfo
   </code>
   database with a
   <a class="link" href="use.html" title="15.8.4 USE Statement">
    <code class="literal">
     USE
    </code>
   </a>
   statement, and then issue a
   <a class="link" href="show-tables.html" title="15.7.7.39 SHOW TABLES Statement">
    <code class="literal">
     SHOW TABLES
    </code>
   </a>
   statement to obtain a
      list of tables, just as for any other database, like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa792111"><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">USE</span> ndbinfo<span class="token punctuation">;</span>
<span class="token keyword">Database</span> <span class="token keyword">changed</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">TABLES</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> Tables_in_ndbinfo               <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>
<span class="token output"><span class="token punctuation">|</span> arbitrator_validity_detail      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> arbitrator_validity_summary     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> backup_id                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> blobs                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> blocks                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> certificates                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cluster_locks                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cluster_operations              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cluster_transactions            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> config_nodes                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> config_params                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> config_values                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> counters                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpudata                         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpudata_1sec                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpudata_20sec                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpudata_50ms                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpuinfo                         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpustat                         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpustat_1sec                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpustat_20sec                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpustat_50ms                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dict_obj_info                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dict_obj_tree                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dict_obj_types                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dictionary_columns              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dictionary_tables               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> disk_write_speed_aggregate      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> disk_write_speed_aggregate_node <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> disk_write_speed_base           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> diskpagebuffer                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> diskstat                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> diskstats_1sec                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> error_messages                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> files                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> foreign_keys                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> hash_maps                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> hwinfo                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_columns                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_stats                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> locks_per_fragment              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> logbuffers                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> logspaces                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> membership                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> memory_per_fragment             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> memoryusage                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> nodes                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> operations_per_fragment         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> pgman_time_track_stats          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> processes                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> resources                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> restart_info                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> server_locks                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> server_operations               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> server_transactions             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> table_distribution_status       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> table_fragments                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> table_info                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> table_replicas                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> tc_time_track_stats             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> threadblocks                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> threads                         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> threadstat                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transporter_details             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> transporters                    <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>
<span class="token output">66 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   All
   <code class="literal">
    ndbinfo
   </code>
   tables use the
   <code class="literal">
    NDB
   </code>
   storage engine; however, an
   <code class="literal">
    ndbinfo
   </code>
   entry still appears in the output of
   <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
    <code class="literal">
     SHOW ENGINES
    </code>
   </a>
   and
   <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    <code class="literal">
     SHOW PLUGINS
    </code>
   </a>
   as described
      previously.
  </p>
  <a class="indexterm" name="idm46045090594336">
  </a>
  <p>
   You can execute
   <a class="link" href="select.html" title="15.2.13 SELECT Statement">
    <code class="literal">
     SELECT
    </code>
   </a>
   statements
      against these tables, just as you would normally expect:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa35629905"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> memoryusage<span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> memory_type         <span class="token punctuation">|</span> used   <span class="token punctuation">|</span> used_pages <span class="token punctuation">|</span> total      <span class="token punctuation">|</span> total_pages <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>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span> Data memory         <span class="token punctuation">|</span> 425984 <span class="token punctuation">|</span>         13 <span class="token punctuation">|</span> 2147483648 <span class="token punctuation">|</span>       65536 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span> Long message buffer <span class="token punctuation">|</span> 393216 <span class="token punctuation">|</span>       1536 <span class="token punctuation">|</span>   67108864 <span class="token punctuation">|</span>      262144 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span> Data memory         <span class="token punctuation">|</span> 425984 <span class="token punctuation">|</span>         13 <span class="token punctuation">|</span> 2147483648 <span class="token punctuation">|</span>       65536 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span> Long message buffer <span class="token punctuation">|</span> 393216 <span class="token punctuation">|</span>       1536 <span class="token punctuation">|</span>   67108864 <span class="token punctuation">|</span>      262144 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       7 <span class="token punctuation">|</span> Data memory         <span class="token punctuation">|</span> 425984 <span class="token punctuation">|</span>         13 <span class="token punctuation">|</span> 2147483648 <span class="token punctuation">|</span>       65536 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       7 <span class="token punctuation">|</span> Long message buffer <span class="token punctuation">|</span> 393216 <span class="token punctuation">|</span>       1536 <span class="token punctuation">|</span>   67108864 <span class="token punctuation">|</span>      262144 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> Data memory         <span class="token punctuation">|</span> 425984 <span class="token punctuation">|</span>         13 <span class="token punctuation">|</span> 2147483648 <span class="token punctuation">|</span>       65536 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       8 <span class="token punctuation">|</span> Long message buffer <span class="token punctuation">|</span> 393216 <span class="token punctuation">|</span>       1536 <span class="token punctuation">|</span>   67108864 <span class="token punctuation">|</span>      262144 <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>
<span class="token output">8 rows in set (0.09 sec)</span></code></pre>
  </div>
  <p>
   More complex queries, such as the two following
   <a class="link" href="select.html" title="15.2.13 SELECT Statement">
    <code class="literal">
     SELECT
    </code>
   </a>
   statements using the
   <a class="link" href="mysql-cluster-ndbinfo-memoryusage.html" title="25.6.17.46 The ndbinfo memoryusage Table">
    <code class="literal">
     memoryusage
    </code>
   </a>
   table, are possible:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa18356496"><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">SELECT</span> <span class="token function">SUM</span><span class="token punctuation">(</span>used<span class="token punctuation">)</span> <span class="token keyword">as</span> <span class="token string">'Data Memory Used, All Nodes'</span>
     <span class="token operator">&gt;</span>     <span class="token keyword">FROM</span> memoryusage
     <span class="token operator">&gt;</span>     <span class="token keyword">WHERE</span> memory_type <span class="token operator">=</span> <span class="token string">'Data memory'</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> Data Memory Used, All Nodes <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>
<span class="token output"><span class="token punctuation">|</span>                        6460 <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>
<span class="token output">1 row in set (0.09 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token function">SUM</span><span class="token punctuation">(</span>used<span class="token punctuation">)</span> <span class="token keyword">as</span> <span class="token string">'Long Message Buffer, All Nodes'</span>
     <span class="token operator">&gt;</span>     <span class="token keyword">FROM</span> memoryusage
     <span class="token operator">&gt;</span>     <span class="token keyword">WHERE</span> memory_type <span class="token operator">=</span> <span class="token string">'Long message buffer'</span><span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> Long Message Buffer Used, All Nodes <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>
<span class="token output"><span class="token punctuation">|</span>                             1179648 <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>
<span class="token output">1 row in set (0.08 sec)</span></code></pre>
  </div>
  <p>
   <code class="literal">
    ndbinfo
   </code>
   table and column names are
      case-sensitive (as is the name of the
   <code class="literal">
    ndbinfo
   </code>
   database itself). These identifiers are in lowercase. Trying to
      use the wrong lettercase results in an error, as shown in this
      example:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa93346723"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> nodes<span class="token punctuation">;</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>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> uptime <span class="token punctuation">|</span> status  <span class="token punctuation">|</span> start_phase <span class="token punctuation">|</span> config_generation <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>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>  17707 <span class="token punctuation">|</span> STARTED <span class="token punctuation">|</span>           0 <span class="token punctuation">|</span>                 1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>  17706 <span class="token punctuation">|</span> STARTED <span class="token punctuation">|</span>           0 <span class="token punctuation">|</span>                 1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       7 <span class="token punctuation">|</span>  17705 <span class="token punctuation">|</span> STARTED <span class="token punctuation">|</span>           0 <span class="token punctuation">|</span>                 1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       8 <span class="token punctuation">|</span>  17704 <span class="token punctuation">|</span> STARTED <span class="token punctuation">|</span>           0 <span class="token punctuation">|</span>                 1 <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>
<span class="token output">4 rows in set (0.06 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> Nodes<span class="token punctuation">;</span>
<span class="token output">ERROR 1146 (42S02)<span class="token punctuation">:</span> Table 'ndbinfo.Nodes' doesn't exist</span></code></pre>
  </div>
  <p>
   <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
    <span class="command">
     <strong>
      mysqldump
     </strong>
    </span>
   </a>
   ignores the
   <code class="literal">
    ndbinfo
   </code>
   database entirely, and excludes it from
      any output. This is true even when using the
   <a class="link" href="mysqldump.html#option_mysqldump_databases">
    <code class="option">
     --databases
    </code>
   </a>
   or
   <a class="link" href="mysqldump.html#option_mysqldump_all-databases">
    <code class="option">
     --all-databases
    </code>
   </a>
   option.
  </p>
  <p>
   NDB Cluster also maintains tables in the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   information database,
      including the
   <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 which
      contains information about files used for NDB Cluster Disk Data
      storage, and the
   <a class="link" href="information-schema-ndb-transid-mysql-connection-map-table.html" title="28.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table">
    <code class="literal">
     ndb_transid_mysql_connection_map
    </code>
   </a>
   table, which shows the relationships between transactions,
      transaction coordinators, and NDB Cluster API nodes. For more
      information, see the descriptions of the tables or
   <a class="xref" href="mysql-cluster-information-schema-tables.html" title="25.6.18 INFORMATION_SCHEMA Tables for NDB Cluster">
    Section 25.6.18, “INFORMATION_SCHEMA Tables for NDB Cluster”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
