<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-sql-statements">
      </a>
      25.6.20 Quick Reference: NDB Cluster SQL Statements
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045087256368">
  </a>
  <a class="indexterm" name="idm46045087254912">
  </a>
  <p>
   This section discusses several SQL statements that can prove
      useful in managing and monitoring a MySQL server that is connected
      to an NDB Cluster, and in some cases provide information about the
      cluster itself.
  </p>
  <div class="itemizedlist">
   <a class="indexterm" name="idm46045087252928">
   </a>
   <a class="indexterm" name="idm46045087251440">
   </a>
   <a class="indexterm" name="idm46045087250368">
   </a>
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
       <code class="literal">
        SHOW ENGINE NDB
          STATUS
       </code>
      </a>
      ,
      <a class="link" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
       <code class="literal">
        SHOW ENGINE
          NDBCLUSTER STATUS
       </code>
      </a>
     </p>
     <p>
      The output of this statement contains information about the
          server's connection to the cluster, creation and usage of
          NDB Cluster objects, and binary logging for NDB Cluster
          replication.
     </p>
     <p>
      See
      <a class="xref" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
       Section 15.7.7.16, “SHOW ENGINE Statement”
      </a>
      , for a usage example and
          more detailed information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087243728">
      </a>
      <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
       <code class="literal">
        SHOW ENGINES
       </code>
      </a>
     </p>
     <p>
      This statement can be used to determine whether or not
          clustering support is enabled in the MySQL server, and if so,
          whether it is active.
     </p>
     <p>
      See
      <a class="xref" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
       Section 15.7.7.17, “SHOW ENGINES Statement”
      </a>
      , for more detailed
          information.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       This statement does not support a
       <a class="link" href="string-comparison-functions.html#operator_like">
        <code class="literal">
         LIKE
        </code>
       </a>
       clause. However, you can
            use
       <a class="link" href="string-comparison-functions.html#operator_like">
        <code class="literal">
         LIKE
        </code>
       </a>
       to filter queries
            against the Information Schema
       <a class="link" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
        <code class="literal">
         ENGINES
        </code>
       </a>
       table, as discussed in
            the next item.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087233840">
      </a>
      <code class="literal">
       SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE
          ENGINE LIKE 'NDB%']
      </code>
     </p>
     <p>
      This is the equivalent of
      <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
       <code class="literal">
        SHOW
          ENGINES
       </code>
      </a>
      , but uses the
      <a class="link" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
       <code class="literal">
        ENGINES
       </code>
      </a>
      table of the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      database. Unlike the
          case with the
      <a class="link" href="show-engines.html" title="15.7.7.17 SHOW ENGINES Statement">
       <code class="literal">
        SHOW ENGINES
       </code>
      </a>
      statement, it is possible to filter the results using a
      <a class="link" href="string-comparison-functions.html#operator_like">
       <code class="literal">
        LIKE
       </code>
      </a>
      clause, and to select
          specific columns to obtain information that may be of use in
          scripts. For example, the following query shows whether the
          server was built with
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      support
          and, if so, whether it is enabled:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa11259561"><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 keyword">ENGINE</span><span class="token punctuation">,</span> SUPPORT <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">ENGINES</span>
<span class="token prompt">    -&gt;</span>   <span class="token keyword">WHERE</span> <span class="token keyword">ENGINE</span> <span class="token operator">LIKE</span> <span class="token string">'NDB%'</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>
<span class="token output"><span class="token punctuation">|</span> ENGINE     <span class="token punctuation">|</span> SUPPORT <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>
<span class="token output"><span class="token punctuation">|</span> ndbcluster <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo    <span class="token punctuation">|</span> YES     <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></code></pre>
     </div>
     <p>
      If
      <code class="literal">
       NDB
      </code>
      support is not enabled, the
          preceding query returns an empty set. See
      <a class="xref" href="information-schema-engines-table.html" title="28.3.13 The INFORMATION_SCHEMA ENGINES Table">
       Section 28.3.13, “The INFORMATION_SCHEMA ENGINES Table”
      </a>
      , for more
          information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087218688">
      </a>
      <code class="literal">
       SHOW VARIABLES LIKE 'NDB%'
      </code>
     </p>
     <p>
      This statement provides a list of most server system variables
          relating to the
      <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       <code class="literal">
        NDB
       </code>
      </a>
      storage
          engine, and their values, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa71278128"><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">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'NDB%'</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>
