<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-ndb-transid-mysql-connection-map-table">
      </a>
      28.3.18 The INFORMATION_SCHEMA ndb_transid_mysql_connection_map Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045079514080">
  </a>
  <p>
   The
   <code class="literal">
    ndb_transid_mysql_connection_map
   </code>
   table
      provides a mapping between
   <code class="literal">
    NDB
   </code>
   transactions,
   <code class="literal">
    NDB
   </code>
   transaction coordinators, and MySQL Servers
      attached to an NDB Cluster as API nodes. This information is used
      when populating the
   <a class="link" href="mysql-cluster-ndbinfo-server-operations.html" title="25.6.17.55 The ndbinfo server_operations Table">
    <code class="literal">
     server_operations
    </code>
   </a>
   and
   <a class="link" href="mysql-cluster-ndbinfo-server-transactions.html" title="25.6.17.56 The ndbinfo server_transactions Table">
    <code class="literal">
     server_transactions
    </code>
   </a>
   tables of
      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>
   NDB Cluster
      information database.
  </p>
  <div class="informaltable">
   <table summary="Columns in the INFORMATION_SCHEMA ndb_transid_mysql_connection_map table. The table lists INFORMATION_SCHEMA names along with corresponding SHOW names (if applicable), and remarks.">
    <colgroup>
     <col style="width: 40%"/>
     <col style="width: 30%"/>
     <col style="width: 30%"/>
    </colgroup>
    <thead>
     <tr>
      <th scope="col">
       <code class="literal">
        INFORMATION_SCHEMA
       </code>
       Name
      </th>
      <th scope="col">
       <code class="literal">
        SHOW
       </code>
       Name
      </th>
      <th scope="col">
       Remarks
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <th scope="row">
       <code class="literal">
        mysql_connection_id
       </code>
      </th>
      <td>
      </td>
      <td>
       MySQL Server connection ID
      </td>
     </tr>
     <tr>
      <th scope="row">
       <code class="literal">
        node_id
       </code>
      </th>
      <td>
      </td>
      <td>
       Transaction coordinator node ID
      </td>
     </tr>
     <tr>
      <th scope="row">
       <code class="literal">
        ndb_transid
       </code>
      </th>
      <td>
      </td>
      <td>
       <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
        <code class="literal">
         NDB
        </code>
       </a>
       transaction ID
      </td>
     </tr>
    </tbody>
   </table>
  </div>
  <p>
   The
   <code class="literal">
    mysql_connection_id
   </code>
   is the same as the
      connection or session ID shown in the output of
   <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
    <code class="literal">
     SHOW PROCESSLIST
    </code>
   </a>
   .
  </p>
  <p>
   There are no
   <code class="literal">
    SHOW
   </code>
   statements associated with
      this table.
  </p>
  <p>
   This is a nonstandard table, specific to NDB Cluster. It is
      implemented as an
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   plugin;
      you can verify that it is supported by checking the output of
   <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    <code class="literal">
     SHOW PLUGINS
    </code>
   </a>
   . If
   <code class="literal">
    ndb_transid_mysql_connection_map
   </code>
   support is
      enabled, the output from this statement includes a plugin having
      this name, of type
   <code class="literal">
    INFORMATION SCHEMA
   </code>
   , and
      having status
   <code class="literal">
    ACTIVE
   </code>
   , as shown here (using
      emphasized text):
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa78673417"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">PLUGINS</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Name                             <span class="token punctuation">|</span> Status <span class="token punctuation">|</span> Type               <span class="token punctuation">|</span> Library <span class="token punctuation">|</span> License <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> binlog                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysql_native_password            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sha256_password                  <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> caching_sha2_password            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUTHENTICATION     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sha2_cache_cleaner               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUDIT              <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> daemon_keyring_proxy_plugin      <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> DAEMON             <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> CSV                              <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MEMORY                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> InnoDB                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_TRX                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> INNODB_CMP                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>

<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>

<span class="token output"><span class="token punctuation">|</span> INNODB_SESSION_TEMP_TABLESPACES  <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MyISAM                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> MRG_MYISAM                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PERFORMANCE_SCHEMA               <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TempTable                        <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ARCHIVE                          <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> BLACKHOLE                        <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbcluster                       <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ndbinfo                          <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> STORAGE ENGINE     <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation"></span><em><span class="token punctuation">|</span> ndb_transid_mysql_connection_map <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> INFORMATION SCHEMA <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></em><span class="token punctuation"></span></span>
<span class="token output"><span class="token punctuation">|</span> ngram                            <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> FTPARSER           <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysqlx_cache_cleaner             <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> AUDIT              <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> mysqlx                           <span class="token punctuation">|</span> ACTIVE <span class="token punctuation">|</span> DAEMON             <span class="token punctuation">|</span> NULL    <span class="token punctuation">|</span> GPL     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">47 rows in set (0.01 sec)</span></code></pre>
  </div>
  <p>
   The plugin is enabled by default. You can disable it (or force the
      server not to run unless the plugin starts) by starting the server
      with the
   <a class="link" href="mysql-cluster-options-variables.html#option_mysqld_ndb-transid-mysql-connection-map">
    <code class="option">
     --ndb-transid-mysql-connection-map
    </code>
   </a>
   option. If the plugin is disabled, the status is shown by
   <a class="link" href="show-plugins.html" title="15.7.7.27 SHOW PLUGINS Statement">
    <code class="literal">
     SHOW PLUGINS
    </code>
   </a>
   as
   <code class="literal">
    DISABLED
   </code>
   . The plugin cannot be enabled or
      disabled at runtime.
  </p>
  <p>
   Although the names of this table and its columns are displayed
      using lowercase, you can use uppercase or lowercase when referring
      to them in SQL statements.
  </p>
  <p>
   For this table to be created, the MySQL Server must be a binary
      supplied with the NDB Cluster distribution, or one built from the
      NDB Cluster sources with
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   storage
      engine support enabled. It is not available in the standard MySQL
      8.4 Server.
  </p>
 </div>
 <br/>
</div>
