<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-transporters">
      </a>
      25.6.17.66 The ndbinfo transporters Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045087429456">
  </a>
  <p>
   This table contains information about NDB transporters. For
        similar information about individual transporters, see the
   <a class="link" href="mysql-cluster-ndbinfo-transporter-details.html" title="25.6.17.65 The ndbinfo transporter_details Table">
    <code class="literal">
     transporter_details
    </code>
   </a>
   table.
  </p>
  <p>
   The
   <code class="literal">
    transporters
   </code>
   table contains the following
        columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       node_id
      </code>
     </p>
     <p>
      This data node's unique node ID in the cluster
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       remote_node_id
      </code>
     </p>
     <p>
      The remote data node's node ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       status
      </code>
     </p>
     <p>
      Status of the connection
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       remote_address
      </code>
     </p>
     <p>
      Name or IP address of the remote host
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       bytes_sent
      </code>
     </p>
     <p>
      Number of bytes sent using this connection
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       bytes_received
      </code>
     </p>
     <p>
      Number of bytes received using this connection
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       connect_count
      </code>
     </p>
     <p>
      Number of times connection established on this transporter
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       overloaded
      </code>
     </p>
     <p>
      1 if this transporter is currently overloaded, otherwise 0
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       overload_count
      </code>
     </p>
     <p>
      Number of times this transporter has entered overload state
            since connecting
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       slowdown
      </code>
     </p>
     <p>
      1 if this transporter is in slowdown state, otherwise 0
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       slowdown_count
      </code>
     </p>
     <p>
      Number of times this transporter has entered slowdown state
            since connecting
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       encrypted
      </code>
     </p>
     <p>
      If this transporter is connected using TLS, this column is
      <code class="literal">
       1
      </code>
      , otherwise it is
      <code class="literal">
       0
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <h5>
   <a name="idm46045087400032">
   </a>
   Notes
  </h5>
  <p>
   For each running data node in the cluster, the
   <code class="literal">
    transporters
   </code>
   table displays a row showing the
        status of each of that node's connections with all nodes in
        the cluster,
   <span class="emphasis">
    <em>
     including itself
    </em>
   </span>
   . This
        information is shown in the table's
   <span class="emphasis">
    <em>
     status
    </em>
   </span>
   column, which can have any one of
        the following values:
   <code class="literal">
    CONNECTING
   </code>
   ,
   <code class="literal">
    CONNECTED
   </code>
   ,
   <code class="literal">
    DISCONNECTING
   </code>
   ,
        or
   <code class="literal">
    DISCONNECTED
   </code>
   .
  </p>
  <p>
   Connections to API and management nodes which are configured but
        not currently connected to the cluster are shown with status
   <code class="literal">
    DISCONNECTED
   </code>
   . Rows where the
   <code class="literal">
    node_id
   </code>
   is that of a data node which is not
        currently connected are not shown in this table. (This is
        similar omission of disconnected nodes in the
   <a class="link" href="mysql-cluster-ndbinfo-nodes.html" title="25.6.17.48 The ndbinfo nodes Table">
    <code class="literal">
     ndbinfo.nodes
    </code>
   </a>
   table.
  </p>
  <p>
   The
   <code class="literal">
    remote_address
   </code>
   is the host name or
        address for the node whose ID is shown in the
   <code class="literal">
    remote_node_id
   </code>
   column. The
   <code class="literal">
    bytes_sent
   </code>
   from this node and
   <code class="literal">
    bytes_received
   </code>
   by this node are the numbers,
        respectively, of bytes sent and received by the node using this
        connection since it was established. For nodes whose status is
   <code class="literal">
    CONNECTING
   </code>
   or
   <code class="literal">
    DISCONNECTED
   </code>
   , these columns always display
   <code class="literal">
    0
   </code>
   .
  </p>
  <p>
   Assume you have a 5-node cluster consisting of 2 data nodes, 2
        SQL nodes, and 1 management node, as shown in the output of the
   <a class="link" href="mysql-cluster-mgm-client-commands.html#ndbclient-show">
    <code class="literal">
     SHOW
    </code>
   </a>
   command in the
   <a class="link" href="mysql-cluster-programs-ndb-mgm.html" title="25.5.5 ndb_mgm — The NDB Cluster Management Client">
    <span class="command">
     <strong>
      ndb_mgm
     </strong>
    </span>
   </a>
   client:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ndbmgm"><div class="docs-select-all right" id="sa2575624"><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-ndbmgm"><span class="token prompt">ndb_mgm&gt;</span> <span class="token keyword">SHOW</span>
Connected to Management Server at<span class="token operator">:</span> localhost<span class="token operator">:</span>1186 <span class="token punctuation">(</span>using cleartext<span class="token punctuation">)</span>
Cluster Configuration
<span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">--</span><span class="token operator">-</span>
<span class="token selector">[ndbd(NDB)]</span>     2 node<span class="token punctuation">(</span>s<span class="token punctuation">)</span>
id<span class="token operator">=</span>1    @10<span class="token punctuation">.</span>100<span class="token punctuation">.</span>10<span class="token punctuation">.</span>1  <span class="token punctuation">(</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token operator">-</span>ndb<span class="token operator">-</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token punctuation">,</span> Nodegroup<span class="token operator">:</span> 0<span class="token punctuation">,</span> <span class="token operator">*</span><span class="token punctuation">)</span>
id<span class="token operator">=</span>2    @10<span class="token punctuation">.</span>100<span class="token punctuation">.</span>10<span class="token punctuation">.</span>2  <span class="token punctuation">(</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token operator">-</span>ndb<span class="token operator">-</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token punctuation">,</span> Nodegroup<span class="token operator">:</span> 0<span class="token punctuation">)</span>

<span class="token selector">[ndb_mgmd(MGM)]</span> 1 node<span class="token punctuation">(</span>s<span class="token punctuation">)</span>
id<span class="token operator">=</span>10   @10<span class="token punctuation">.</span>100<span class="token punctuation">.</span>10<span class="token punctuation">.</span>10  <span class="token punctuation">(</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token operator">-</span>ndb<span class="token operator">-</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token punctuation">)</span>

<span class="token selector">[mysqld(API)]</span>   2 node<span class="token punctuation">(</span>s<span class="token punctuation">)</span>
id<span class="token operator">=</span>20   @10<span class="token punctuation">.</span>100<span class="token punctuation">.</span>10<span class="token punctuation">.</span>20  <span class="token punctuation">(</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token operator">-</span>ndb<span class="token operator">-</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token punctuation">)</span>
id<span class="token operator">=</span>21   @10<span class="token punctuation">.</span>100<span class="token punctuation">.</span>10<span class="token punctuation">.</span>21  <span class="token punctuation">(</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token operator">-</span>ndb<span class="token operator">-</span>8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>0<span class="token punctuation">)</span></code></pre>
  </div>
  <p>
   There are 10 rows in the
   <code class="literal">
    transporters
   </code>
   table—5 for the first data node, and 5 for the
        second—assuming that all data nodes are running, as shown
        here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa90649230"><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 output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> remote_node_id <span class="token punctuation">|</span> status     <span class="token punctuation">|</span> remote_address <span class="token punctuation">|</span> bytes_sent <span class="token punctuation">|</span> bytes_received <span class="token punctuation">|</span> connect_count <span class="token punctuation">|</span> overloaded <span class="token punctuation">|</span> overload_count <span class="token punctuation">|</span> slowdown <span class="token punctuation">|</span> slowdown_count <span class="token punctuation">|</span> encrypted <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>              6 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>   15509748 <span class="token punctuation">|</span>       15558204 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>             50 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>    1058220 <span class="token punctuation">|</span>         284316 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>            100 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>     574796 <span class="token punctuation">|</span>         402208 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>            101 <span class="token punctuation">|</span> CONNECTING <span class="token punctuation">|</span> <span class="token punctuation">-</span>              <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>             0 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>              5 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>   15558204 <span class="token punctuation">|</span>       15509748 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>             50 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>    1054548 <span class="token punctuation">|</span>         283812 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>            100 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span> 127.0.0.1      <span class="token punctuation">|</span>     529948 <span class="token punctuation">|</span>         397444 <span class="token punctuation">|</span>             1 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>            101 <span class="token punctuation">|</span> CONNECTING <span class="token punctuation">|</span> <span class="token punctuation">-</span>              <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>             0 <span class="token punctuation">|</span>          0 <span class="token punctuation">|</span>              0 <span class="token punctuation">|</span>        0 <span class="token punctuation">|</span>              0 <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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa54826205"><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> node_id<span class="token punctuation">,</span> remote_node_id<span class="token punctuation">,</span> <span class="token keyword">status</span>
<span class="token prompt">    -&gt;</span>   <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>transporters<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>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> remote_node_id <span class="token punctuation">|</span> status        <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>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>              1 <span class="token punctuation">|</span> DISCONNECTED  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>              2 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             10 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             20 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             21 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       2 <span class="token punctuation">|</span>              1 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       2 <span class="token punctuation">|</span>              2 <span class="token punctuation">|</span> DISCONNECTED  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       2 <span class="token punctuation">|</span>             10 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       2 <span class="token punctuation">|</span>             20 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       2 <span class="token punctuation">|</span>             21 <span class="token punctuation">|</span> CONNECTED     <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>
<span class="token output">10 rows in set (0.04 sec)</span></code></pre>
  </div>
  <p>
   If you shut down one of the data nodes in this cluster using the
        command
   <code class="literal">
    2 STOP
   </code>
   in the
   <a class="link" href="mysql-cluster-programs-ndb-mgm.html" title="25.5.5 ndb_mgm — The NDB Cluster Management Client">
    <span class="command">
     <strong>
      ndb_mgm
     </strong>
    </span>
   </a>
   client, then repeat the previous
        query (again using the
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client), this
        table now shows only 5 rows—1 row for each connection from
        the remaining management node to another node, including both
        itself and the data node that is currently offline—and
        displays
   <code class="literal">
    CONNECTING
   </code>
   for the status of each
        remaining connection to the data node that is currently offline,
        as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa35900537"><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> node_id<span class="token punctuation">,</span> remote_node_id<span class="token punctuation">,</span> <span class="token keyword">status</span>
<span class="token prompt">    -&gt;</span>   <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>transporters<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>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> remote_node_id <span class="token punctuation">|</span> status        <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>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>              1 <span class="token punctuation">|</span> DISCONNECTED  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>              2 <span class="token punctuation">|</span> CONNECTING    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             10 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             20 <span class="token punctuation">|</span> CONNECTED     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       1 <span class="token punctuation">|</span>             21 <span class="token punctuation">|</span> CONNECTED     <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>
<span class="token output">5 rows in set (0.02 sec)</span></code></pre>
  </div>
  <p>
   The
   <code class="literal">
    connect_count
   </code>
   ,
   <code class="literal">
    overloaded
   </code>
   ,
   <code class="literal">
    overload_count
   </code>
   ,
   <code class="literal">
    slowdown
   </code>
   ,
        and
   <code class="literal">
    slowdown_count
   </code>
   counters are reset on
        connection, and retain their values after the remote node
        disconnects. The
   <code class="literal">
    bytes_sent
   </code>
   and
   <code class="literal">
    bytes_received
   </code>
   counters are also reset on
        connection, and so retain their values following disconnection
        (until the next connection resets them).
  </p>
  <p>
   The
   <span class="emphasis">
    <em>
     overload
    </em>
   </span>
   state referred to by the
   <code class="literal">
    overloaded
   </code>
   and
   <code class="literal">
    overload_count
   </code>
   columns occurs when this
        transporter's send buffer contains more than
   <a class="link" href="mysql-cluster-tcp-definition.html#ndbparam-tcp-overloadlimit">
    <code class="literal">
     OVerloadLimit
    </code>
   </a>
   bytes
        (default is 80% of
   <a class="link" href="mysql-cluster-tcp-definition.html#ndbparam-tcp-sendbuffermemory">
    <code class="literal">
     SendBufferMemory
    </code>
   </a>
   , that
        is, 0.8 * 2097152 = 1677721 bytes). When a given transporter is
        in a state of overload, any new transaction that tries to use
        this transporter fails with Error 1218 (
   <span class="errortext">
    Send Buffers
        overloaded in NDB kernel
   </span>
   ). This affects both scans
        and primary key operations.
  </p>
  <p>
   The
   <span class="emphasis">
    <em>
     slowdown
    </em>
   </span>
   state referenced by the
   <code class="literal">
    slowdown
   </code>
   and
   <code class="literal">
    slowdown_count
   </code>
   columns of this table occurs
        when the transporter's send buffer contains more than 60%
        of the overload limit (equal to 0.6 * 2097152 = 1258291 bytes by
        default). In this state, any new scan using this transporter has
        its batch size reduced to minimize the load on the transporter.
  </p>
  <p>
   Common causes of send buffer slowdown or overloading include the
        following:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Data size, in particular the quantity of data stored in
      <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
       <code class="literal">
        TEXT
       </code>
      </a>
      columns or
      <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
       <code class="literal">
        BLOB
       </code>
      </a>
      columns (or both types
            of columns)
     </p>
    </li>
    <li class="listitem">
     <p>
      Having a data node (ndbd or ndbmtd) on the same host as an
            SQL node that is engaged in binary logging
     </p>
    </li>
    <li class="listitem">
     <p>
      Large number of rows per transaction or transaction batch
     </p>
    </li>
    <li class="listitem">
     <p>
      Configuration issues such as insufficient
      <a class="link" href="mysql-cluster-tcp-definition.html#ndbparam-tcp-sendbuffermemory">
       <code class="literal">
        SendBufferMemory
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      Hardware issues such as insufficient RAM or poor network
            connectivity
     </p>
    </li>
   </ul>
  </div>
  <p>
   See also
   <a class="xref" href="mysql-cluster-config-send-buffers.html" title="25.4.3.14 Configuring NDB Cluster Send Buffer Parameters">
    Section 25.4.3.14, “Configuring NDB Cluster Send Buffer Parameters”
   </a>
   .
  </p>
  <p>
   If TLS is used for the connection, the
   <code class="literal">
    encrypted
   </code>
   column is
   <code class="literal">
    1
   </code>
   , as
        shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa18121875"><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> node_id<span class="token punctuation">,</span> remote_node_id<span class="token punctuation">,</span> <span class="token keyword">status</span><span class="token punctuation">,</span> encrypted 
<span class="token prompt">    -&gt;</span> <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>transporters<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>
<span class="token output"><span class="token punctuation">|</span> node_id <span class="token punctuation">|</span> remote_node_id <span class="token punctuation">|</span> status     <span class="token punctuation">|</span> encrypted <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>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>              6 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>             50 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>            100 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       5 <span class="token punctuation">|</span>            101 <span class="token punctuation">|</span> CONNECTING <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>              5 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>             50 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>            100 <span class="token punctuation">|</span> CONNECTED  <span class="token punctuation">|</span>         1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>       6 <span class="token punctuation">|</span>            101 <span class="token punctuation">|</span> CONNECTING <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>
<span class="token output">8 rows in set (0.04 sec)</span></code></pre>
  </div>
  <p>
   Otherwise, the value of this column is
   <code class="literal">
    0
   </code>
   .
  </p>
  <p>
   The
   <a class="link" href="mysql-cluster-ndbinfo-certificates.html" title="25.6.17.6 The ndbinfo certificates Table">
    <code class="literal">
     certificates
    </code>
   </a>
   table can be
        used to obtain certificate information about each node connected
        using link encryption.
  </p>
  <p>
   For more information, see
   <a class="xref" href="mysql-cluster-tls.html" title="25.6.15 TLS Link Encryption for NDB Cluster">
    Section 25.6.15, “TLS Link Encryption for NDB Cluster”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