<span class="token output"><span class="token punctuation">|</span> Variable_name                              <span class="token punctuation">|</span> Value                            <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>
<span class="token output"><span class="token punctuation">|</span> ndb_allow_copying_alter_table              <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_applier_allow_skip_epoch               <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_applier_conflict_role                  <span class="token punctuation">|</span> NONE                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_autoincrement_prefetch_sz              <span class="token punctuation">|</span> 512                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_batch_size                             <span class="token punctuation">|</span> 32768                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_blob_read_batch_bytes                  <span class="token punctuation">|</span> 65536                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_blob_write_batch_bytes                 <span class="token punctuation">|</span> 65536                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_clear_apply_status                     <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_cluster_connection_pool                <span class="token punctuation">|</span> 1                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_cluster_connection_pool_nodeids        <span class="token punctuation">|</span>                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_connectstring                          <span class="token punctuation">|</span> 127.0.0.1                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_data_node_neighbour                    <span class="token punctuation">|</span> 0                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_default_column_format                  <span class="token punctuation">|</span> FIXED                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_deferred_constraints                   <span class="token punctuation">|</span> 0                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_distribution                           <span class="token punctuation">|</span> KEYHASH                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_eventbuffer_free_percent               <span class="token punctuation">|</span> 20                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_eventbuffer_max_alloc                  <span class="token punctuation">|</span> 0                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_extra_logging                          <span class="token punctuation">|</span> 1                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_force_send                             <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_fully_replicated                       <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_index_stat_enable                      <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token operator">|</span> ndb_index_stat_option                      <span class="token operator">|</span> loop_enable<span class="token operator">=</span>1000ms<span class="token punctuation">,</span>
loop_idle<span class="token operator">=</span>1000ms<span class="token punctuation">,</span>loop_busy<span class="token operator">=</span>100ms<span class="token punctuation">,</span>update_batch<span class="token operator">=</span><span class="token number">1</span><span class="token punctuation">,</span>read_batch<span class="token operator">=</span><span class="token number">4</span><span class="token punctuation">,</span>idle_batch<span class="token operator">=</span><span class="token number">32</span><span class="token punctuation">,</span>
check_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>check_delay<span class="token operator">=</span>10m<span class="token punctuation">,</span>delete_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>clean_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>error_batch<span class="token operator">=</span><span class="token number">4</span><span class="token punctuation">,</span>
error_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>evict_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>evict_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>cache_limit<span class="token operator">=</span>32M<span class="token punctuation">,</span>cache_lowpct<span class="token operator">=</span><span class="token number">90</span><span class="token punctuation">,</span>
zero_total<span class="token operator">=</span><span class="token number">0</span>                                                                    <span class="token operator">|</span>
<span class="token output"><span class="token punctuation">|</span> ndb_join_pushdown                          <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_apply_status                       <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_bin                                <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_binlog_index                       <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_empty_epochs                       <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_empty_update                       <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_exclusive_reads                    <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_fail_terminate                     <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_orig                               <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_transaction_compression            <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_transaction_compression_level_zstd <span class="token punctuation">|</span> 3                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_transaction_dependency             <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_transaction_id                     <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_update_as_write                    <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_update_minimal                     <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_updated_only                       <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_check                         <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_check_interval                <span class="token punctuation">|</span> 60                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_sync                          <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_mgm_tls                                <span class="token punctuation">|</span> relaxed                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_mgmd_host                              <span class="token punctuation">|</span> 127.0.0.1                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_nodeid                                 <span class="token punctuation">|</span> 0                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_optimization_delay                     <span class="token punctuation">|</span> 10                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_optimized_node_selection               <span class="token punctuation">|</span> 3                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_read_backup                            <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_recv_thread_activation_threshold       <span class="token punctuation">|</span> 8                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_recv_thread_cpu_mask                   <span class="token punctuation">|</span>                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_replica_batch_size                     <span class="token punctuation">|</span> 2097152                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_replica_blob_write_batch_bytes         <span class="token punctuation">|</span> 2097152                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_report_thresh_binlog_epoch_slip        <span class="token punctuation">|</span> 10                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_report_thresh_binlog_mem_usage         <span class="token punctuation">|</span> 10                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_row_checksum                           <span class="token punctuation">|</span> 1                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_lock_wait_timeout          <span class="token punctuation">|</span> 30                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_timeout                    <span class="token punctuation">|</span> 120                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_upgrade_allowed            <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_show_foreign_key_mock_tables           <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_slave_conflict_role                    <span class="token punctuation">|</span> NONE                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_table_no_logging                       <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_table_temporary                        <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_tls_search_path                        <span class="token punctuation">|</span> $HOME/ndb<span class="token punctuation">-</span>tls                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_copying_alter_table                <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_exact_count                        <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_transactions                       <span class="token punctuation">|</span> ON                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_version                                <span class="token punctuation">|</span> 524544                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_version_string                         <span class="token punctuation">|</span> ndb<span class="token punctuation">-</span>8.4.0                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_wait_connected                         <span class="token punctuation">|</span> 120                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_wait_setup                             <span class="token punctuation">|</span> 120                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_database                           <span class="token punctuation">|</span> ndbinfo                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_max_bytes                          <span class="token punctuation">|</span> 0                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_max_rows                           <span class="token punctuation">|</span> 10                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_offline                            <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_show_hidden                        <span class="token punctuation">|</span> OFF                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_table_prefix                       <span class="token punctuation">|</span> ndb$                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_version                            <span class="token punctuation">|</span> 524544                           <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>
<span class="token output">74 rows in set (0.01 sec)</span></code></pre>
     </div>
     <p>
      See
      <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
       Section 7.1.8, “Server System Variables”
      </a>
      , for more
          information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087196752">
      </a>
      <code class="literal">
       SELECT * FROM performance_schema.global_variables
          WHERE VARIABLE_NAME LIKE 'NDB%'
      </code>
     </p>
     <p>
      This statement is the equivalent of the
      <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
       <code class="literal">
        SHOW VARIABLES
       </code>
      </a>
      statement
          described in the previous item, and provides almost identical
          output, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa75387936"><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> performance_schema<span class="token punctuation">.</span>global_variables
