ndbinfo: The NDB Cluster Information Database Notes 23.5.14.46 The ndbinfo server_transactions Table 4581 Transaction coordinator block instance Transaction coordinator node ID MySQL Server connection ID The  server_transactions  table contains the following columns: The  server_transactions  table is subset of the  cluster_transactions  table, but includes only those transactions in which the current SQL node (MySQL Server) is a participant, while including the relevant connection IDs. The  block_instance  and  tc_block_instance  column provide NDB kernel block instance numbers. You can use these to obtain information about specific threads from the  threadblocks  table. In  client_node_id  and  client_block_ref ,  client  refers to an NDB Cluster API or SQL node (that is, an NDB API client or a MySQL Server attached to the cluster). The  fragid  is the same as the partition number seen in the output of  ndb_desc --extra-partition- info  (short form  -p ). You can obtain the name of an  NDB  table from its table ID by checking the output of  ndb_show_tables . The  state  column can have any one of the values  ABORT_QUEUED ,  ABORT_STOPPED , COMMITTED ,  COMMIT_QUEUED ,  COMMIT_STOPPED ,  COPY_CLOSE_STOPPED , COPY_FIRST_STOPPED ,  COPY_STOPPED ,  COPY_TUPKEY ,  IDLE ,  LOG_ABORT_QUEUED , LOG_COMMIT_QUEUED ,  LOG_COMMIT_QUEUED_WAIT_SIGNAL ,  LOG_COMMIT_WRITTEN , LOG_COMMIT_WRITTEN_WAIT_SIGNAL ,  LOG_QUEUED ,  PREPARED ,  PREPARED_RECEIVED_COMMIT , SCAN_CHECK_STOPPED ,  SCAN_CLOSE_STOPPED ,  SCAN_FIRST_STOPPED ,  SCAN_RELEASE_STOPPED , SCAN_STATE_USED ,  SCAN_STOPPED ,  SCAN_TUPKEY ,  STOPPED ,  TC_NOT_CONNECTED ,  WAIT_ACC , WAIT_ACC_ABORT ,  WAIT_AI_AFTER_ABORT ,  WAIT_ATTR ,  WAIT_SCAN_AI ,  WAIT_TUP , WAIT_TUPKEYINFO ,  WAIT_TUP_COMMIT , or  WAIT_TUP_TO_ABORT . (If the MySQL Server is running with  ndbinfo_show_hidden  enabled, you can view this list of states by selecting from the  ndb $dblqh_tcconnect_state  table, which is normally hidden.) The  operation_type  column can take any one of the values  READ ,  READ-SH ,  READ-EX ,  INSERT , UPDATE ,  DELETE ,  WRITE ,  UNLOCK ,  REFRESH ,  SCAN ,  SCAN-SH ,  SCAN-EX , or  <unknown> . The transaction ID ( transid ) is a unique 64-bit number which can be obtained using the NDB API’s getTransactionId()  method. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.) block_instance  refers to an instance of a kernel block. Together with the block name, this number can be used to look up a given instance in the  threadblocks  table. The  mysql_connection_id  is the same as the connection or session ID shown in the output of  SHOW PROCESSLIST . It is obtained from the  INFORMATION_SCHEMA  table NDB_TRANSID_MYSQL_CONNECTION_MAP . • block_instance • node_id • mysql_connection_id