<span class="token prompt">    -&gt;</span>   <span class="token keyword">WHERE</span> VARIABLE_NAME <span class="token operator">LIKE</span> <span class="token string">'NDB%'</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>
<span class="token output"><span class="token punctuation">|</span> VARIABLE_NAME                        <span class="token punctuation">|</span> VARIABLE_VALUE                        <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>
<span class="token output"><span class="token punctuation">|</span> ndb_allow_copying_alter_table        <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_autoincrement_prefetch_sz        <span class="token punctuation">|</span> 512                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_batch_size                       <span class="token punctuation">|</span> 32768                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_blob_read_batch_bytes            <span class="token punctuation">|</span> 65536                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_blob_write_batch_bytes           <span class="token punctuation">|</span> 65536                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_clear_apply_status               <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_cluster_connection_pool          <span class="token punctuation">|</span> 1                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_cluster_connection_pool_nodeids  <span class="token punctuation">|</span>                                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_connectstring                    <span class="token punctuation">|</span> 127.0.0.1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_data_node_neighbour              <span class="token punctuation">|</span> 0                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_default_column_format            <span class="token punctuation">|</span> FIXED                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_deferred_constraints             <span class="token punctuation">|</span> 0                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_distribution                     <span class="token punctuation">|</span> KEYHASH                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_eventbuffer_free_percent         <span class="token punctuation">|</span> 20                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_eventbuffer_max_alloc            <span class="token punctuation">|</span> 0                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_extra_logging                    <span class="token punctuation">|</span> 1                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_force_send                       <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_fully_replicated                 <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_index_stat_enable                <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token operator">|</span> ndb_index_stat_option                <span class="token operator">|</span> loop_enable<span class="token operator">=</span>1000ms<span class="token punctuation">,</span>loop_idle<span class="token operator">=</span>1000ms<span class="token punctuation">,</span>
loop_busy<span class="token operator">=</span>100ms<span class="token punctuation">,</span>update_batch<span class="token operator">=</span><span class="token number">1</span><span class="token punctuation">,</span>read_batch<span class="token operator">=</span><span class="token number">4</span><span class="token punctuation">,</span>idle_batch<span class="token operator">=</span><span class="token number">32</span><span class="token punctuation">,</span>check_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>
check_delay<span class="token operator">=</span>10m<span class="token punctuation">,</span>delete_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>clean_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>error_batch<span class="token operator">=</span><span class="token number">4</span><span class="token punctuation">,</span>error_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>
evict_batch<span class="token operator">=</span><span class="token number">8</span><span class="token punctuation">,</span>evict_delay<span class="token operator">=</span>1m<span class="token punctuation">,</span>cache_limit<span class="token operator">=</span>32M<span class="token punctuation">,</span>cache_lowpct<span class="token operator">=</span><span class="token number">90</span><span class="token punctuation">,</span>zero_total<span class="token operator">=</span><span class="token number">0</span>      <span class="token operator">|</span>
<span class="token output"><span class="token punctuation">|</span> ndb_join_pushdown                    <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_apply_status                 <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_bin                          <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_binlog_index                 <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_empty_epochs                 <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_empty_update                 <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_exclusive_reads              <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_orig                         <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_transaction_id               <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_update_as_write              <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_update_minimal               <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_log_updated_only                 <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_check                   <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_check_interval          <span class="token punctuation">|</span> 60                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_metadata_sync                    <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_mgmd_host                        <span class="token punctuation">|</span> 127.0.0.1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_nodeid                           <span class="token punctuation">|</span> 0                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_optimization_delay               <span class="token punctuation">|</span> 10                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_optimized_node_selection         <span class="token punctuation">|</span> 3                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_read_backup                      <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_recv_thread_activation_threshold <span class="token punctuation">|</span> 8                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_recv_thread_cpu_mask             <span class="token punctuation">|</span>                                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_report_thresh_binlog_epoch_slip  <span class="token punctuation">|</span> 10                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_report_thresh_binlog_mem_usage   <span class="token punctuation">|</span> 10                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_row_checksum                     <span class="token punctuation">|</span> 1                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_lock_wait_timeout    <span class="token punctuation">|</span> 30                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_timeout              <span class="token punctuation">|</span> 120                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_schema_dist_upgrade_allowed      <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_show_foreign_key_mock_tables     <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_slave_conflict_role              <span class="token punctuation">|</span> NONE                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_table_no_logging                 <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_table_temporary                  <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_copying_alter_table          <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_exact_count                  <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_use_transactions                 <span class="token punctuation">|</span> ON                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_version                          <span class="token punctuation">|</span> 524308                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_version_string                   <span class="token punctuation">|</span> ndb<span class="token punctuation">-</span>8.4.0                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_wait_connected                   <span class="token punctuation">|</span> 30                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_wait_setup                       <span class="token punctuation">|</span> 30                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_database                     <span class="token punctuation">|</span> ndbinfo                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_max_bytes                    <span class="token punctuation">|</span> 0                                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_max_rows                     <span class="token punctuation">|</span> 10                                    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_offline                      <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_show_hidden                  <span class="token punctuation">|</span> OFF                                   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_table_prefix                 <span class="token punctuation">|</span> ndb$                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_version                      <span class="token punctuation">|</span> 524308                                <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></code></pre>
     </div>
     <p>
      Unlike the case with the
      <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
       <code class="literal">
        SHOW
          VARIABLES
       </code>
      </a>
      statement, it is possible to select
          individual columns. For example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa8537262"><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> VARIABLE_VALUE 
<span class="token prompt">    -&gt;</span>   <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>global_variables
<span class="token prompt">    -&gt;</span>   <span class="token keyword">WHERE</span> VARIABLE_NAME <span class="token operator">=</span> <span class="token string">'ndb_force_send'</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>
<span class="token output"><span class="token punctuation">|</span> VARIABLE_VALUE <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>
<span class="token output"><span class="token punctuation">|</span> ON             <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></code></pre>
     </div>
     <p>
      A more useful query is shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa63129562"><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> VARIABLE_NAME <span class="token keyword">AS</span> <span class="token keyword">Name</span><span class="token punctuation">,</span> VARIABLE_VALUE <span class="token keyword">AS</span> <span class="token keyword">Value</span>
     <span class="token operator">&gt;</span>   <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>global_variables
     <span class="token operator">&gt;</span>   <span class="token keyword">WHERE</span> VARIABLE_NAME
     <span class="token operator">&gt;</span>     <span class="token keyword">IN</span> <span class="token punctuation">(</span><span class="token string">'version'</span><span class="token punctuation">,</span> <span class="token string">'ndb_version'</span><span class="token punctuation">,</span>
     <span class="token operator">&gt;</span>       <span class="token string">'ndb_version_string'</span><span class="token punctuation">,</span> <span class="token string">'ndbinfo_version'</span><span class="token punctuation">)</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>
<span class="token output"><span class="token punctuation">|</span> Name               <span class="token punctuation">|</span> Value         <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>
<span class="token output"><span class="token punctuation">|</span> ndb_version        <span class="token punctuation">|</span> 524544        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndb_version_string <span class="token punctuation">|</span> ndb<span class="token punctuation">-</span>8.4.0     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo_version    <span class="token punctuation">|</span> 524544        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> version            <span class="token punctuation">|</span> 8.4.0<span class="token punctuation">-</span>cluster <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>
<span class="token output">4 rows in set (0.00 sec)</span></code></pre>
     </div>
     <p>
      For more information, see
      <a class="xref" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
       Section 29.12.15, “Performance Schema Status Variable Tables”
      </a>
      ,
          and
      <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
       Section 7.1.8, “Server System Variables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087168704">
      </a>
      <code class="literal">
       SHOW STATUS LIKE 'NDB%'
      </code>
     </p>
     <p>
      This statement shows at a glance whether or not the MySQL
          server is acting as a cluster SQL node, and if so, it provides
          the MySQL server's cluster node ID, the host name and
          port for the cluster management server to which it is
          connected, and the number of data nodes in the cluster, as
          shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa42484282"><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">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'NDB%'</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>
<span class="token output"><span class="token punctuation">|</span> Variable_name                                <span class="token punctuation">|</span> Value                         <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>
<span class="token output"><span class="token punctuation">|</span> Ndb_metadata_detected_count                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_cluster_node_id                          <span class="token punctuation">|</span> 100                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_config_from_host                         <span class="token punctuation">|</span> 127.0.0.1                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_config_from_port                         <span class="token punctuation">|</span> 1186                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_number_of_data_nodes                     <span class="token punctuation">|</span> 2                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_number_of_ready_data_nodes               <span class="token punctuation">|</span> 2                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_connect_count                            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_execute_count                            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_scan_count                               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_pruned_scan_count                        <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_schema_locks_count                       <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_session     <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_session       <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_session      <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_session             <span class="token punctuation">|</span> 163446                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_session             <span class="token punctuation">|</span> 60                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_session         <span class="token punctuation">|</span> 28                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_session            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_session           <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_session            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_session            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_session                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_session                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_session             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_session             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_session            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_session             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_session               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_session   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_session   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_session <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_session <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_trans_hint_count_session                 <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_sorted_scan_count                        <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_pushed_queries_defined                   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_pushed_queries_dropped                   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_pushed_queries_executed                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_pushed_reads                             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_last_commit_epoch_server                 <span class="token punctuation">|</span> 37632503447571                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_last_commit_epoch_session                <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_system_name                              <span class="token punctuation">|</span> MC_20191126162038             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count_injector            <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count_injector         <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count_injector           <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count_slave       <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count_slave         <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count_slave        <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count_slave               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count_slave               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count_slave           <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count_slave              <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count_slave             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count_slave              <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count_slave              <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count_slave                    <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count_slave                    <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count_slave               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count_slave               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count_slave              <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count_slave               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count_slave                 <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count_slave     <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count_slave     <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count_slave   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count_slave   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_slave_max_replicated_epoch               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_exec_complete_count             <span class="token punctuation">|</span> 4                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_scan_result_count               <span class="token punctuation">|</span> 7                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_meta_request_count              <span class="token punctuation">|</span> 172                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_wait_nanos_count                     <span class="token punctuation">|</span> 1083548094028                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_sent_count                     <span class="token punctuation">|</span> 4640                          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_bytes_received_count                 <span class="token punctuation">|</span> 109356                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_start_count                    <span class="token punctuation">|</span> 4                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_commit_count                   <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_abort_count                    <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_close_count                    <span class="token punctuation">|</span> 4                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pk_op_count                          <span class="token punctuation">|</span> 2                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_uk_op_count                          <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_table_scan_count                     <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_range_scan_count                     <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_pruned_scan_count                    <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_scan_batch_count                     <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_read_row_count                       <span class="token punctuation">|</span> 3                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_trans_local_read_row_count           <span class="token punctuation">|</span> 2                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_forced_count           <span class="token punctuation">|</span> 1                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_unforced_count         <span class="token punctuation">|</span> 5                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_adaptive_send_deferred_count         <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_data_count                     <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_nondata_count                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_api_event_bytes_count                    <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_metadata_excluded_count                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_metadata_synced_count                    <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_max                          <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_old                          <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_max_del_win                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_epoch                        <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_epoch_trans                  <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_epoch2                       <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_fn_epoch2_trans                 <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_trans_row_conflict_count        <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_trans_row_reject_count          <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_trans_reject_count              <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_trans_detect_iter_count         <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_trans_conflict_commit_count     <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_epoch_delete_delete_count       <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_reflected_op_prepare_count      <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_reflected_op_discard_count      <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_refresh_op_count                <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_last_conflict_epoch             <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_conflict_last_stable_epoch               <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token operator">|</span> Ndb_index_stat_status                        <span class="token operator">|</span> allow:<span class="token number">1</span><span class="token punctuation">,</span><span class="token keyword">enable</span>:<span class="token number">1</span><span class="token punctuation">,</span>busy:<span class="token number">0</span><span class="token punctuation">,</span>
<span class="token keyword">loop</span>:<span class="token number">1000</span><span class="token punctuation">,</span><span class="token keyword">list</span>:<span class="token punctuation">(</span><span class="token keyword">new</span>:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">update</span>:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">read</span>:<span class="token number">0</span><span class="token punctuation">,</span>idle:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">check</span>:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">delete</span>:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">error</span>:<span class="token number">0</span><span class="token punctuation">,</span>total:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword">analyze</span>:<span class="token punctuation">(</span>queue:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">wait</span>:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span>stats:<span class="token punctuation">(</span>nostats:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">wait</span>:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span>total:<span class="token punctuation">(</span><span class="token keyword">analyze</span>:<span class="token punctuation">(</span><span class="token keyword">all</span>:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">error</span>:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword">query</span>:<span class="token punctuation">(</span><span class="token keyword">all</span>:<span class="token number">0</span><span class="token punctuation">,</span>nostats:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">error</span>:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span><span class="token keyword">event</span>:<span class="token punctuation">(</span>act:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">skip</span>:<span class="token number">0</span><span class="token punctuation">,</span>miss:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">,</span><span class="token keyword">cache</span>:<span class="token punctuation">(</span>refresh:<span class="token number">0</span><span class="token punctuation">,</span>
clean:<span class="token number">0</span><span class="token punctuation">,</span>pinned:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">drop</span>:<span class="token number">0</span><span class="token punctuation">,</span>evict:<span class="token number">0</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span><span class="token keyword">cache</span>:<span class="token punctuation">(</span><span class="token keyword">query</span>:<span class="token number">0</span><span class="token punctuation">,</span>clean:<span class="token number">0</span><span class="token punctuation">,</span><span class="token keyword">drop</span>:<span class="token number">0</span><span class="token punctuation">,</span>evict:<span class="token number">0</span><span class="token punctuation">,</span>
usedpct:<span class="token number">0.00</span><span class="token punctuation">,</span>highpct:<span class="token number">0.00</span><span class="token punctuation">)</span>                                                     <span class="token operator">|</span>
<span class="token output"><span class="token punctuation">|</span> Ndb_index_stat_cache_query                   <span class="token punctuation">|</span> 0                             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ndb_index_stat_cache_clean                   <span class="token punctuation">|</span> 0                             <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></code></pre>
     </div>
     <p>
      If the MySQL server was built with
      <code class="literal">
       NDB
      </code>
      support, but it is not currently connected to a cluster, every
          row in the output of this statement contains a zero or an
          empty string for the
      <code class="literal">
       Value
      </code>
      column.
     </p>
     <p>
      See also
      <a class="xref" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
       Section 15.7.7.37, “SHOW STATUS Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087144816">
      </a>
      <code class="literal">
       SELECT * FROM performance_schema.global_status WHERE
          VARIABLE_NAME LIKE 'NDB%'
      </code>
     </p>
     <p>
      This statement provides similar output to the
      <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
       <code class="literal">
        SHOW STATUS
       </code>
      </a>
      statement discussed
          in the previous item. Unlike the case with
      <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
       <code class="literal">
        SHOW STATUS
       </code>
      </a>
      , it is possible
          using
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements to
          extract values in SQL for use in scripts for monitoring and
          automation purposes.
     </p>
     <p>
      For more information, see
      <a class="xref" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
       Section 29.12.15, “Performance Schema Status Variable Tables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045087136176">
      </a>
      <code class="literal">
       SELECT * FROM INFORMATION_SCHEMA.PLUGINS WHERE
          PLUGIN_NAME LIKE 'NDB%'
      </code>
     </p>
     <p>
      This statement displays information from the Information
          Schema
      <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
       <code class="literal">
        PLUGINS
       </code>
      </a>
      table about
          plugins associated with NDB Cluster, such as version, author,
          and license, as shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa73937279"><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> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">PLUGINS</span>
     <span class="token operator">&gt;</span>     <span class="token keyword">WHERE</span> PLUGIN_NAME <span class="token operator">LIKE</span> <span class="token string">'NDB%'</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>
           PLUGIN_NAME<span class="token punctuation">:</span> ndbcluster
        PLUGIN_VERSION<span class="token punctuation">:</span> 1.0
         PLUGIN_STATUS<span class="token punctuation">:</span> ACTIVE
           PLUGIN_TYPE<span class="token punctuation">:</span> STORAGE ENGINE
   PLUGIN_TYPE_VERSION<span class="token punctuation">:</span> 80403.0
        PLUGIN_LIBRARY<span class="token punctuation">:</span> NULL
PLUGIN_LIBRARY_VERSION<span class="token punctuation">:</span> NULL
         PLUGIN_AUTHOR<span class="token punctuation">:</span> Oracle Corporation
    PLUGIN_DESCRIPTION<span class="token punctuation">:</span> Clustered, fault-tolerant tables
        PLUGIN_LICENSE<span class="token punctuation">:</span> GPL
           LOAD_OPTION<span class="token punctuation">:</span> ON
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span 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>
           PLUGIN_NAME<span class="token punctuation">:</span> ndbinfo
        PLUGIN_VERSION<span class="token punctuation">:</span> 0.1
         PLUGIN_STATUS<span class="token punctuation">:</span> ACTIVE
           PLUGIN_TYPE<span class="token punctuation">:</span> STORAGE ENGINE
   PLUGIN_TYPE_VERSION<span class="token punctuation">:</span> 80403.0
        PLUGIN_LIBRARY<span class="token punctuation">:</span> NULL
PLUGIN_LIBRARY_VERSION<span class="token punctuation">:</span> NULL
         PLUGIN_AUTHOR<span class="token punctuation">:</span> Oracle Corporation
    PLUGIN_DESCRIPTION<span class="token punctuation">:</span> MySQL Cluster system information storage engine
        PLUGIN_LICENSE<span class="token punctuation">:</span> GPL
           LOAD_OPTION<span class="token punctuation">:</span> ON
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span 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>
           PLUGIN_NAME<span class="token punctuation">:</span> ndb_transid_mysql_connection_map
        PLUGIN_VERSION<span class="token punctuation">:</span> 0.1
         PLUGIN_STATUS<span class="token punctuation">:</span> ACTIVE
           PLUGIN_TYPE<span class="token punctuation">:</span> INFORMATION SCHEMA
   PLUGIN_TYPE_VERSION<span class="token punctuation">:</span> 80403.0
        PLUGIN_LIBRARY<span class="token punctuation">:</span> NULL
PLUGIN_LIBRARY_VERSION<span class="token punctuation">:</span> NULL
         PLUGIN_AUTHOR<span class="token punctuation">:</span> Oracle Corporation
    PLUGIN_DESCRIPTION<span class="token punctuation">:</span> Map between MySQL connection ID and NDB transaction ID
        PLUGIN_LICENSE<span class="token punctuation">:</span> GPL
           LOAD_OPTION<span class="token punctuation">:</span> ON</span></code></pre>
     </div>
     <p>
      You can also use the
      <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
       <code class="literal">
        SHOW
          PLUGINS
       </code>
      </a>
      statement to display this information, but
          the output from that statement cannot easily be filtered. See
          also
      <a class="ulink" href="/doc/extending-mysql/8.4/en/plugin-api.html" target="_top">
       The MySQL Plugin API
      </a>
      , which describes where and
          how the information in the
      <a class="link" href="information-schema-plugins-table.html" title="28.3.22 The INFORMATION_SCHEMA PLUGINS Table">
       <code class="literal">
        PLUGINS
       </code>
      </a>
      table is obtained.
     </p>
    </li>
   </ul>
  </div>
  <p>
   You can also query the tables in the
   <a class="link" href="mysql-cluster-ndbinfo.html" title="25.6.17 ndbinfo: The NDB Cluster Information Database">
    <code class="literal">
     ndbinfo
    </code>
   </a>
   information database for
      real-time data about many NDB Cluster operations. See
   <a class="xref" href="mysql-cluster-ndbinfo.html" title="25.6.17 ndbinfo: The NDB Cluster Information Database">
    Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
